statistics on CRUD operations

Started by Sabin Coandaalmost 19 years ago3 messagesgeneral
Jump to latest
#1Sabin Coanda
sabin.coanda@deuromedia.ro

Hi there,

Is somewhere a system table providing statistic counters of CRUD operations
against custom databases ?

TIA,
Sabin

#2Simon Riggs
simon@2ndQuadrant.com
In reply to: Sabin Coanda (#1)
Re: statistics on CRUD operations

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

#3Sabin Coanda
sabin.coanda@deuromedia.ro
In reply to: Sabin Coanda (#1)
Re: statistics on CRUD operations

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