Postgres Pro
Downloads
Home   >   mailing lists

Re: too short string for SQL in pg_stat_backend_activity - Mailing list pgsql-hackers

From Tom Lane
Subject Re: too short string for SQL in pg_stat_backend_activity
Date
Msg-id 4341.1092754125@sss.pgh.pa.us
Whole thread Raw
In response to too short string for SQL in pg_stat_backend_activity  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
List pgsql-hackers
Tree view 
Pavel Stehule <stehule@kix.fsv.cvut.cz> writes:
> Can I set somewhere an long for text, which is in current_query in 
> "pg_catalog.pg_stat_activity"?

No.  You could attach gdb to the backend that's running the troublesome
query and do "p debug_query_string" ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: tablespace and sequences?
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: tablespace and sequences?