pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedmonitoring.sgml - clarify length of query text displayed in pg_stat_statements
4+ messages / 2 participants
[nested] [flat]
* monitoring.sgml - clarify length of query text displayed in pg_stat_statements
@ 2016-12-01 01:37 Ian Barwick <ian.barwick@2ndquadrant.com>
0 siblings, 0 replies; 4+ messages in thread
From: Ian Barwick @ 2016-12-01 01:37 UTC (permalink / raw)
To: pgsql-docs@postgresql.org, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
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>
* monitoring.sgml - clarify length of query text displayed in pg_stat_statements
@ 2016-12-01 01:45 Ian Barwick <ian.barwick@2ndquadrant.com>
0 siblings, 1 reply; 4+ messages in thread
From: Ian Barwick @ 2016-12-01 01:45 UTC (permalink / raw)
To: pgsql-docs@postgresql.org, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
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>
* Re: [DOCS] monitoring.sgml - clarify length of query text displayed in pg_stat_statements
@ 2016-12-02 14:01 Robert Haas <robertmhaas@gmail.com>
parent: Ian Barwick <ian.barwick@2ndquadrant.com>
0 siblings, 1 reply; 4+ messages in thread
From: Robert Haas @ 2016-12-02 14:01 UTC (permalink / raw)
To: Ian Barwick <ian.barwick@2ndquadrant.com>; +Cc: pgsql-docs; pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: monitoring.sgml - clarify length of query text displayed in pg_stat_statements
@ 2016-12-05 00:55 Ian Barwick <ian.barwick@2ndquadrant.com>
parent: Robert Haas <robertmhaas@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Ian Barwick @ 2016-12-05 00:55 UTC (permalink / raw)
To: Robert Haas <robertmhaas@gmail.com>; +Cc: pgsql-docs; pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2016-12-05 00:55 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-12-01 01:37 monitoring.sgml - clarify length of query text displayed in pg_stat_statements Ian Barwick <ian.barwick@2ndquadrant.com>
2016-12-01 01:45 monitoring.sgml - clarify length of query text displayed in pg_stat_statements Ian Barwick <ian.barwick@2ndquadrant.com>
2016-12-02 14:01 ` Robert Haas <robertmhaas@gmail.com>
2016-12-05 00:55 ` Ian Barwick <ian.barwick@2ndquadrant.com>
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