Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance of a nested loop, whose inner loop uses an index scan. - Mailing list pgsql-performance

From Matheus de Oliveira
Subject Re: Performance of a nested loop, whose inner loop uses an index scan.
Date
Msg-id CAJghg4Lbs-a-_xTmdTWcuQTiZCpv8hTjv2-kWc2_teyNAWiD8w@mail.gmail.com
Whole thread Raw
In response to Performance of a nested loop, whose inner loop uses an index scan.  (negora <public@negora.com>)
Responses Re: Performance of a nested loop, whose inner loop uses an index scan.  (negora <public@negora.com>)
List pgsql-performance
Tree view

On Wed, Oct 19, 2016 at 8:54 AM, negora <public@negora.com> wrote:
    Nested Loop  (cost=245.92..383723.28 rows=7109606 width=38) (actual
time=1.091..2616.553 rows=8906075 loops=1)

I wonder about the use-case for this query, because it returns more than 8M rows, so 2.6 seconds that sounds that much for so many rows. Is it for an end user application? Isn't there any kind of pagination?


--
Matheus de Oliveira


pgsql-performance by date:

Previous
From: negora
Date:
Subject: Performance of a nested loop, whose inner loop uses an index scan.
Next
From: negora
Date:
Subject: Re: Performance of a nested loop, whose inner loop uses an index scan.