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