Re: Getting truncated queries from pg_stat_statements

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: Tim Uckun <timuckun(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:15:09
Message-ID: CAEYLb_Vk-RR8_0_03Uq3pEuShjdSMEewJeDAVobV4dmdGm8guw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 Tim Uckun 2015-01-19 23:41:25 Re: Getting truncated queries from pg_stat_statements
Previous Message Tim Uckun 2015-01-19 22:37:10 Getting truncated queries from pg_stat_statements