On 19th of November Tom Lane committed patch by Takahiro Itagaki which does:
Add auto-explain contrib module for automatic logging of the plans of slow-running queries.
Tag: explain
Prepared statements gotcha
Friend from my previous employer told me that plans of execution of prepared statement, and the same statement run “as it" are different.
Well, I checked and this is what I found (it's not shocking, it's actually quite obvious, but You have to think about it for a while to “get it").
Waiting for 8.4 – “EXPLAIN VERBOSE”
Tom Lane committed his patch which modifies output of “EXPLAIN VERBOSE" command.