| From: | Rudi Starcevic <tech(at)wildcash(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] How to know which queries are to be optimised? |
| Date: | 2004-08-12 22:50:17 |
| Message-ID: | 411BF429.1090106@wildcash.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Hi,
>> But is there a tool that could compile a summary out of the log? The
>> log grows awefully big after a short time.
There's also pg_analyzer to check out.
http://www.samse.fr/GPL/pg_analyzer/
Some of it's features are: written in Perl and produces HTML output.
> You might want to look at the "Practical Query Analyser" - haven't used
> it myself yet, but it seems a sensible idea.
>
> http://pqa.projects.postgresql.org/
Cheers,
Rudi.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Liam Lesboch | 2004-08-12 22:55:02 | Re: Replication options? |
| Previous Message | Geoff Caplan | 2004-08-12 22:12:28 | Re: Performance critical technical key |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raoul Buzziol | 2004-08-13 06:29:15 | Re: Help specifying new machine |
| Previous Message | William Yu | 2004-08-12 22:12:43 | Re: Help specifying new machine |