Postgres Pro
Downloads
Home   >   mailing lists

Re: Explain Analyze returns faster than psql or JDBC calls. - Mailing list pgsql-performance

From Tom Lane
Subject Re: Explain Analyze returns faster than psql or JDBC calls.
Date
Msg-id 8764.1255036739@sss.pgh.pa.us
Whole thread Raw
In response to Explain Analyze returns faster than psql or JDBC calls.  (G B <g.b.coder@gmail.com>)
Responses Re: Explain Analyze returns faster than psql or JDBC calls.  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-performance
Tree view 
G B <g.b.coder@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

pgsql-performance by date:

Previous
From: Justin T Pryzby
Date:
Subject: Re: dump time increase by 1h with new kernel
Next
From: "Joshua D. Drake"
Date:
Subject: Re: dump time increase by 1h with new kernel