Re: Add min and max execute statement time in pg_stat_statement
От | Peter Eisentraut |
---|---|
Тема | Re: Add min and max execute statement time in pg_stat_statement |
Дата | |
Msg-id | 54E3E91C.4020105@gmx.net обсуждение исходный текст |
Ответ на | Re: Add min and max execute statement time in pg_stat_statement (David G Johnston <david.g.johnston@gmail.com>) |
Ответы |
Re: Add min and max execute statement time in pg_stat_statement
Re: Add min and max execute statement time in pg_stat_statement |
Список | pgsql-hackers |
On 1/20/15 6:32 PM, David G Johnston wrote: > In fact, as far as > the database knows, the values provided to this function do represent an > entire population and such a correction would be unnecessary. I guess it > boils down to whether "future" queries are considered part of the population > or whether the population changes upon each query being run and thus we are > calculating the ever-changing population variance. I think we should be calculating the population variance. We are clearly taking the population to be all past queries (from the last reset point). Otherwise calculating min and max wouldn't make sense.
В списке pgsql-hackers по дате отправления: