schema Cleanning - Mailing list pgsql-general

From salah jubeh
Subject schema Cleanning
Date
Msg-id 299328.3682.qm@web52703.mail.re2.yahoo.com
Whole thread Raw
Responses Re: schema Cleanning
List pgsql-general
Hello,

I am trying to drop deprecated tables, views, procedures from an existing database, I am checking the pg_stat_user_tables view to check if the tables are accessed recently also to check live tuples. For deprecated views and procedures, I am wondering How can I do that, for example suppose the table is used and there is a view defined using this table but no one is using it. Is there is away to check the views statistics.

Regards 


pgsql-general by date:

Previous
From: Norberto Delle
Date:
Subject: Continuous recovery stopping
Next
From: Geoffrey Myers
Date:
Subject: Re: disable triggers using psql