monitoring.sgml - clarify length of query text displayed in pg_stat_statements
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
Attachments:
doc-pg-stat-statement-query-length.patchtext/x-patch; name=doc-pg-stat-statement-query-length.patchDownload
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>
On Wed, Nov 30, 2016 at 8:45 PM, Ian Barwick
<ian.barwick@2ndquadrant.com> wrote:
Small doc patch to clarify how much of the query text is show in
pg_stat_statements
and a link to the relevant GUC.
This patch improves the pg_stat_activity documentation, not the
pg_stat_statements documentation, but it looks correct, so I have
committed it.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Hi
On 12/02/2016 11:01 PM, Robert Haas wrote:
On Wed, Nov 30, 2016 at 8:45 PM, Ian Barwick
<ian.barwick@2ndquadrant.com> wrote:Small doc patch to clarify how much of the query text is show in
pg_stat_statements
and a link to the relevant GUC.This patch improves the pg_stat_activity documentation, not the
pg_stat_statements documentation, but it looks correct, so I have
committed it.
Many thanks! (Looks like I had a mental short-circuit between "query"
and "statement" there).
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