In order to know about the current activity you should
"select * from pg_stat_activity" which I think is a view.
You may also want to \d pg_stat_activity to check the relations you may find
usefull.
But, if this is a default installation, you may find that you need to tune some parameters
in your postgresql.conf file. Read the man pages (online documentation) in order to understand
better what you are looking for.
Best wishes,
G.-
On 8/15/05, Chris Hoover <revoohc@gmail.com> wrote: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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
--
"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.