Skip to main content
The EXPLAIN statement forecasts query results without purchasing or executing. Use it to preview data availability and estimated costs.

​
Syntax

EXPLAIN
SELECT ...

​
What EXPLAIN returns

  • Estimated row count matching your criteria
  • Estimated cost based on data pricing
  • Data freshness information
  • Result schema

​
Example

EXPLAIN
SELECT
  company_data."123".user_id,
  company_data."123".email
FROM company_data."123"
WHERE
  company_data."123".created_at > CURRENT_DATE - INTERVAL '30' DAY
  AND company_data."123"._price_cpm_usd <= 1.00
Always run EXPLAIN before creating a materialized view to understand data availability and cost.

​
Related content

SELECT

Full SELECT statement reference

CREATE MATERIALIZED VIEW

Create stored datasets from queries

Pricing

Understanding data costs