explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AZ7j : Optimization for: plan #77oN

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.029 466.984 ↑ 1.0 1 1

Aggregate (cost=86.54..86.55 rows=1 width=8) (actual time=466.984..466.984 rows=1 loops=1)

2. 0.081 466.955 ↓ 19.0 19 1

Nested Loop Left Join (cost=1.28..86.54 rows=1 width=0) (actual time=288.590..466.955 rows=19 loops=1)

  • Filter: ((t_option.option_stock_status = ANY ('{1,5}'::integer[])) OR (t_cart_item.option_no IS NULL))
3. 0.083 383.711 ↓ 19.0 19 1

Nested Loop (cost=0.85..83.88 rows=1 width=4) (actual time=288.583..383.711 rows=19 loops=1)

4. 364.134 364.134 ↓ 4.8 19 1

Index Scan using ix_cart_item__concatenated01 on t_cart_item (cost=0.43..73.27 rows=4 width=8) (actual time=287.546..364.134 rows=19 loops=1)

  • Index Cond: ((user_no = 710476) AND (guest_session_key IS NULL))
  • Filter: ((is_deleted)::bpchar = 'F'::bpchar)
  • Rows Removed by Filter: 75
5. 19.494 19.494 ↑ 1.0 1 19

Index Scan using pk_item on t_item (cost=0.42..2.64 rows=1 width=8) (actual time=1.023..1.026 rows=1 loops=19)

  • Index Cond: (item_no = t_cart_item.item_no)
  • Filter: (item_stock_status = ANY ('{1,5}'::integer[]))
6. 83.163 83.163 ↑ 1.0 1 19

Index Scan using pk_option on t_option (cost=0.43..2.65 rows=1 width=10) (actual time=4.376..4.377 rows=1 loops=19)

  • Index Cond: (t_cart_item.option_no = option_no)