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 questions about this.

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

2011-07-11 Thread Jonathan Barber
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 questions about this. First, when I look at the logs, the long queries appea