From: | Erik Jones <ejones(at)engineyard(dot)com> |
---|---|
To: | General postgres mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Last modification time of a database? |
Date: | 2009-03-23 06:14:50 |
Message-ID: | 6AFEDE45-2419-48BE-9AF3-7924EF539F0F@engineyard.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
So, I've got loads of databases and I'd really like some way to see
what the last actual modification time was for them. I can't just
check the time stamp on the file in the database directory as
autovacuum fudges that and trying to match up values for either
last_autovacuum or last_autoanalyze in pg_stat_all_tables/indexes with
the files' time stamps is no good as the time stamp on a file that was
last written to by autovacuum is for when autovacuum stopped writing
to it whereas the values in pg_stat_all_tables/indexes are from when
autovacuum started the given operation and the difference between the
two can vary with the size of the table.
Am I missing something obvious here? If not, has anyone come up with
a reliable way to do this?
Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2009-03-23 06:17:05 | Re: pg_restore error - Any Idea? |
Previous Message | DM | 2009-03-23 05:44:28 | pg_restore error - Any Idea? |