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 <[email protected]> wrote: > G B <[email protected]> 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >
