Thread: Viewing active queries

Viewing active queries

From
"Vanole, Mike"
Date:
Hi,
 
On the Server Status 'Status' and 'Locks' screens there is a Query column. For me this is always blank, as well as the Start column on 'Locks.' Is there a server side setting I need to enable this? Using PgAdmin v1.2.0 and Postgres 7.4
 
Thanks,
Mike 

Re: Viewing active queries

From
Andreas Pflug
Date:
Vanole, Mike wrote:
> Hi,
>  
> On the Server Status 'Status' and 'Locks' screens there is a Query 
> column. For me this is always blank, as well as the Start column on 
> 'Locks.' Is there a server side setting I need to enable this? Using 
> PgAdmin v1.2.0 and Postgres 7.4
>  

Yes, stats_command_string must be enabled.

Regards,
Andreas