explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c5cP

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 2.864 ↓ 0.0 0 1

Bitmap Heap Scan on search_name sn (cost=392.61..27,216.36 rows=21 width=10) (actual time=2.864..2.864 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
2. 0.000 2.848 ↓ 0.0 0 1

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

3. 0.768 0.768 ↑ 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.768..0.768 rows=3 loops=1)

  • Index Cond: ((nameaddress_vector @> '{13522485,13522484}'::integer[]) AND (nameaddress_vector && '{889182,16547213,990772,15057781}'::integer[]))
4. 2.080 2.080 ↑ 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.079..2.080 rows=3 loops=1)

  • Index Cond: ((nameaddress_vector @> '{3344966}'::integer[]) AND (nameaddress_vector && '{889182,16547213,990772,15057781}'::integer[]))