| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Finding time of last pg_stat_reset |
| Date: | 2009-06-12 13:01:21 |
| Message-ID: | 200906121301.n5CD1LA12641@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Colson | 2009-06-12 13:35:11 | Re: How to store text files in the postgresql? |
| Previous Message | Jasen Betts | 2009-06-12 12:59:13 | Re: Libpq on windows |