Re: current_query in pg_stat_activity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: current_query in pg_stat_activity
Date: 2004-02-24 15:05:50
Message-ID: 22063.1077635150@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Oliver Fromme <olli(at)lurza(dot)secnetix(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-02-24 15:09:47 Re: installing pgsql
Previous Message Elinor Medezinski 2004-02-24 14:28:27 help with COPY query