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 "Dave Page" <dpage@postgresql.org>
Re: is there a tracking trace tool like the "SQL Analizer Tony Caduto <tony_caduto@amsoftwaredesign.com>


> ------- Original Message -------
> From: Tony Caduto 
> To: Harald Armin Massa 
> 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
Дата:
FAQ