Re: Getting time-dependent load statistics

Поиск
Список
Период
Сортировка
От Torsten Bronger
Тема Re: Getting time-dependent load statistics
Дата
Msg-id 87r61siz9s.fsf@physik.rwth-aachen.de
обсуждение исходный текст
Ответ на Getting time-dependent load statistics  (Torsten Bronger <bronger@physik.rwth-aachen.de>)
Список 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 по дате отправления:

Предыдущее
От: Angelo Astorga
Дата:
Сообщение: Compatibilidad RH enterprise 5.3 !!!
Следующее
От: Cott Lang
Дата:
Сообщение: Re: Fixing invalid owners on pg_toast tables in 8.3.5