Skip to main content

Explain Report Template

Migration File: VYYYYMMDDHHMMSS__index-<name>.sql

Critical Query IDs:

  • CQ-001

Query​

EXPLAIN (ANALYZE, BUFFERS, VERBOSE, FORMAT JSON)
SELECT ...;

BEFORE PLAN​

[paste explain analyze output before index]

AFTER PLAN​

[paste explain analyze output after index]

Decision​

  • Expected improvement:
  • Observed plan change:
  • Regression check:
  • Keep / Reject: