Postgres 11.5 not logging all sqls
Hello
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.
On Mon, 2023-09-25 at 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
I don't know about pgAdmin, but the log will certainly have the complete
statement.
Yours,
Laurenz Albe
Hi Laurenz,
Iog is also showing few lines that is incomplete statement.
On Mon, 25 Sept, 2023, 5:05 pm Laurenz Albe, <laurenz.albe@cybertec.at>
wrote:
Show quoted text
On Mon, 2023-09-25 at 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 queryI don't know about pgAdmin, but the log will certainly have the complete
statement.Yours,
Laurenz Albe
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]https://www.postgresql.org/docs/11/runtime-config-statistics.html#GUC-TRACK-ACTIVITY-QUERY-SIZE. 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
--
Erik
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.
On Mon, 25 Sept, 2023, 5:33 pm Erik Wienhold, <ewie@ewie.name> wrote:
Show quoted text
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 pgadminfor
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--
Erik
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 thelogs 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
Thank you Adrian! I will apply the patch and see.
On Tue, 26 Sept, 2023, 12:53 am Adrian Klaver, <adrian.klaver@aklaver.com>
wrote:
Show quoted text
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