Right, explain alone takes 3.6 seconds, so the time really seems to go query planning...
Le 04/04/2013 17:01, Nikolas Everett a écrit :
We had a problem where the actual query planning time blew up and took way more time then the query execution. We reproduced the problem by forming a new connection and then just explaining the query. If that takes more than a couple of milliseconds you likely have the problem. The second plan was fast.
We then dtraced the backend process for a new connection and found that opening files had become super slow. In our case this was caused by running the database on nfs.
Good luck,
Nik