Re: Increasing the length of pg_stat_activity.current_query...

Sean Chittenden wrote:
> Is there any reason the length of 
> pg_catalog.pg_stat_activity.current_query is capped at 255 characters?  
> Why can't it be a pointer to the currently running query?
> 
> Seems silly to me and is a PITA to try and use as a debugging tool only 
> to find out that the query in question, has a logical break right at 
> character 255 so the query in pg_stat_query looks like it's the 
> complete query, but it's not (extra foo at the end of the query is 
> causing it to run dog slow, but it's difficult to see that without 
> going to the logs and digging through them to find the problem 
> statement).
> 
> Anyway, is there any good reason for this or can this be increased 
> somehow?  -sc

I think it is limited because the queries are stored in shared memory,
maybe.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073