On 09/28/2011 04:51 AM, Jason Long wrote:
I have an application with a couple hundred views and a couple hundred
tables.
Is there some way I can find out which views have been accessed in the
last 6 months or so? Or some way to log this?
I know there are views and tables that are no longer in used by my
application and I am looking for a way to identify them.
Look at the pg_catalog.pg_stat* tables
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general