EXPLAIN

EXPLAIN is deprecated. Its forecasts are not reliably accurate and the statement is no longer maintained. Avoid using EXPLAIN in production workflows. This page is retained for reference only.

The EXPLAIN statement was intended to forecast query results without purchasing or executing — previewing 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

SELECT

Full SELECT statement reference

CREATE MATERIALIZED VIEW

Create stored datasets from queries

Pricing

Understanding data costs

Overview

Data Types

SQL Commands

Operators

Functions

General Reference

Syntax

What EXPLAIN returns

Example

SELECT

CREATE MATERIALIZED VIEW

Pricing

​Syntax

​What EXPLAIN returns

​Example

​Related content

SELECT

CREATE MATERIALIZED VIEW

Pricing

Syntax

What EXPLAIN returns

Example

Related content