Re: [ADMIN] current_query column of pg_stat_activity view

2008-01-14 Thread Tom Lane
"Tena Sakai" <[EMAIL PROTECTED]> writes: > I have an application that emits query to postgres > (running v 8.2.4 on Dell Hardware/Redhat enterprise > server) and I want to look at what postgres receives. Turn on query logging (log_statement)? regards, tom lane ---

[ADMIN] current_query column of pg_stat_activity view

2008-01-14 Thread Tena Sakai
Hi everybody, I have an application that emits query to postgres (running v 8.2.4 on Dell Hardware/Redhat enterprise server) and I want to look at what postgres receives. The only way I know to do so is to run a view called pg_stat_activity, which gives me a column called current_query. It so ha