Обсуждение: Viewing active queries

Поиск
Список
Период
Сортировка

Viewing active queries

От
"Vanole, Mike"
Дата:
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

От
Andreas Pflug
Дата:
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