Re: [GENERAL] Slow queries (high duration) and their log entries appearing out-of-order

2011-07-12 Thread Jonathan Barber
On 11 July 2011 17:19, Jonathan Barber wrote: > I'm trying to debug a jboss/hibernate application that uses PostgreSQL > as a backend, for which PostgreSQL is reporting a lot of queries as > taking around 4398046 ms (~73 minutes) plus or minus 10 ms to > complete. I have two que

[GENERAL] Slow queries (high duration) and their log entries appearing out-of-order

2011-07-11 Thread Jonathan Barber
rg/ftp/binary/ Jboss is 4.2.3-GA, running on the Sun JDK 1.6.0u12, with the PostgreSQL JDBC JAR postgresql-8.3-603.jdbc4.jar. I realise that I'm behind on the minor version for the PostgreSQL server, and I'm going to recommend upgrading - but it'd be nice to know if any