Thread: statistics on CRUD operations
Hi there, Is somewhere a system table providing statistic counters of CRUD operations against custom databases ? TIA, Sabin
On Mon, 2007-06-18 at 12:35 +0300, Sabin Coanda wrote: > Is somewhere a system table providing statistic counters of CRUD operations > against custom databases ? pg_stat_user_tables http://www.postgresql.org/docs/8.2/static/monitoring-stats.html#MONITORING-STATS-VIEWS -- Simon Riggs EnterpriseDB http://www.enterprisedb.com
""Simon Riggs"" <simon@2ndquadrant.com> wrote in message news:1182161814.6855.111.camel@silverbirch.site... > On Mon, 2007-06-18 at 12:35 +0300, Sabin Coanda wrote: > >> Is somewhere a system table providing statistic counters of CRUD >> operations >> against custom databases ? > > pg_stat_user_tables > > http://www.postgresql.org/docs/8.2/static/monitoring-stats.html#MONITORING-STATS-VIEWS > That's exactly what I need, but I found the signification of the columns is not trivial, so I'd appreciate very much some more details about them, please. Regards, Sabin