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, <e...@ewie.name <mailto:e...@ewie.name>> 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.kla...@aklaver.com



Reply via email to