darold / pgbadger

A fast PostgreSQL Log Analyzer
http://pgbadger.darold.net/
PostgreSQL License
3.49k stars 349 forks source link

Cannot exclude Query #741

Closed rdnkrkmz closed 2 years ago

rdnkrkmz commented 2 years ago

Version: 11.8 We exclude the following query, but query still stand in report. what we use is: --exclude-query "^(INSERT INTO ce_task_input)" It is worth to mention that, Query bind size is approximately 72mb hex in bytea type of input_data column

Here is the actual query and log line:

2022-07-20 09:30:40 +03 [17399]: dbuser,db=dbname,app=PostgreSQL JDBC Driver,client=10.10.10.10 LOG: duration: 942.503 ms bind : INSERT INTO ce_task_input (task_uuid, created_at, updated_at, input_data) VALUES ($1, $2, $3, $4) 2022-07-20 09:30:40 +03 [17399]: user=usonarcube,db=pguyap,app=PostgreSQL JDBC Driver,client=10.201.167.50 DETAIL: parameters: $1 = 'AXIbTRJ9Lf3qZSmclwfE', $2 = '1758298634800', $3 = '1758298634800', $4 = '\x504b0304140008080800cf33f454000000000000 ......................... (up to 72MB long bytes, one line)

The table definition is:

CREATE TABLE ce_task_input ( task_uuid varchar(40) NOT NULL, input_data bytea NULL, created_at int8 NOT NULL, updated_at int8 NOT NULL, CONSTRAINT pk_ce_task_input PRIMARY KEY (task_uuid) );

darold commented 2 years ago

Commit e4da5f2 might fix this issue.

rdnkrkmz commented 2 years ago

Thanks. Yes, fixed.