PREDICTION

Predict Query Time

Predict query execution time with confidence intervals.

Returns median prediction with 80% confidence interval. Uses model_with_historical for repeated queries or model_without_historical for new queries.

post/predict/query-time-estimate

Request

  • Base URL: https://api.myaltimate.com (the document declares no server; this is the origin it was published from)
  • URL: https://api.myaltimate.com/predict/query-time-estimate
  • Auth: one of:
    • HTTP bearer
    • HTTP bearer

Request body

query_textstring required

SQL query text to predict execution time for

warehouse_size'X-Small' | 'Small' | 'Medium' | 'Large' | 'X-Large' | '2X-Large' | '3X-Large' | '4X-Large'

Snowflake warehouse size

warehouse_type'UNKNOWN' | 'STANDARD_GEN_1' | 'STANDARD_GEN_2' | 'MEMORY_16X'

Warehouse generation/type

Response

Successful Response

predicted_msnumber required

Median prediction (q50) in milliseconds

quantilesobject required

All quantile predictions: q10, q50, q90

model_used'with_historical' | 'without_historical' required

with_historical (repeated query) or without_historical (new query)

query_hashstring required

Computed query hash

Changes

No recorded changes to this operation across all 82 revisions of this API.