explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y1Q8 : ㅁㅁ

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 314.524 ↑ 1.0 1 1

Aggregate (cost=1,241.59..1,241.60 rows=1 width=8) (actual time=314.524..314.524 rows=1 loops=1)

2. 0.003 314.518 ↑ 1.0 1 1

Nested Loop Anti Join (cost=132.87..1,241.59 rows=1 width=0) (actual time=95.595..314.518 rows=1 loops=1)

  • Join Filter: (rd.ord_seq = od.ord_seq)
3. 0.006 314.493 ↑ 1.0 1 1

Nested Loop (cost=132.02..1,240.32 rows=1 width=19) (actual time=95.570..314.493 rows=1 loops=1)

  • Join Filter: (dvs.ord_seq = od.ord_seq)
4. 0.012 313.843 ↓ 2.0 2 1

Nested Loop (cost=131.46..1,239.33 rows=1 width=34) (actual time=95.542..313.843 rows=2 loops=1)

5. 278.872 312.419 ↑ 18.0 2 1

Bitmap Heap Scan on ldv_std dvs (cost=130.91..1,074.36 rows=36 width=27) (actual time=95.501..312.419 rows=2 loops=1)

  • Recheck Cond: ((voca_listen_div_cd)::text = '0002'::text)
  • Filter: (((std_st_dt)::text <= ((((((now())::character varying(23))::date)::character varying(10))::date)::character varying(10))::text) AND ((last_std_ed_dt)::text >= ((((((now())::character varying(23))::date)::character varying(10))::date)::character varying(10))::text))
  • Rows Removed by Filter: 6727
  • Heap Blocks: exact=218
6. 33.547 33.547 ↑ 1.0 6,730 1

Bitmap Index Scan on ix_lecture_ldv_std_01 (cost=0.00..130.90 rows=6,748 width=0) (actual time=33.547..33.547 rows=6,730 loops=1)

  • Index Cond: ((voca_listen_div_cd)::text = '0002'::text)
7. 1.412 1.412 ↑ 1.0 1 2

Index Only Scan using ix_payment_pay_ord_09 on pay_ord o (cost=0.56..4.58 rows=1 width=23) (actual time=0.706..0.706 rows=1 loops=2)

  • Index Cond: ((ord_cancl_yn = 'N'::text) AND (ord_no = (dvs.ord_no)::text) AND (mem_no = (dvs.mem_no)::text) AND (ord_stat_cd = '0002'::text))
  • Heap Fetches: 0
8. 0.644 0.644 ↓ 0.0 0 2

Index Scan using ix_payment_pay_ord_dtl_08 on pay_ord_dtl od (cost=0.56..0.98 rows=1 width=19) (actual time=0.322..0.322 rows=0 loops=2)

  • Index Cond: (((ord_no)::text = (o.ord_no)::text) AND ((ord_cancl_yn)::text = 'N'::text) AND ((goods_div_cd)::text = '0010'::text))
  • Filter: ((goods_dtl_div_cd)::text = '0022'::text)
9. 0.002 0.022 ↓ 0.0 0 1

Nested Loop (cost=0.84..1.26 rows=1 width=19) (actual time=0.022..0.022 rows=0 loops=1)

10. 0.020 0.020 ↓ 0.0 0 1

Index Scan using ix_payment_pay_refund_03 on pay_refund r (cost=0.42..0.48 rows=1 width=23) (actual time=0.019..0.020 rows=0 loops=1)

  • Index Cond: ((ord_no)::text = (o.ord_no)::text)
  • Filter: ((refund_div_cd)::text = '0002'::text)
11. 0.000 0.000 ↓ 0.0 0

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

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