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 >
