From: Ian Barwick <ian.barwick@2ndquadrant.com>
Subject: monitoring.sgml - clarify length of query text displayed in
 pg_stat_statements
To: pgsql-docs@postgresql.org,
 "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Message-ID: <22273199-d124-1543-cf49-5a34253acbb8@2ndquadrant.com>
Date: Thu, 1 Dec 2016 10:45:51 +0900
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.4.0
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="------------E73D9BEB84E734127179174E"
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

This is a multi-part message in MIME format.
--------------E73D9BEB84E734127179174E
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi

Small doc patch to clarify how much of the query text is show in pg_stat_statements
and a link to the relevant GUC.


Regards

Ian Barwick

-- 
   Ian Barwick                   http://www.2ndQuadrant.com/
   PostgreSQL Development, 24x7 Support, Training & Services


--------------E73D9BEB84E734127179174E
Content-Type: text/x-patch;
 name="doc-pg-stat-statement-query-length.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="doc-pg-stat-statement-query-length.patch"

diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
new file mode 100644
index 3de489e..02dab87
*** a/doc/src/sgml/monitoring.sgml
--- b/doc/src/sgml/monitoring.sgml
*************** postgres   27093  0.0  0.0  30096  2752
*** 785,791 ****
       <entry>Text of this backend's most recent query. If
        <structfield>state</> is <literal>active</> this field shows the
        currently executing query. In all other states, it shows the last query
!       that was executed.
       </entry>
      </row>
     </tbody>
--- 785,793 ----
       <entry>Text of this backend's most recent query. If
        <structfield>state</> is <literal>active</> this field shows the
        currently executing query. In all other states, it shows the last query
!       that was executed. By default the query text is truncated at 1024
!       characters; this value can be changed via the parameter
!       <xref linkend="guc-track-activity-query-size">.
       </entry>
      </row>
     </tbody>


--------------E73D9BEB84E734127179174E
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

--------------E73D9BEB84E734127179174E--