Re: Getting time-dependent load statistics

From: Ashish Karalkar <ashishka(at)synechron(dot)com>
To: pgsql-general(at)postgresql(dot)org, bronger(at)physik(dot)rwth-aachen(dot)de
Subject: Re: Getting time-dependent load statistics
Date: 2009-02-27 05:05:32
Message-ID: 49A7749C.5090705@synechron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Torsten Bronger wrote:
> 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.
>
>
If I understood you correctly you might get help from following:

http://pgfouine.projects.postgresql.org/

With Regards
Ashish Karalkar

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ashish Karalkar 2009-02-27 05:11:21 Re: Connection refused (0x0000274D/10061).
Previous Message Dann Corbit 2009-02-27 01:30:53 Kerberos V5 required for PostgreSQL installation on Windows