Postgres Pro
Downloads
Home   >   mailing lists

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

From Craig Ringer
Subject Re: Identifying old/unused views and table
Date
Msg-id 4E8272B6.9070708@ringerc.id.au
Whole thread Raw
In response to Identifying old/unused views and table  (Jason Long <mailing.lists@octgsoftware.com>)
Responses Re: Identifying old/unused views and table  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: bytea columns and large values
Next
From: Adarsh Sharma
Date:
Subject: Re: Download States and Capitals Database