On 09/21/2010 08:25 PM, Gary Stainburn wrote:
Hi folks,I have a view that seems to be very slow compared to similar views on
the same server.
I've had a look at running explain but I don't really understand it.
I've posted the view and the output from explain at
http://www1.ringways.co.uk/explain.txt
Woah. That's an interesting plan.
When concerned about execution time, it's probably best to post EXPLAIN
ANALYZE rather than plain EXPLAIN results. EXPLAIN ANALYZE provides more
timing information and information about how rowcount estimates differed
from reality.
--
Craig Ringer
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
