From: Michael Monnerie <lists.michael.monnerie@is.it-management.at>
To: pgsql-admin@postgresql.org
Subject: Re: EXPLAIN time difference in real
Date: Sat, 26 Apr 2014 19:48:19 +0200
Message-ID: <535BF163.9070401@is.it-management.at> (raw)
In-Reply-To: <CADyrUxNYE53ccK9OSsS1t+XU0C_COdozCqB3ps6quwjgBx8-Kw@mail.gmail.com>
References: <535BACAC.90600@is.it-management.at>
<CADyrUxNYE53ccK9OSsS1t+XU0C_COdozCqB3ps6quwjgBx8-Kw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Am 26.04.2014 16:17, schrieb Jov:
> Maybe your data or index is read from disk for some write heavy load
> time,your sql get 1300ms.when you explain analyze the sql,the data and
> index already in cached in the memory.
>
> you can verify this by restart the server and run the sql from a fresh
> start postgresql.
>
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?
--
mit freundlichen Grüssen,
Michael Monnerie, Ing. BSc, Tel: +43 660 415 6531
Protéger.at Internet Services Austria
Web: http://protéger.at und http://proteger.at
Facebook https://facebook.com/protegerat
Mitglied im it-management Netzwerk http://it-management.at
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: lists.michael.monnerie@is.it-management.at
Subject: Re: EXPLAIN time difference in real
In-Reply-To: <535BF163.9070401@is.it-management.at>
* 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