Re: Re[2]: [PATCH] Add last_executed timestamp to pg_stat_statements

Поиск
Список
Период
Сортировка
От Christoph Berg
Тема Re: Re[2]: [PATCH] Add last_executed timestamp to pg_stat_statements
Дата
Msg-id aYIh7I9khvoewwH_@msg.df7cb.de
обсуждение исходный текст
Ответ на Re: Re[2]: [PATCH] Add last_executed timestamp to pg_stat_statements  (Sami Imseih <samimseih@gmail.com>)
Ответы Re: Re[2]: [PATCH] Add last_executed timestamp to pg_stat_statements
Список pgsql-hackers
Re: Sami Imseih
> I wonder if we can use GetCurrentStatementStartTimestamp()
> instead?

The main use case for this column is being able to retrieve the stats
that were updated since the last time one was looking. That only works
if it's the statement end time, or else long-running statements
spanning more than one poll interval would be missed.

Perhaps the column should rather be called "stats_last_updated" to
match "stats_since", and be moved to the very end? Similarly, nested
statements would also have to get that stamp.

Oh and, yes, I'm definitely +1 on this feature.

Christoph



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