On Thu, Feb 25, 2010 at 12:56 PM, Andy Yoder <ayo...@airfacts.com> wrote: > Thanks Allan for the input - I guess I didn't specify enough details. I am > looking for some type of tool/report that is already done. We have nearly > 1000 tables, over 300 functions to look at a little over a day to provide the > answers (all without dropping any other tasks, of course). I had considered > the trigger idea, and may end of doing it anyway and just working later, but > thought I would check for a "ready-made" solution first.
Nothing as fine grained as per field, but there are the pg_stat_user_tables and pg_stat_user_indexes type system tables, which will show how much individual tables and indexes are getting used. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
