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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: G B <g(dot)b(dot)coder(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Explain Analyze returns faster than psql or JDBC calls.
Date: 2009-10-08 21:18:59
Message-ID: 8764.1255036739@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shiva Raman 2009-10-09 07:11:26 Re: High CPU load on Postgres Server during Peak times!!!!
Previous Message Justin T Pryzby 2009-10-08 21:15:36 Re: dump time increase by 1h with new kernel