Re: [GENERAL] capturing and storing query statement with - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] capturing and storing query statement with
Date
Msg-id 28020.1056726320@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] capturing and storing query statement with  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Joe Conway writes:
>> I was thinking something similar. This exact question has come up at
>> least three times in the last three months. I doubt we'd want a special
>> keyword like CURRENT_QUERY, but maybe current_query()?

> The current statement can be examined using the statistics views and
> functions.

That's not very reliable though --- unless the current query has been
running for quite a few milliseconds, there's no guarantee it will be
reflected in the statistics collector's output.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Two weeks to feature freeze
Next
From: Josh Berkus
Date:
Subject: Re: CODE SUBMISSION FOR NEXT RELEASE