Postgres Pro
Downloads
Home   >   mailing lists

Thread: Finding time of last pg_stat_reset

Finding time of last pg_stat_reset

From
Tommy Gildseth
Date:
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

Re: Finding time of last pg_stat_reset

From
Bruce Momjian
Date:
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. +