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?
Hi there
We are runing Postgres 8.3.7 on a
We have a problem with Explain Analyze that we haven't seen before.
we run an Explain Analyze on a query.
Nested Loop (cost=1256.32..2097.31 rows=198 width=1120) (actual
time=12.958..20.846 rows=494 loops=1)
- HashAggregate
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