Problem analyzing explain analyze output

From: Guillaume Smet <guillaume(dot)smet(at)openwide(dot)fr>
To: pgsql-performance(at)postgresql(dot)org
Subject: Problem analyzing explain analyze output
Date: 2005-10-23 23:53:59
Message-ID: 435C2297.5050207@openwide.fr
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all,

I'm currently testing PostgreSQL 8.1 beta3 and I have a problem with a
EXPLAIN ANALYZE output. You can find it attached.

I don't understand why I have the Nested Loop at line 19 with an actual
time of 254.292..257.328 because I can't find anywhere the line taking
this 254 ms. Is it a problem with 8.1b3 or can anyone explain me where I
can find the part of the query taking this time? I'm not sure to
understand the new bitmap scan stuff.

Thanks for your help

Regards,

--
Guillaume

Attachment Content-Type Size
explain_analyze.txt text/plain 5.0 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2005-10-24 00:08:24 Re: Problem analyzing explain analyze output
Previous Message Kishore B 2005-10-23 21:55:50 Re: [PERFORM] Need help in setting optimal configuration for a huge database.