Re: [PROPOSAL] timestamp informations to pg_stat_statements

Поиск
Список
Период
Сортировка
От legrand legrand
Тема Re: [PROPOSAL] timestamp informations to pg_stat_statements
Дата
Msg-id 1520696627569-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: [HACKERS] [PROPOSAL] timestamp informations to pg_stat_statements  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [PROPOSAL] timestamp informations to pg_stat_statements  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
+1
Having the time of first occurence of a statement is very usefull for
trouble shouting,
it permits for exemple to retrieve the order of operations in some complex
cases (and thoses informations aren't taken by any third party collecting
tool, that will only be able to provide a time range of occurence).

I thougth that pgss rows where removed randomly when max rows was reached,
wouldn't having last_executed information permit a kind of LRU removal ?

Regards
PAscal





--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: [HACKERS] [PATCH] Incremental sort
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: [HACKERS] [PATCH] Incremental sort