> 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. Well, it IS aggregating almost 80,000 rows. That doesn't sound that bad to me. What kind of hardware are you running this on? ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
