Postgres Pro
Downloads
Home   >   mailing lists

Re: Checking what is the current query running - Mailing list pgsql-admin

From Tom Lane
Subject Re: Checking what is the current query running
Date
Msg-id 8300.1153829345@sss.pgh.pa.us
Whole thread Raw
In response to Re: Checking what is the current query running  ("Markus Wollny" <Markus.Wollny@computec.de>)
List pgsql-admin
Tree view 
"Markus Wollny" <Markus.Wollny@computec.de> writes:
> pg_stat_activity has some limitations however; if you use a lot of
> dynamically generated complex queries, you might stumble over the 255
> character limit of current_query in pg_stat_activity, statement-strings
> longer than that are just cut off.

The limit has been ~1K, not 255, for a long time (since 8.0).

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Checking what is the current query running
Next
From: "JieJun Xu"
Date:
Subject: Re: problem backup/restore PSQL DB