explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mKTc : Optimization for: plan #Cw7l

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 4.434 5.344 ↓ 36.2 4,343 1

Bitmap Heap Scan on blpu_uprn_street_usrn_11 (cost=4.29..137.93 rows=120 width=155) (actual time=1.433..5.344 rows=4,343 loops=1)

  • Recheck Cond: (((identifier_1)::text = '28901206'::text) OR ((identifier_2)::text = '28901206'::text))
  • Heap Blocks: exact=4,328
2. 0.001 0.910 ↓ 0.0 0 1

BitmapOr (cost=4.29..4.29 rows=120 width=0) (actual time=0.910..0.910 rows=0 loops=1)

3. 0.028 0.028 ↓ 0.0 0 1

Bitmap Index Scan on blpu_uprn_street_usrn_11_identifier_1_idx (cost=0.00..1.67 rows=1 width=0) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: ((identifier_1)::text = '28901206'::text)
4. 0.881 0.881 ↓ 36.5 4,343 1

Bitmap Index Scan on blpu_uprn_street_usrn_11_identifier_2_idx (cost=0.00..2.56 rows=119 width=0) (actual time=0.881..0.881 rows=4,343 loops=1)

  • Index Cond: ((identifier_2)::text = '28901206'::text)