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)…