Browse categories
PostgreSQL releases
- PostgreSQL 14 (dev)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Useful links
Categories

EXPLAIN

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.

Change history

PostgreSQL 13
- WAL option added (commit 33e05f89)
PostgreSQL 12
- SETTINGS option added (commit ea569d64)
PostgreSQL 11
- parallel workers' sort activity displayed in output (commit bf11e7ee)
PostgreSQL 10
- SUMMARY option added (commit f9b1a0dd)
PostgreSQL 9.2
- TIMING option added (commit af7914c6)
PostgreSQL 9.0
- EXPLAIN (option [, ...]) syntax added (commit d4382c4a)
- BUFFERS option added (commit cddca5ec)
- COSTS option added (commit d4382c4a)
- FORMAT option added with following output formats:
  - TEXT (default)
  - JSON (commit 9bd27b7c)
  - YAML (commit 324385d6)
  - XML (commit 9bd27b7c)
PostgreSQL 7.2
- ANALYZE option added (commit 89fa5518)

References

PostgreSQL documentation: EXPLAIN
PostgreSQL documentation: Using EXPLAIN

Useful links

explain.depesz.com - an online tool for visualizing EXPLAIN output
PostgreSQL Explain - a useful glossary from the pgMustard project

Categories