Re: Getting truncated queries from pg_stat_statements

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting truncated queries from pg_stat_statements
Date: 2015-01-19 23:41:25
Message-ID: CAGuHJrOBP_87BzDzDOThUwazAHBtRfGC=vRObwTyqkCntaygCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok thanks. I am still on 9.3 so I'll adjust that setting.

On Tue, Jan 20, 2015 at 12:15 PM, Peter Geoghegan <
peter(dot)geoghegan86(at)gmail(dot)com> wrote:

> On Mon, Jan 19, 2015 at 2:37 PM, Tim Uckun <timuckun(at)gmail(dot)com> wrote:
> > I am trying to get some slow query information and the results from my
> query
> > are truncated at 2047 characters. Some of my queries are very long so
> they
> > get truncated in the select. Is there a way around this?
>
>
> Yes. This is fixed in PostgreSQL 9.4, so that query texts can be of
> virtually unlimited size and still be stored. Otherwise, it depends on
> your track_activity_query_size setting.
>
> --
> Regards,
> Peter Geoghegan
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2015-01-20 01:12:35 Re: Partitioning
Previous Message Peter Geoghegan 2015-01-19 23:15:09 Re: Getting truncated queries from pg_stat_statements