Re: is there a tracking trace tool like the "SQL Analizer - Mailing list pgsql-general

From Dave Page
Subject Re: is there a tracking trace tool like the "SQL Analizer
Date
Msg-id 200701091955220000@341925390
Whole thread Raw
Responses Re: is there a tracking trace tool like the "SQL Analizer
List 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 by date:

Previous
From: Ben
Date:
Subject: index creation on 7.3
Next
From: Scott Marlowe
Date:
Subject: Re: ERROR: invalid memory alloc request size, and others