Re: Getting time-dependent load statistics - Mailing list pgsql-general

From Torsten Bronger
Subject Re: Getting time-dependent load statistics
Date
Msg-id 87r61siz9s.fsf@physik.rwth-aachen.de
Whole thread Raw
In response to Getting time-dependent load statistics  (Torsten Bronger <bronger@physik.rwth-aachen.de>)
List pgsql-general
Hallöchen!

Torsten Bronger writes:

> [...]  Currently, I experiment with
>
> SELECT tup_returned + tup_fetched + tup_inserted + tup_updated +
> tup_deleted FROM pg_stat_database WHERE datname='chantal';

Stangely, the statistics coming out of it are extremely high.  I
just dumped my database with the built-in tool of my web framework
and got approximately 50 times as many row accesses from the command
above as I have objects in my database.  The dump routine of my web
framework may do redundant things but not at this extent ...

Tschö,
Torsten.

--
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: torsten.bronger@jabber.rwth-aachen.de

pgsql-general by date:

Previous
From: Angelo Astorga
Date:
Subject: Compatibilidad RH enterprise 5.3 !!!
Next
From: Cott Lang
Date:
Subject: Re: Fixing invalid owners on pg_toast tables in 8.3.5