explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g5NR

Settings
# exclusive inclusive rows x rows loops node
1. 4.750 4.750 ↓ 144.0 144 1

Index Scan using idx_portfolio_cd on portfolio port1 (cost=0.56..270.87 rows=1 width=4) (actual time=0.032..4.750 rows=144 loops=1)

  • Index Cond: (upper((portfolio_cd)::text) = 'SP100'::text)
  • Filter: ((portfolio_state_id = 10) AND (portfolio_class_id = ANY ('{1,2,4,8,32,NULL}'::integer[])) AND (1 = CASE WHEN (portfolio_class_id = 1) THEN CASE WHEN ((comp_construction_type_cd)::text = 'EXPLICIT'::text) THEN 1 ELSE 0 END ELSE 1 END))
  • Rows Removed by Filter: 2