Re: SQL profiler feature in Pgsql?

On Fri, 2002-04-19 at 04:22, Michael McConnell wrote:
> Does Postgresql have something akin to the MSSQL "SQL Profiler" to perform database traces? Any info is appreciated.

I don't think there is any tool to fully analyse the detail output that
PostgreSQL can generate, in the sort of presentation that MSSQL
produces, but you can use "EXPLAIN ....query...." to give a reasonable
view of how the query will perform.

EXPLAIN ANALYZE and EXPLAIN VERBOSE give substantially more output, but
you would have to be a guru, or a very patient person, to be able to
parse the output of that.

I have found that EXPLAIN <query> is usually sufficient for my needs.

Also, don't forget to make sure the tables are ANALYZEd before using it.

Regards,
                    Andrew.
--
--------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/        PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201    MOB: +64(21)635-694    OFFICE: +64(4)499-2267
       Are you enrolled at http://schoolreunions.co.nz/ yet?