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