On 9/25/23 11:55, shashidhar Reddy wrote:
Thank you Erik,
Not all queries are truncated at same size,different queries different
sizes but all 11.5 servers are behaving in same manner.
FYI, the last minor release for version is 11.21. You are missing 16
bug/security fixes. I would update to 11.21 and then see if the issue
persists.
On Mon, 25 Sept, 2023, 5:33 pm Erik Wienhold, <ewie@xxxxxxxxx
<mailto:ewie@xxxxxxxxx>> wrote:
On 2023-09-25 16:54 +0530, shashidhar Reddy wrote:
> We are using postgres 11.5 on Ubuntu we have enabled logging and set
> log_statements to all but when I checked the statements in the
logs I can
> see only first few lines of the query and also when I check in
pgadmin for
> current queries I could see only few lines. Some one please help
me to get
> full queries in the logs and in pgadmin4.
* Could be that the logging collector truncates messages. Are all
messages truncated to the same length?
* pgAdmin reads pg_stat_activity.query which is subject to config
track_activity_query_size[1]. That should, however, not affect
logging.
* Maybe a bug 11.5 which is already 4 years old.
[1]
https://www.postgresql.org/docs/11/runtime-config-statistics.html#GUC-TRACK-ACTIVITY-QUERY-SIZE <https://www.postgresql.org/docs/11/runtime-config-statistics.html#GUC-TRACK-ACTIVITY-QUERY-SIZE>
--
Erik
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
