> ------- Original Message ------- > From: Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> > To: Harald Armin Massa <haraldarminmassa@xxxxxxxxx> > 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
