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 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