Re: Query plan with missing timespans - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Query plan with missing timespans
Date
Msg-id 223706913.2307849.1429732023067.JavaMail.yahoo@mail.yahoo.com
Whole thread Raw
In response to Query plan with missing timespans  (Andomar <andomar@aule.net>)
Responses Re: Query plan with missing timespans
List pgsql-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

pgsql-performance by date:

Previous
From: Andomar
Date:
Subject: Query plan with missing timespans
Next
From: Andomar
Date:
Subject: Re: Query plan with missing timespans