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  (Peter Geoghegan <pg@heroku.com>)
Re: [HACKERS] [PROPOSAL] timestamp informations to pg_stat_statements  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: [PROPOSAL] timestamp informations to pg_stat_statements
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Obsolete comment within fmgr.c