From: | Bruno Baguette <bruno(dot)baguette(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Slow HashAggregate : How to optimize ? |
Date: | 2009-01-22 15:36:31 |
Message-ID: | gla3pr$283a$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hello !
I'm having a problem with a query that takes more or less 3.2 seconds to
be executed.
This query uses a view which encapsulates some calculations (in order to
avoid duplicating theses calculations at several places in the project).
In order to keep that post readable, I've put the view details on that
page : <http://pastebin.com/m1523940>
Here's the EXPLAIN ANALYZE of a query using that view :
<http://pastebin.com/m1b94cd9b>
As I read the query plan, the HashAggregate takes near than 3 seconds,
which represent 90% of the query duration time.
How can I see which part of the query causes the HashAggregate to be so
slow ?
How can I optimize that view to reduce the execution duration time ?
To be accurate, I'm working on PostgreSQL 8.3.5.
Many thanks in advance for any tips about that ! :-)
Best Regards,
--
Bruno Baguette - bruno(dot)baguette(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2009-01-22 15:36:37 | Re: caching written values? |
Previous Message | Robert Haas | 2009-01-22 15:34:29 | Re: caching indexes and pages? |