Explain analyze time overhead

From: salah jubeh <s_jubeh(at)yahoo(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Explain analyze time overhead
Date: 2013-12-05 14:09:00
Message-ID: 1386252540.32882.YahooMailNeo@web122206.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello guys,

When I excute a query,  the exection time is about 1 minute; however, when I execute the query with explain analyze the excution time jumps to 10 minutes.

I have tried this for several queries, where  I need to optimize;  and using explain analyze leads alway to a huge time overhead in factor of 10.

This is a little bit starnge for me; did any one experience somthing like this? Can I trust the generated plans?

Regards

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message vincent elschot 2013-12-05 14:21:20 Re: Explain analyze time overhead
Previous Message Max 2013-12-05 10:42:10 One huge db vs many small dbs