Finding time of last pg_stat_reset

Поиск
Список
Период
Сортировка
От Tommy Gildseth
Тема Finding time of last pg_stat_reset
Дата
Msg-id 4A320DF2.1090807@usit.uio.no
обсуждение исходный текст
Ответы Re: Finding time of last pg_stat_reset  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-general
I'm trying to figure out if there's any way to find when statistics was
last reset. Previously when we were using 8.2, we had
stats_reset_on_server_start set to on, and then assumed
pg_stat_get_backend_start as the start time for collected stats. Is
there any way to do this in 8.3, without f.ex adding a call to
pg_stat_reset() in our startup scripts?

--
Tommy Gildseth

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

Предыдущее
От: Karl Denninger
Дата:
Сообщение: Retrieving performance information on a query
Следующее
От: zxo102 ouyang
Дата:
Сообщение: Very slow searching in a table with more than 10 millions recovered records from a backup file...