Well, you can see usage statistics for tables, indexes, functions and
sequences ... but AFAIK it's not possible to do that for columns.
See this
http://www.postgresql.org/docs/8.4/static/runtime-config-statistics.html
and then use pg_stat_ and pg_statio_ catalogs
(http://www.postgresql.org/docs/8.4/static/monitoring-stats.html) to find
objects that were not accessed recently (numbers are 0 or do not change
anymore, etc.).
But be careful as this may backfire quite easily - imagine an index that's
used only in a batch processing the end of month. You could easily decide
it's not necessary and drop it, causing a disaster.
Tomas
> Hi,
>
> I'm trying to get a grip on a new body of code and a Postgres database
> that
> I'm working with. In particular I've been tasked with cleaning up the
> database.
>
> Is there a way in Postgres to enable monitoring on tables and columns to
> determine what's not actively being used?
>
> This would then form input for a more thorough check into the code base to
> see what's really not being used.
>
>
> Thanks & cheers,
>
> Colin
>
