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

From Torsten Bronger
Subject Getting time-dependent load statistics
Date
Msg-id 87zlghf5qe.fsf@physik.rwth-aachen.de
Whole thread Raw
Responses Re: Getting time-dependent load statistics
Re: Getting time-dependent load statistics
Re: Getting time-dependent load statistics
List pgsql-general
Hallöchen!

Yesterday I ported a web app to PG.  Every 10 minutes, a cron job
scanned the log files of MySQL and generated a plot showing the
queries/sec for the last 24h.  (Admittedly queries/sec is not the
holy grail of DB statistics.)

But I still like to have something like this.  At the moment I just
do the same with PG's log file, with

    log_statement_stats = on

But to generate these plots is costly (e.g. I don't need all the
lines starting with !), and to interpret them is equally costly.  Do
you have a suggestion for a better approach?

Tschö,
Torsten.

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

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: Re: where to divide application and database
Next
From: Bill Moran
Date:
Subject: Re: Getting time-dependent load statistics