Postgres research topic

Slow Query Analysis

Daily notes on pg_stat_statements, query fingerprints, EXPLAIN plans, workload evidence, and proof-backed diagnosis.

Published notes

Evidence-backed notes in this cluster.

/Field note

pg_stat_statements as a Trust Boundary

Why QueryRook treats pg_stat_statements as a safer first evidence source than raw query logs or copied application data.

Open note
Editorial queue

Upcoming notes for this topic.

May 9

Detecting Plan Regression With Small Samples

Show how small-sample query analysis should avoid overclaiming while still catching obvious plan regressions.

Before/after plan hashSample-size caveatLatency distribution note