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

Re: SQL profiler feature in Pgsql?

From: Ugly Hippo <ugly_hippo(at)yahoo(dot)ca>
To: "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com>,Pgsql-Novice(at)postgresql(dot)org
Subject: Re: SQL profiler feature in Pgsql?
Date: 2002-04-19 18:35:30
Message-ID: 20020419183530.79403.qmail@web21208.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
--- "Robert J. Sanford, Jr."
<rsanford(at)nolimitsystems(dot)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

In response to

pgsql-novice by date

Next:From: Vincent DOYELLEDate: 2002-04-19 19:36:36
Subject: Permission denied when executing a query from a file
Previous:From: Tom LaneDate: 2002-04-19 18:04:38
Subject: Re: algebraic rewriting

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