Any way to see what queries are currently running? - Mailing list pgsql-admin

From Chris Hoover
Subject Any way to see what queries are currently running?
Date
Msg-id 1d219a6f05081513546f6458b6@mail.gmail.com
Whole thread Raw
Responses Re: Any way to see what queries are currently running?  (Guido Barosio <gbarosio@gmail.com>)
Re: Any way to see what queries are currently running?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Any way to see what queries are currently running?  (adey <adey11@gmail.com>)
List pgsql-admin
I'm running 7.3.4.  Is there anyway to see the actual sql being run by
the database via a query?  I am having some problems with long running
load causing querires from our reporting system.  I have sql logging
turned on to log the sql statements to my postgres.log file.  However,
these reporting queries do not appear to be logging the entire query.
I am only getting the select clause (and I'm not sure if it's all of
it) but no from or where clause.

Can I pull these queries out from postgres?

Thanks,

Chris

pgsql-admin by date:

Previous
From: "D Kavan"
Date:
Subject: vacuumdb -a -f
Next
From: Guido Barosio
Date:
Subject: Re: Any way to see what queries are currently running?