Explain with runtime stats

sql

EXPLAIN (ANALYZE, BUFFERS)
SELECT *
FROM orders
WHERE shipped_at IS NULL
ORDER BY created_at DESC
LIMIT 100;

Explanation

This is one of the most useful PostgreSQL performance tools for validating index choices.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Plan inspection

Default choice for equality, ranges, and ordering.

Open In sheetsql1 tag match

Speed containment queries on JSONB data.

Open In sheetsql1 tag match

Use BRIN when physical order correlates with query ranges.

Open In sheetsql1 tag match

Index the result of an expression used in predicates.

Open In sheetsql1 tag match

Index only the rows a hot query actually needs.

Open In sheetsql1 tag match

Reduce blocking on busy tables.

Open In sheetsql1 tag match