explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZFEe

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2.868 ↓ 0.0 0 1

Nested Loop (cost=393.18..27,396.76 rows=1 width=10) (actual time=2.868..2.868 rows=0 loops=1)

2. 0.017 2.867 ↓ 0.0 0 1

Bitmap Heap Scan on search_name sn (cost=392.61..27,216.36 rows=21 width=10) (actual time=2.867..2.867 rows=0 loops=1)

  • Recheck Cond: (((nameaddress_vector @> '{13522485,13522484}'::integer[]) AND (nameaddress_vector && '{889182,16547213,990772,15057781}'::integer[])) OR ((nameaddress_vector @> '{3344966}'::integer[]) AND (nameaddress_vector && '{889182,16547213,990772,15057781}'::integer[])))
  • Filter: ((search_rank >= 28) AND ((nameaddress_vector @> '{1389055}'::integer[]) OR (nameaddress_vector @> '{25806983}'::integer[])))
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=3
3. 0.001 2.850 ↓ 0.0 0 1

BitmapOr (cost=392.61..392.61 rows=6,860 width=0) (actual time=2.850..2.850 rows=0 loops=1)

4. 0.763 0.763 ↑ 11.3 3 1

Bitmap Index Scan on idx_search_name_nameaddress_vector (cost=0.00..172.34 rows=34 width=0) (actual time=0.763..0.763 rows=3 loops=1)

  • Index Cond: ((nameaddress_vector @> '{13522485,13522484}'::integer[]) AND (nameaddress_vector && '{889182,16547213,990772,15057781}'::integer[]))
5. 2.086 2.086 ↑ 2,275.3 3 1

Bitmap Index Scan on idx_search_name_nameaddress_vector (cost=0.00..220.26 rows=6,826 width=0) (actual time=2.086..2.086 rows=3 loops=1)

  • Index Cond: ((nameaddress_vector @> '{3344966}'::integer[]) AND (nameaddress_vector && '{889182,16547213,990772,15057781}'::integer[]))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_place_id on placex p (cost=0.57..8.59 rows=1 width=8) (never executed)

  • Index Cond: (place_id = sn.place_id)
  • Filter: (postcode = '33629'::text)