what about just the activity display that the mssql profiler
generates? i typically use the sql server profiler to look at
what is really happening in terms of statement execution so
that i can make sure it meshes with what i think _should_ be
happening. something like that would be _very_ useful.
rjsjr
> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org
> [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Andrew McMillan
> Sent: Thursday, April 18, 2002 8:20 PM
> To: Michael McConnell
> Cc: Pgsql-Novice@postgresql. org (E-mail)
> Subject: Re: [NOVICE] 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?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
