From: | shashidhar Reddy <shashidharreddy001(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Erik Wienhold <ewie(at)ewie(dot)name>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgres 11.5 not logging all sqls |
Date: | 2023-09-26 02:30:08 |
Message-ID: | CAH=zU4vJrcivcM6v0ExmcXLpbSbCtydKJSg3Lcw5JVdKsgSHNw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you Adrian! I will apply the patch and see.
On Tue, 26 Sept, 2023, 12:53 am Adrian Klaver, <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> 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(at)ewie(dot)name
> > <mailto:ewie(at)ewie(dot)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(dot)klaver(at)aklaver(dot)com
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2023-09-26 04:15:44 | Re: Postgres 11.5 not logging all sqls |
Previous Message | Adrian Klaver | 2023-09-25 19:23:54 | Re: Postgres 11.5 not logging all sqls |