explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IQWe : Optimization for: Optimization for: plan #xfZ3; plan #50lp

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.020 0.066 ↑ 3.0 1 1

Bitmap Heap Scan on shippers (cost=8.44..16.31 rows=3 width=425) (actual time=0.065..0.066 rows=1 loops=1)

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

Bitmap Index Scan on shippers_secondary_phone_idx (cost=0.00..8.44 rows=3 width=0) (actual time=0.046..0.046 rows=1 loops=1)

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