Re: current_query in pg_stat_activity - Mailing list pgsql-novice

Oliver Fromme <olli@lurza.secnetix.de> writes:
> The "current_query" column in the "pg_stat_activity" system
> table seems to be limited to 255 characters.  Is there a way
> to increase that limit, in order to see queries completely
> which are longer than 255 characters?

You could fool with PGSTAT_ACTIVITY_SIZE in pgstat.h, but you probably
need to keep it under 1000 --- note the comments associated with
PGSTAT_NUM_TABENTRIES.

            regards, tom lane