Postgres FM

Mean vs p99

38:51

Nikolay and Michael discuss looking at queries by mean time — when it makes sense, why ordering by a percentile (like p99) might be better, and the merits of approximating percentiles in pg_stat_statements using the standard deviation column. Here are some links to things they mentioned:

Approximate the p99 of a query with pg_stat_statements (blog post by Michael)…