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
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>
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs