explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 50lp : Optimization for: plan #xfZ3

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.057 0.057 ↑ 1.0 1 1

Index Scan using shippers_secondary_phone_idx on shippers (cost=0.14..12.30 rows=1 width=425) (actual time=0.055..0.057 rows=1 loops=1)

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