Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Fri, 13 Aug 2004 08:50:17 +1000
  • Message-id: <411BF429.1090106@wildcash.com> <text/plain>

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.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group