Re: SQL profiler feature in Pgsql?

Поиск
Список
Период
Сортировка
От Ugly Hippo
Тема Re: SQL profiler feature in Pgsql?
Дата
Msg-id 20020419183530.79403.qmail@web21208.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: SQL profiler feature in Pgsql?  ("Robert J. Sanford, Jr." <rsanford@nolimitsystems.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: algebraic rewriting
Следующее
От: thiemo
Дата:
Сообщение: updateble views