Steve Wolfe wrote:
>
> Here's something that would be very useful to those of us with
> high-traffic DB servers, and of course, if it already exists, slap me
> silly and point me in the right direction - it would be very useful to be
> able to find out what query was being processed by a particular backend.
> That way, when I see that there is a backend taking an entire CPU to
> itself for several minutes, it would make it immensely easier to track
> down the culprit.
Coming with the statistics stuff I'll post to PATCHES
tomorrow is a view that shows (only to superusers) the
queries currently executed by the backends of all databases.
More precise, the query it did a couple of milliseconds
before, because there is little delay causing the backend
that asks usually to show up <IDLE>.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com