This is a prerelease version.

View latest

EXPLAIN

The EXPLAIN statement returns the execution plan for a given statement, without executing it. You can use this statement to debug long-running queries and learn how to optimize them.

Syntax Summary

This code block is a quick reference for the EXPLAIN statement.

See some practical examples.

EXPLAIN statement

Parameters

All statements can be used as parameters to the EXPLAIN statement.

Examples

This section lists some example SQL queries that show you how to use the EXPLAIN statement.

Full table scans

EXPLAIN SELECT * FROM cities WHERE countries = 'United Kingdom';
+--------------------+
|rel                 |
+--------------------+
|FullScanPhysicalRel…|
+--------------------+