Re: Explain Analyze returns faster than psql or JDBC calls.

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> G B <g(dot)b(dot)coder(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>