Re: Redundant database objects.

Thanks Joe,

Unfortunately these views only give me what appears to be a certain time
frame. This does not help all that much. It will give a list of tables,
indexes and sequences that have been used in the time frame, so that is at
least a start.

It would be good if there was a timestamp (last accessed) that would give me
a clearer indication.

Thanks

Andrew

On 13 July 2010 08:46, Joe Conway <mail(at)joeconway(dot)com> wrote:

> 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
>
>