Performance down with JDBC 42

Abraham, Danny <danny_abraham@bmc.com>

From: "Abraham, Danny" <danny_abraham@bmc.com>
To: psql-performance <pgsql-performance@postgresql.org>
Cc: "Abraham, Danny" <danny_abraham@bmc.com>
Date: 2023-11-04T19:08:22Z
Lists: pgsql-performance
Hi,

Asking for help with a JDBC related issue.
Environment: Linux 7.9 PG 14.9 , very busy PG Server.

A big query - 3 unions and about 10 joins runs :
- 70ms on psql , DBeaver with JDBC 42  and  in our Server using old JDBC 9.2
- 2500 ms in our Server using new JDBC 42 driver. ( and  this is running many times) 

Question: Is there a structured way to identify optimization setup ( Planner Method s ) changes?
Are there any known changes specific to JDBC 42. 
Capture a vector of session optimization setup?  
Any other Idea ?

Thanks

Danny