explain.depesz.com

PostgreSQL's explain analyze made readable

Result: toPK : ㅁㅁ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 36,253.565 ↑ 1.0 1 1

Finalize Aggregate (cost=207,182.59..207,182.60 rows=1 width=8) (actual time=36,253.565..36,253.565 rows=1 loops=1)

  • Buffers: shared hit=51977 read=138043
2. 25.946 36,257.402 ↓ 1.2 6 1

Gather (cost=207,182.07..207,182.58 rows=5 width=8) (actual time=36,250.301..36,257.402 rows=6 loops=1)

  • Workers Planned: 5
  • Workers Launched: 5
  • Buffers: shared hit=51977 read=138043
3. 0.497 36,231.456 ↑ 1.0 1 6 / 6

Partial Aggregate (cost=206,182.07..206,182.08 rows=1 width=8) (actual time=36,231.456..36,231.456 rows=1 loops=6)

  • Buffers: shared hit=51977 read=138043
4. 0.721 36,230.959 ↓ 16.3 1,122 6 / 6

Nested Loop Anti Join (cost=12,724.20..206,181.89 rows=69 width=0) (actual time=6,883.139..36,230.959 rows=1,122 loops=6)

  • Join Filter: (rd.ord_seq = od.ord_seq)
  • Buffers: shared hit=51977 read=138043
5. 2.714 36,215.659 ↓ 16.0 1,122 6 / 6

Nested Loop (cost=12,723.35..206,104.08 rows=70 width=19) (actual time=6,883.114..36,215.659 rows=1,122 loops=6)

  • Buffers: shared hit=31774 read=138043
6. 35,085.113 36,192.758 ↓ 14.6 1,122 6 / 6

Parallel Bitmap Heap Scan on pay_ord_dtl od (cost=12,722.92..205,762.24 rows=77 width=19) (actual time=6,883.066..36,192.758 rows=1,122 loops=6)

  • Recheck Cond: ((goods_div_cd)::text = '0010'::text)
  • Filter: (((ord_cancl_yn)::text = 'N'::text) AND ((goods_dtl_div_cd)::text = '0022'::text))
  • Rows Removed by Filter: 106561
  • Heap Blocks: exact=23250
  • Buffers: shared hit=4801 read=138039
7. 1,107.645 1,107.645 ↑ 1.0 646,096 1 / 6

Bitmap Index Scan on ix_payment_pay_ord_dtl_07 (cost=0.00..12,722.82 rows=655,235 width=0) (actual time=6,645.873..6,645.873 rows=646,096 loops=1)

  • Index Cond: ((goods_div_cd)::text = '0010'::text)
  • Buffers: shared hit=3 read=3874
8. 20.187 20.187 ↑ 1.0 1 6,729 / 6

Index Scan using pk_payment_pay_ord on pay_ord o (cost=0.43..4.44 rows=1 width=15) (actual time=0.018..0.018 rows=1 loops=6,729)

  • Index Cond: ((ord_no)::text = (od.ord_no)::text)
  • Filter: (((ord_stat_cd)::text = '0002'::text) AND ((ord_cancl_yn)::text = 'N'::text))
  • Buffers: shared hit=26973 read=4
9. 1.121 14.579 ↓ 0.0 0 6,729 / 6

Nested Loop (cost=0.84..1.10 rows=1 width=19) (actual time=0.013..0.013 rows=0 loops=6,729)

  • Buffers: shared hit=20203
10. 13.458 13.458 ↓ 0.0 0 6,729 / 6

Index Scan using ix_payment_pay_refund_03 on pay_refund r (cost=0.42..0.47 rows=1 width=23) (actual time=0.012..0.012 rows=0 loops=6,729)

  • Index Cond: ((ord_no)::text = (o.ord_no)::text)
  • Filter: ((refund_div_cd)::text = '0002'::text)
  • Buffers: shared hit=20203
11. 0.000 0.000 ↓ 0.0 0 / 6

Index Scan using pk_payment_pay_refund_dtl on pay_refund_dtl rd (cost=0.42..0.61 rows=2 width=12) (never executed)

  • Index Cond: ((refund_no)::text = (r.refund_no)::text)