On 07/12/2010 02:40 PM, Andrew Bartley wrote: > We have a large number of orphaned or redundant tables, views, and > functions, due to many years of inadequate source management. > > We are running " PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC > gcc-4.3.real (Debian 4.3.2-1.1) 4.3.2 " > > Is there an effective way to identify these objects using the stats > tables? Something like a last accessed/used or some such column?
Maybe pg_statio* views? http://www.postgresql.org/docs/8.3/interactive/monitoring-stats.html Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, & Support
signature.asc
Description: OpenPGP digital signature
