Re: Query truncated in Server Status

On Sun, 2012-02-19 at 10:23 +0100, Guillaume Lelarge wrote:
> On Sat, 2012-02-18 at 18:54 -0600, Aren Cambre wrote:
> > In the Server Status program, long queries get truncated.
> >
> > Pressing Ctrl-C or the *Copy* button on a recent query put this in the
> > clipboard:
> > *9368 de 34132 postgres 6/528 AccessShareLock Yes 2012-02-18
> > 18:46:14.759-06 select
> > distinct case when upper(geometrytype("the_geom")) IN
> > ('POINT','MULTIPOINT') THEN 'POINT' when upper(geometrytype("the_geom")) IN
> > ('LINESTRING','MULTILINESTRING') THEN 'LINESTRING' when
> > upper(geometrytype("the_geom")) IN ('POLYGON','MULTIPOLYG*
> > *
> > *
> > Looks like the query got truncated at the 250th character. I've reproduced
> > on other queries.
> >
> > I'm OK if the query needs to be truncated to fit in the UI, but the whole
> > query ought to be copied to the clipboard. This is making it challenging
> > for me to analyze a problematic Quantum GIS query.
> >
>
> I suppose you work on Windows. The widget we use on Windows truncates
> silently all strings to 512 characters. It means we need to fix this
> (just as we did for the table properties dialog which suffered the same
> issue).
>
> To be complete, you have to know that even PostgreSQL truncates the
> query in the pg_stat_activity stats catalog. By default to 1024
> characters. So if your queries are longer than that, there's nothing we
> can do.
>
> Working on a fix right now.
>

OK, it's fixed now.

While working on this, I found another bug (you couldn't copy a query if
there was no application name for server 9.0+). Fixed too.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com