Postgres Pro
Downloads
Home   >   mailing lists

Finding time of last pg_stat_reset - Mailing list pgsql-general

From Tommy Gildseth
Subject Finding time of last pg_stat_reset
Date
Msg-id 4A320DF2.1090807@usit.uio.no
Whole thread Raw
Responses Re: Finding time of last pg_stat_reset
List pgsql-general
Tree view 
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 by date:

Previous
From: Karl Denninger
Date:
Subject: Retrieving performance information on a query
Next
From: zxo102 ouyang
Date:
Subject: Very slow searching in a table with more than 10 millions recovered records from a backup file...