Identifying old/unused views and table

From: Jason Long <mailing(dot)lists(at)octgsoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Identifying old/unused views and table
Date: 2011-09-27 20:51:49
Message-ID: 1317156710.29484.4.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pasman pasmański 2011-09-27 20:55:13 Re: New feature: accumulative functions.
Previous Message Gauthier, Dave 2011-09-27 20:51:42 live metadata changes v8.3.4