Explain / Explain Analyze
Copy&Paste or Drag'n'Drop ↓
public archive
for information about data allocation in memory and disk usage time, use
SET track_io_timing = TRUE; EXPLAIN (ANALYZE, BUFFERS) { SELECT | INSERT | UPDATE | DELETE } …