| From: | Ben Chobot <bench(at)silentmedia(dot)com> |
|---|---|
| To: | Torsten Bronger <bronger(at)physik(dot)rwth-aachen(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Getting time-dependent load statistics |
| Date: | 2009-02-26 20:32:36 |
| Message-ID: | Pine.LNX.4.64.0902261232040.10022@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 20 Feb 2009, 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?
Have a look at http://pgfouine.projects.postgresql.org/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Serge Fonville | 2009-02-26 20:35:54 | Re: postgresql with storage |
| Previous Message | Martin Gainty | 2009-02-26 20:29:48 | Re: Off Topic: ICD-10 codes in a database table? |