Re: How to get cursor query

On 08/18/2015 06:44 AM, Tom Lane wrote:
> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
>> On 08/18/2015 01:43 AM, Mikhail wrote:
>>> I have a long executing query via foreign data wrapper and on the remote
>>> server i can see that the query is fetching data from the cursor
>>> ...
>>> Is it possible to get query text corresponding to cursor c514?
>
>> The only thing I can think to do is load pg_stat_statements:
>> http://www.postgresql.org/docs/9.4/interactive/pgstatstatements.html
>
> That won't help after-the-fact either.

Well at some point the query will leave the view, but by default
pg_stat_statements tracks the last 5000 distinct statements, so you have
some time > 0 to find it.

>
> If you're using postgres_fdw then the set of queries it could issue via a
> cursor is pretty restricted --- just SELECT-from-single-table AFAIR ---
> and you could tell which table by looking at the locks held by the cursor
> transaction (see pg_locks on the remote server). Perhaps that's close
> enough?
>
> regards, tom lane
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com