| Lists: | pgsql-general |
|---|
| From: | "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | statistics on CRUD operations |
| Date: | 2007-06-18 09:35:10 |
| Message-ID: | f55jk0$6q7$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Hi there,
Is somewhere a system table providing statistic counters of CRUD operations
against custom databases ?
TIA,
Sabin
| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: statistics on CRUD operations |
| Date: | 2007-06-18 10:16:53 |
| Message-ID: | 1182161814.6855.111.camel@silverbirch.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: statistics on CRUD operations |
| Date: | 2007-06-18 12:24:22 |
| Message-ID: | f55thb$120b$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
""Simon Riggs"" <simon(at)2ndquadrant(dot)com> wrote in message
news:1182161814(dot)6855(dot)111(dot)camel(at)silverbirch(dot)site(dot)(dot)(dot)
> 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