Re: [GENERAL] How to know which queries are to be optimised?

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.

In response to

Browse pgsql-general by date

  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

Browse pgsql-performance by date

  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