You should also keep in mind that JDBC uses prepared statements, so you have to explain analyze accordingly.
Dave On Thu, Oct 8, 2009 at 5:18 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > G B <g.b.co...@gmail.com> writes: > > How can explain-analyze return significantly much faster than other > means? > > If the returned data is large or takes a lot of work to convert to text, > this could happen, since EXPLAIN ANALYZE doesn't bother to format the > tuples for display. How big are those bytea columns, on average? > > regards, tom lane > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
