From e63d41498837667a4e2e0a4b9416bfda28c722d6 Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Fri, 2 Dec 2016 08:58:41 -0500 Subject: [PATCH] Clarify that pg_stat_activity.query has a length limit. There was always documentation of the GUC that controlled what the limit actually was, but previously the documentation of the field itself made no mention of that limit. Ian Barwick --- doc/src/sgml/monitoring.sgml | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 3de489e2f0..02dab879d9 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -785,7 +785,9 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser Text of this backend's most recent query. If state is active this field shows the currently executing query. In all other states, it shows the last query - that was executed. + that was executed. By default the query text is truncated at 1024 + characters; this value can be changed via the parameter + . -- 2.40.0