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

Re: SQL profiler feature in Pgsql?

From: "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com>
To: <Pgsql-Novice(at)postgresql(dot)org>
Subject: Re: SQL profiler feature in Pgsql?
Date: 2002-04-19 03:16:15
Message-ID: PHENKEEPJCPAMKFKNEOGAEGNDDAA.rsanford@nolimitsystems.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Andrew McMillan
> Sent: Thursday, April 18, 2002 8:20 PM
> To: Michael McConnell
> Cc: Pgsql-Novice(at)postgresql(dot) 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
> 

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2002-04-19 03:34:30
Subject: Re: SQL profiler feature in Pgsql?
Previous:From: Andrew McMillanDate: 2002-04-19 01:19:55
Subject: Re: SQL profiler feature in Pgsql?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group