Re: Checking what is the current query running

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>
Cc: "Postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Checking what is the current query running
Date: 2006-07-25 12:09:05
Message-ID: 8300.1153829345@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Markus Wollny" <Markus(dot)Wollny(at)computec(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message zz_11 2006-07-25 13:56:46 startup script for FreeBSD 6.1
Previous Message adey 2006-07-25 10:27:01 Re: UTF8 characters