explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.050 0.050 ↑ 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.048..0.050 rows=1 loops=1)

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