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
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 |