darold / pgbadger

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

pgbadger 12.0 : Fail to normalize query with ::tsrange #768

Closed grib0 closed 1 year ago

grib0 commented 1 year ago

The following request fails to bind correctly with pgbadger 12.0 It's ok with pgbadger 11.8

select public.t_plage_cloturee_utilisateur.pcu_utilisateur_nni_fk, public.t_plage_cloturee_utilisateur.pcu_range_cloture from public.t_plage_cloturee_utilisateur where (public.t_plage_cloturee_utilisateur.pcu_utilisateur_nni_fk in ($1, $2, $3, $4, $5, $6, $7) and (public.t_plage_cloturee_utilisateur.pcu_range_cloture && $8::tsrange))

pgbadger -f stderr postgresql_pb_range.log output 1 query with 3 examples in time consuming normalized with pgbadger 11.8 output 3 queries with 1 example each with pgbadger 12.0

pgbadger 11.8 OK image

pgbadger 12.0 KO image

postgresql_pb_range.log attached postgresql_log_pb_range.log

darold commented 1 year ago

Commit b163e52 fix this issue.