Andrew Atkinson on Mythryl: ““A query that runs in 1ms 99% of the time and 2 seconds the other 1%…”

“A query that runs in 1ms 99% of the time and 2 seconds the other 1% has a mean_exec_time around 21ms, a number that matches none of its real executions and hides the p99 that's paging your on-call.” @boringsql.com boringsql.com/posts/pg-sta...

boringsql.compg_stat_statements: everything it tells youWhat pg_stat_statements records and what it quietly drops: the queryid jumble that splits one query into many rows, the frozen first-seen query text, and averages that hide your p99.

3/6/26, 7:22 pm0 reposts3 likes

Post