Re: [GENERAL] How to know which queries are to be optimised? - Mailing list pgsql-performance

From Rudi Starcevic
Subject Re: [GENERAL] How to know which queries are to be optimised?
Date
Msg-id 411BF429.1090106@wildcash.com
Whole thread Raw
In response to Re: [GENERAL] How to know which queries are to be optimised?  (Richard Huxton <dev@archonet.com>)
List 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.

pgsql-performance by date:

Previous
From: William Yu
Date:
Subject: Re: Help specifying new machine
Next
From: Ulrich Wisser
Date:
Subject: insert