Re: Finding time of last pg_stat_reset

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Finding time of last pg_stat_reset
Дата
Msg-id 200906121301.n5CD1LA12641@momjian.us
обсуждение исходный текст
Ответ на Finding time of last pg_stat_reset  (Tommy Gildseth <tommy.gildseth@usit.uio.no>)
Список pgsql-general
Tommy Gildseth wrote:
> 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?

No, I don't think the reset time is recorded anywhere.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Libpq on windows
Следующее
От: Andy Colson
Дата:
Сообщение: Re: How to store text files in the postgresql?