java - How to enable debug logging in PostgreSQL JDBC/HikariCP? -

i have spring boot 1.4.0, hikaricp 2.4.7, slf4j-api 1.7.21 , postgresql jdbc 9.4.1208.

i want see debug logs postgresql jdbc because have some problems hikaricp:

hikaripool-1 - connection not available, request timed out after 42734ms. 

how can enable debug logging see what's going on?

i've tried:

-adding:

org.postgresql.driver.setloglevel(driver.debug); hikaridatasource = new hikaridatasource(); hikaridatasource.setlogwriter(new printwriter(system.out)); 

-adding vm options:

-dorg.slf4j.simplelogger.defaultloglevel=debug 

however, logs same were.

few things consider:

consider logging files

1) logging sysout may cause miss updates 2) it's slow , slows app down

consider keeping log config in slf4j config file instead.

consider specific hikari config:

-dorg.slf4j.simplelogger.log.com.zaxxer.hikari=error 

also, default log level slf4j simple logger info. so, if you're not seeing anything, don't think it's config. may lack of dependency (are using slf4j, or else, log4j well?).

finally, changes picked @ all?

since it's hard on side, let me offer side logging can take place: postgres.

try changing pg logging config:

logging_collector = on # may 'true' older versions well? log_statement = # 'true' older versions log_min_error_statement = error 

first turns log collector on , makes logging not lose messages. second says interests you, simple queries syntax errors. third gives error level.

docs postgres tell more.