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-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers