HI,
Is there any way to log all the queries
in 7.1.1 (older release).please help out guys.
Thanks & Regards Dilipkumar
----- Original Message -----
Sent: Tuesday, July 25, 2006 2:26
PM
Subject: Re: [ADMIN] Checking what is the
current query running
You have to enable "stats_command_string' in your
postgresql.conf file:
stats_command_string = on
After that is
done you can view queries running on database server like this:
select
current_query from pg_stat_activity;
You can also get the query
execution times and which queries were run, in the database server logs files
by enabling the following in postgresql.conf file:
log_duration =
on log_statement = 'all'
Hope this
helps...
Thanks,
Shoaib Mir EnterpriseDB
On 7/25/06, Marco
Bizzarri <marco.bizzarri@xxxxxxxxx >
wrote:
Hi
all.
I've a postgresql where sometimes a process can remaing running
a query for a very long time.
Aside from logging the queries, is
there a way to know which query is running in one particular
moment?
Regards Marco
-- Marco Bizzarri http://notenotturne.blogspot.com/
---------------------------(end
of broadcast)--------------------------- TIP 9: In versions below 8.0,
the planner will ignore your desire
to choose an index scan if your
joining column's datatypes do not
match
|