EXPLAIN

Synopsis

EXPLAIN statement

Description

Show the Polars SQL plan for a statement without executing the statement. This documentation covers basic EXPLAIN for SELECT statements.

Additional output formats, plan types, IO summaries, and distributed fragment examples are not documented here because their output is not the Polars SQL plan format.

Examples

Explain a simple query:

EXPLAIN SELECT 1 AS id

Explain a query over a table:

EXPLAIN SELECT id FROM orders WHERE id > 0