Re: SQL profiler feature in Pgsql? - Mailing list pgsql-novice

From Ugly Hippo
Subject Re: SQL profiler feature in Pgsql?
Date
Msg-id 20020419183530.79403.qmail@web21208.mail.yahoo.com
Whole thread Raw
In response to Re: SQL profiler feature in Pgsql?  ("Robert J. Sanford, Jr." <rsanford@nolimitsystems.com>)
List pgsql-novice
--- "Robert J. Sanford, Jr."
<rsanford@nolimitsystems.com> wrote:
> will do!
>
> at its simplest the mssql profiler is a remote
> client that
> provides the ability to trace all of the sql
> commands that
> are being executed against a database. when
> initiating a
> trace you specify the server that you have admin
> priveleges
> on. you watch commands fly across the screen until
> you have
> seen enough and then stop the trace to figure out
> what you
> need to do from there.

I want one too! (Having used MS's) But, alas, spare
time is hard to come by these days.

> there is also an index tuning wizard that will try
> to walk you
> through suggestions on how to optimize your indices
> based on
> the performance of the trace that you just
> collected.

Currently doing this the hard way.

>
> being able to watch what is happening live very
> nice.

I'm using KPM 1.3k6 Visual Process Manager - it comes
with SuSE 7.2.

Troy


______________________________________________________________________
Find, Connect Date! http://personals.yahoo.ca

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: algebraic rewriting
Next
From: thiemo
Date:
Subject: updateble views