EXPLAIN

Inspect a query plan through the Query API.

The Query API accepts a statement that starts with EXPLAIN. The server parses the rest of the statement as an explain query.

Syntax

EXPLAIN <query>

Use the indexes option to inspect index pruning for a table query.

EXPLAIN indexes = 1
SELECT <columns> FROM <table> WHERE <condition>

Explain a scalar query.

EXPLAIN SELECT 1

SELECT

Read data through the Query API with SELECT or WITH.

DESCRIBE

Inspect columns and types with a DESCRIBE query.