Does/Can PG store administrative statistics? - Mailing list pgsql-hackers

From reina@nsi.edu (Tony Reina)
Subject Does/Can PG store administrative statistics?
Date
Msg-id f40d3195.0107231437.5e17973b@posting.google.com
Whole thread Raw
List pgsql-hackers
I'd like to have statistics on when my database was last backed up or
vacuumed. Currently, I'm implementing this by using simple shell
scripts that write a date stamp to ascii files. I was wondering
whether this is or could be a feature added to Postgres?

For example, could one of the pg_* tables contain the fields
'last_vacuum' or 'last_backup' (which would be updated every time the
vacuum or pg_dump command was executed).

Perhaps something like this exists that I'm unaware of?

-Tony


pgsql-hackers by date:

Previous
From: "Steve Howe"
Date:
Subject: Re: Large queries - again...
Next
From: "Christopher Kings-Lynne"
Date:
Subject: RE: Re: unique index doesn't accept functions on fields