Re: Postgres 11.5 not logging all sqls

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