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

> ------- Original Message -------
> From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
> To: Harald Armin Massa <haraldarminmassa(at)gmail(dot)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