Re: [GENERAL] table/view/function access counts

2009-07-19 Thread Sim Zacks
Thanks Pavel, that rocks. > SELECT * FROM pg_stat_all_tables; > > regards > Pavel Stehule > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] table/view/function access counts

2009-07-19 Thread Pavel Stehule
Hello 2009/7/19 Sim Zacks : > Are there any statistics generated as to how many times an object > (table/view/function) is accessed? > SELECT * FROM pg_stat_all_tables; regards Pavel Stehule > I would like to know what in the database system is not being used. > > > Thank you > > Sim > > > -- >