From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Monnerie <lists.michael.monnerie@is.it-management.at>
Cc: pgsql-admin@postgresql.org
Subject: Re: EXPLAIN time difference in real
Date: Sat, 26 Apr 2014 14:27:43 -0400
Message-ID: <7956.1398536863@sss.pgh.pa.us> (raw)
In-Reply-To: <535BF163.9070401@is.it-management.at>
References: <535BACAC.90600@is.it-management.at>
<CADyrUxNYE53ccK9OSsS1t+XU0C_COdozCqB3ps6quwjgBx8-Kw@mail.gmail.com>
<535BF163.9070401@is.it-management.at>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Michael Monnerie <lists.michael.monnerie@is.it-management.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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, lists.michael.monnerie@is.it-management.at
Subject: Re: EXPLAIN time difference in real
In-Reply-To: <7956.1398536863@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox