Explain PostgreSQL
New plan
Archive
Standardized query
Donate
Download
Self-hosted
Plugins
API
About
En
Ru
Explain / Explain Analyze
Copy&Paste or Drag'n'Drop ↓
public archive
Sample Plans...
-- Algorithm only (COSTS OFF)
-- With quotes from pgAdmin (ANALYZE)
-- JSON-format
-- Directly from log with query
-- From psql with the header
-- From the "narrow" console
for information about data allocation in memory and disk usage time, use
SET
track_io_timing
= TRUE;
EXPLAIN
(ANALYZE, BUFFERS) { SELECT | INSERT | UPDATE | DELETE } …
Source query
do not publish in the archive
Explain It!