A utility command for showing the execution plan of a statement
EXPLAIN is a utility command for showing the execution plan of a statement.
EXPLAIN has been present in all PostgreSQL versions.
- PostgreSQL 13
WALoption added (commit 33e05f89)
- PostgreSQL 12
SETTINGSoption added (commit ea569d64)
- PostgreSQL 11
- parallel workers' sort activity displayed in output (commit bf11e7ee)
- PostgreSQL 10
SUMMARYoption added (commit f9b1a0dd)
- PostgreSQL 9.2
TIMINGoption added (commit af7914c6)
- PostgreSQL 9.0
- PostgreSQL 7.2
ANALYZEoption added (commit 89fa5518)