Re: Query truncated in Server Status

Thanks! Yes, I am using Windows.

Aren

On Sun, Feb 19, 2012 at 5:12 AM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info>wrote:

> 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
>
>