From: Kevin Grittner <kgrittn@ymail.com>
To: Andomar <andomar@aule.net>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Query plan with missing timespans
Date: Wed, 22 Apr 2015 19:47:03 +0000 (UTC)
Message-ID: <223706913.2307849.1429732023067.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <5537DC6D.2010300@aule.net>
References: <5537DC6D.2010300@aule.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Andomar <andomar@aule.net> wrote:
> In the output of "explain analyze" below, what was the query
> doing between actual time 1.426 and 17.077?
Looping through 384 index scans of tbl, each taking 0.040 ms.
That's 15.36 ms. That leaves 0.291 ms unaccounted for, which means
that's about how much time the top level nested loop took to do its
work.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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-performance@postgresql.org
Cc: kgrittn@ymail.com, andomar@aule.net
Subject: Re: Query plan with missing timespans
In-Reply-To: <223706913.2307849.1429732023067.JavaMail.yahoo@mail.yahoo.com>
* 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