Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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.
- References:
- Re: [GENERAL] How to know which queries are to be optimised?
- From: Bruno Wolff III
- Re: [GENERAL] How to know which queries are to be optimised?
- From: Ulrich Wisser
- Re: [GENERAL] How to know which queries are to be optimised?
- From: Richard Huxton
- Re: [GENERAL] How to know which queries are to be optimised?
- Prev by Date: Re: Help specifying new machine
- Next by Date: Re: Help specifying new machine
- Previous by thread: Re: [GENERAL] How to know which queries are to be optimised?
- Next by thread: Re: [GENERAL] How to know which queries are to be optimised?
- Indexes: