explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xfZ3

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.013 0.036 ↑ 2.0 1 1

Bitmap Heap Scan on shippers (cost=8.29..14.05 rows=2 width=425) (actual time=0.035..0.036 rows=1 loops=1)

  • Recheck Cond: (secondary_phone = ANY ('{0333628332,0333628322}'::text[]))
  • Heap Blocks: exact=1
2. 0.023 0.023 ↑ 2.0 1 1

Bitmap Index Scan on shippers_secondary_phone_idx (cost=0.00..8.29 rows=2 width=0) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: (secondary_phone = ANY ('{0333628332,0333628322}'::text[]))