Re: EXPLAIN time difference in real

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Monnerie <lists(dot)michael(dot)monnerie(at)is(dot)it-management(dot)at>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: EXPLAIN time difference in real
Date: 2014-04-26 18:27:43
Message-ID: 7956.1398536863@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Michael Monnerie <lists(dot)michael(dot)monnerie(at)is(dot)it-management(dot)at> writes:
> Tried that:
> EXPLAIN ANALYZE....
> Total runtime: 280.537 ms

> EXPLAIN:LOG: duration: 1501.807 ms statement: EXPLAIN ANALYZE VERBOSE
> SELECT

> So again 1500ms versus 280ms. Why?

Could the planning time possibly account for that? How long does a plain
EXPLAIN of the same query take?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Monnerie 2014-04-27 10:57:40 Re: EXPLAIN time difference in real
Previous Message Michael Monnerie 2014-04-26 17:48:19 Re: EXPLAIN time difference in real