Postgres Pro
Downloads
Home   >   mailing lists

Identifying old/unused views and table - Mailing list pgsql-general

From Jason Long
Subject Identifying old/unused views and table
Date
Msg-id 1317156710.29484.4.camel@localhost.localdomain
Whole thread Raw
Responses Re: Identifying old/unused views and table  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Richard Broersma
Date:
Subject: Re: live metadata changes v8.3.4
Next
From: David North
Date:
Subject: bytea columns and large values