On 08/18/2015 01:43 AM, Mikhail wrote:
Hi,
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
=# select application_name, state, query from pg_stat_activity where pid
= 15455;
application_name │ state │ query
──────────────────┼────────┼─────────────────────
postgres_fdw │ active │ FETCH 100 FROM c514
Is it possible to get query text corresponding to cursor c514?
One of the solution is to turn statement logging on (found it here
http://www.postgresql.org/message-id/1361cef686657c41a139ad8c3145632b44b33...@e2010-mb1.manord.com),
but it works if i turn statement logging on before query execution. What
can i do in case of connection to the server after the statement was
executed?
The only thing I can think to do is load pg_stat_statements:
http://www.postgresql.org/docs/9.4/interactive/pgstatstatements.html
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
