explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MSix

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 3.517 ↑ 1.0 1 1

Limit (cost=17.01..21.02 rows=1 width=14) (actual time=3.514..3.517 rows=1 loops=1)

2. 0.487 3.514 ↑ 1.0 1 1

Bitmap Heap Scan on valid_address_ranges_se (cost=17.01..21.02 rows=1 width=14) (actual time=3.513..3.514 rows=1 loops=1)

  • Recheck Cond: (((street_ix)::text = 'idunvaegen'::text) AND ((locality_ix)::text = 'kolmaarden'::text))
  • Heap Blocks: exact=1
3. 0.005 3.027 ↓ 0.0 0 1

BitmapAnd (cost=17.01..17.01 rows=1 width=0) (actual time=3.027..3.027 rows=0 loops=1)

4. 1.151 1.151 ↓ 1.5 26 1

Bitmap Index Scan on valid_address_ranges_se_street_ix_like (cost=0.00..4.56 rows=17 width=0) (actual time=1.151..1.151 rows=26 loops=1)

  • Index Cond: ((street_ix)::text = 'idunvaegen'::text)
5. 1.871 1.871 ↓ 1.8 907 1

Bitmap Index Scan on valid_address_ranges_se_locality_ix_like (cost=0.00..12.20 rows=503 width=0) (actual time=1.871..1.871 rows=907 loops=1)

  • Index Cond: ((locality_ix)::text = 'kolmaarden'::text)
Planning time : 10.436 ms