Re: [EXPLAIN] Nested loops - Mailing list pgsql-general

From Tom Lane
Subject Re: [EXPLAIN] Nested loops
Date
Msg-id 29030.1231527657@sss.pgh.pa.us
Whole thread Raw
In response to Re: [EXPLAIN] Nested loops  (Reg Me Please <regmeplease@gmail.com>)
Responses Re: [EXPLAIN] Nested loops  (Reg Me Please <regmeplease@gmail.com>)
List pgsql-general
Reg Me Please <regmeplease@gmail.com> writes:
>  Aggregate  (cost=227.59..227.61 rows=1 width=8)
>    ->  Nested Loop  (cost=0.00..227.34 rows=49 width=8)
>          ->  Seq Scan on T2  (cost=0.00..1.07 rows=6 width=4)
>                Filter: (fld1 = 'VEND'::text)
>          ->  Index Scan using i_T1_partial on T1  (cost=0.00..37.61 rows=8
> width=8)
>                Index Cond: ((T1.prod_id = 42) AND (T1.fk1 = T2.fk1))

If those rowcount estimates are accurate, then this is a perfectly good
plan; in fact probably the best you could hope for.

            regards, tom lane

pgsql-general by date:

Previous
From: Reg Me Please
Date:
Subject: Re: [EXPLAIN] Nested loops
Next
From: Reg Me Please
Date:
Subject: Re: [EXPLAIN] Nested loops