Infrastructure at your Service

All Posts By

Karsten Lenz

Karsten Lenz

The log_duration parameter in PostgreSQL

By | Database Administration & Monitoring | No Comments

log_duration is a useful point for finding slow running queries and to find performance issues also on the applications side using PostgreSQL as database. Another topic is finding issues with Java Applications using Hibernate after a migration to PostgreSQL. Often Hibernate switches from lazy to eager mode and this has massive impact on the application performance. In this context I will also describe one of the most useful extensions: pg_stat_statements. The log duration shown in…

Read More