explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lx6b

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..25.23 rows=1 width=66) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..16.63 rows=1 width=59) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using ppp_appr_ix02 on ppp_appr a (cost=0.28..8.30 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (((ptl_id)::text = 'PTL_3'::text) AND ((use_intt_id)::text = 'UTLZ_1904161319164'::text) AND (paper_appr_seq_no = '7272997'::numeric))
4. 0.000 0.000 ↓ 0.0

Index Scan using pk_ppp_resollist_corpcard_exp on ppp_resollist_corpcard_exp b (cost=0.28..8.32 rows=1 width=64) (actual rows= loops=)

  • Index Cond: (((ptl_id)::text = 'PTL_3'::text) AND ((use_intt_id)::text = 'UTLZ_1904161319164'::text) AND (appr_seq_no = a.appr_seq_no))
5. 0.000 0.000 ↓ 0.0

Index Scan using card_use_ptcl_idx_1 on card_use_ptcl c (cost=0.55..8.58 rows=1 width=76) (actual rows= loops=)

  • Index Cond: (((ptl_id)::text = 'PTL_3'::text) AND ((use_intt_id)::text = 'UTLZ_1904161319164'::text) AND ((card_no)::text = (b.card_no)::text))
  • Filter: ((b.tran_date = (apv_dt)::bpchar) AND ((b.appr_no)::text = (apv_no)::text) AND ((b.tran_no)::text = (apv_can_yn)::text) AND ((b.apv_seq)::text = (seq)::text))