On Wed, Jan 10, 2018 at 03:05:39PM +0100, Julian Markwort wrote: > Hello hackers, > > I'd like to follow up to my previous proposition of tracking (some) best and > worst plans for different queries in the pg_stat_statements extension. > > Based on the comments and suggestions made towards my last endeavour, I've > taken the path of computing the interquartile distance (by means of an > adapted z-test, under the assumption of normal distribution, based on the > mean_time and stddev_time already used by the extension).
Is the assumption of a normal distribution reasonable for outlier plans as you've seen them? Best, David. -- David Fetter <david(at)fetter(dot)org> http://fetter.org/ Phone: +1 415 235 3778 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
