Re: is there a tracking trace tool like the "SQL Analizer

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: is there a tracking trace tool like the "SQL Analizer
Дата
Msg-id 200701091955220000@341925390
обсуждение исходный текст
Ответы Re: is there a tracking trace tool like the "SQL Analizer  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Список pgsql-general

> ------- Original Message -------
> From: Tony Caduto <tony_caduto@amsoftwaredesign.com>
> To: Harald Armin Massa <haraldarminmassa@gmail.com>
> Sent: 1/9/07, 7:15:52 PM
> Subject: Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer"
>
> Harald Armin Massa wrote:
> > Jeffrey,
> >
> >> Not exactly.  SQL Analyzer also includes live monitoring of whatever
> >> queries
> >> are coming into the database.  You can achieve something similar by
> >> enabling
> >> query logging in the settings.
> >
> > that is within Tools / View Server Status of pgAdmin III
> >
> > Of course, Query Command String has to be enabled on the server; and
> > the security implications of that setting have to be considered before
> > :)
> >
> > best wishes,
> >
> > Harald
> Hi,
> I may be wrong but:
> Enabling query logging (in the options dialog) will only log the SQL
> pgAdmin III sends to the server, it will not capture the query for a
> selected process
> in the server status dialog.

That's not what Harald was referring to. The server status dialog monitors the entire server via pg_stat*.

/D

В списке pgsql-general по дате отправления:

Предыдущее
От: Ben
Дата:
Сообщение: index creation on 7.3
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: ERROR: invalid memory alloc request size, and others