pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Ian Barwick <ian.barwick@2ndquadrant.com>
To: pgsql-docs@postgresql.org, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Subject: monitoring.sgml - clarify length of query text displayed in pg_stat_statements
Date: Thu, 1 Dec 2016 10:45:51 +0900
Message-ID: <22273199-d124-1543-cf49-5a34253acbb8@2ndquadrant.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>

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

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

Attachments:

doc-pg-stat-statement-query-length.patch (text/x-patch, 1007B) download
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>

view thread (4+ messages)  latest in thread

Message-ID: <22273199-d124-1543-cf49-5a34253acbb8@2ndquadrant.com>
Permalink:  ../22273199-d124-1543-cf49-5a34253acbb8@2ndquadrant.com/
Also on:    postgresql.org/message-id/22273199-d124-1543-cf49-5a34253acbb8@2ndquadrant.com

copy link · copy postgr.es · copy git am

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: ian.barwick@2ndquadrant.com, pgsql-hackers@postgresql.org
  Subject: Re: monitoring.sgml - clarify length of query text displayed in pg_stat_statements
  In-Reply-To: <22273199-d124-1543-cf49-5a34253acbb8@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox