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

Reply via email to