Re: Identifying old/unused views and table

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: mailing(dot)lists(at)octgsoftware(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Identifying old/unused views and table
Date: 2011-09-28 01:04:54
Message-ID: 4E8272B6.9070708@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adarsh Sharma 2011-09-28 04:09:13 Re: Download States and Capitals Database
Previous Message Craig Ringer 2011-09-28 00:50:26 Re: bytea columns and large values