explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 77oN

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.018 1.284 ↑ 1.0 1 1

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

2. 0.069 1.266 ↓ 36.0 36 1

Nested Loop Left Join (cost=1.28..86.54 rows=1 width=0) (actual time=0.063..1.266 rows=36 loops=1)

  • Filter: ((t_option.option_stock_status = ANY ('{1,5}'::integer[])) OR (t_cart_item.option_no IS NULL))
  • Rows Removed by Filter: 1
3. 0.066 0.975 ↓ 37.0 37 1

Nested Loop (cost=0.85..83.88 rows=1 width=4) (actual time=0.049..0.975 rows=37 loops=1)

4. 0.502 0.502 ↓ 9.2 37 1

Index Scan using ix_cart_item__concatenated01 on t_cart_item (cost=0.43..73.27 rows=4 width=8) (actual time=0.036..0.502 rows=37 loops=1)

  • Index Cond: ((user_no = 669352) AND (guest_session_key IS NULL))
  • Filter: ((is_deleted)::bpchar = 'F'::bpchar)
  • Rows Removed by Filter: 233
5. 0.407 0.407 ↑ 1.0 1 37

Index Scan using pk_item on t_item (cost=0.42..2.64 rows=1 width=8) (actual time=0.009..0.011 rows=1 loops=37)

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

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

  • Index Cond: (t_cart_item.option_no = option_no)