Re: [PROPOSAL] timestamp informations to pg_stat_statements
От | Tom Lane |
---|---|
Тема | Re: [PROPOSAL] timestamp informations to pg_stat_statements |
Дата | |
Msg-id | 9278.1468797341@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: [PROPOSAL] timestamp informations to pg_stat_statements (Peter Geoghegan <pg@heroku.com>) |
Ответы |
Re: [PROPOSAL] timestamp informations to pg_stat_statements
Re: [HACKERS] [PROPOSAL] timestamp informations to pg_stat_statements |
Список | pgsql-hackers |
Peter Geoghegan <pg@heroku.com> writes: > On Sun, Jul 17, 2016 at 12:22 AM, Jun Cheol Gim <dialogbox@gmail.com> wrote: >> If we have timestamp of first and last executed, we can easily gather thess >> informations and there are tons of more use cases. > -1 from me. > I think that this is the job of a tool that aggregates things from > pg_stat_statements. It's unfortunate that there isn't a good > third-party tool that does that, but there is nothing that prevents > it. The concern I've got about this proposal is that the results get very questionable as soon as we start dropping statement entries for lack of space. last_executed would be okay, perhaps, but first_executed not so much. regards, tom lane
В списке pgsql-hackers по дате отправления: