=?UTF-8?B?QmrDuHJu?= T Johansen <btj@havleik.no> writes:
> But when I try to run the 3 queries separately, then they are very quick, 2 barely measurable and the third takes
about1,5 seconds. The union query
> takes a little over 9 seconds, so I guess the union part is the bottleneck?
No; it's clear from your EXPLAIN output that the first UNION arm is taking
the bulk of the runtime. It's odd that it wouldn't be exactly the same
when run standalone. What does EXPLAIN ANALYZE show if you run that first
arm by itself?
I concur with depesz's observation that the MAX() subselects seem to be
pretty expensive. If you don't want to rewrite the query in a wholesale
fashion like he suggests, you might be able to make the MAX's cheaper by
providing an index on sed_uttak(avlsnr, dato); but I'm not sure how much
that will help.
regards, tom lane