explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u147

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 156.529 130,768.203 ↑ 1.0 7,762 1

Seq Scan on collection_call_valdo ccv (cost=0.00..51,895,395.66 rows=7,943 width=276) (actual time=57.738..130,768.203 rows=7,762 loops=1)

  • Filter: ((ccv_tanggal_handling >= '2019-12-01'::date) AND (ccv_tanggal_handling <= '2019-12-31'::date))
  • Rows Removed by Filter: 103676
2.          

SubPlan (for Seq Scan)

3. 15.524 15.524 ↑ 4.0 1 7,762

Seq Scan on rslt_handling_convert (cost=0.00..20.62 rows=4 width=32) (actual time=0.002..0.002 rows=1 loops=7,762)

  • Filter: (result_handling_ind = ccv.ccv_result_handling)
  • Rows Removed by Filter: 9
4. 388.100 21,694.790 ↑ 1.0 1 7,762

Nested Loop (cost=0.00..929.09 rows=1 width=4) (actual time=1.071..2.795 rows=1 loops=7,762)

  • Join Filter: (elcd.elcd_eld_id = eld.eld_id)
  • Rows Removed by Join Filter: 808
5. 14,181.174 14,181.174 ↑ 1.0 1 7,762

Seq Scan on ecommerce_loan_data eld (cost=0.00..561.96 rows=1 width=4) (actual time=0.542..1.827 rows=1 loops=7,762)

  • Filter: ((eld_loan_disbursement_date IS NOT NULL) AND ((eld_loan_number)::text = (ccv.ccv_contract_no)::text))
  • Rows Removed by Filter: 11996
6. 7,125.516 7,125.516 ↓ 1.7 809 7,762

Seq Scan on ecommerce_loan_collection_detail elcd (cost=0.00..361.20 rows=474 width=12) (actual time=0.013..0.918 rows=809 loops=7,762)

  • Filter: (elcd_installment_to = ccv.ccv_inst_ke)
  • Rows Removed by Filter: 10567
7. 395.709 21,647.610 ↑ 1.0 1 7,759

Nested Loop (cost=0.00..929.09 rows=1 width=4) (actual time=1.070..2.790 rows=1 loops=7,759)

  • Join Filter: (elcd_1.elcd_eld_id = eld_1.eld_id)
  • Rows Removed by Join Filter: 808
8. 14,167.934 14,167.934 ↑ 1.0 1 7,759

Seq Scan on ecommerce_loan_data eld_1 (cost=0.00..561.96 rows=1 width=4) (actual time=0.542..1.826 rows=1 loops=7,759)

  • Filter: ((eld_loan_disbursement_date IS NOT NULL) AND ((eld_loan_number)::text = (ccv.ccv_contract_no)::text))
  • Rows Removed by Filter: 11996
9. 7,083.967 7,083.967 ↓ 1.7 809 7,759

Seq Scan on ecommerce_loan_collection_detail elcd_1 (cost=0.00..361.20 rows=474 width=12) (actual time=0.013..0.913 rows=809 loops=7,759)

  • Filter: (elcd_installment_to = ccv.ccv_inst_ke)
  • Rows Removed by Filter: 10567
10. 395.658 21,691.368 ↑ 1.0 1 7,758

Nested Loop (cost=0.00..929.09 rows=1 width=4) (actual time=1.071..2.796 rows=1 loops=7,758)

  • Join Filter: (elcd_2.elcd_eld_id = eld_2.eld_id)
  • Rows Removed by Join Filter: 808
11. 14,204.898 14,204.898 ↑ 1.0 1 7,758

Seq Scan on ecommerce_loan_data eld_2 (cost=0.00..561.96 rows=1 width=4) (actual time=0.543..1.831 rows=1 loops=7,758)

  • Filter: ((eld_loan_disbursement_date IS NOT NULL) AND ((eld_loan_number)::text = (ccv.ccv_contract_no)::text))
  • Rows Removed by Filter: 11996
12. 7,090.812 7,090.812 ↓ 1.7 809 7,758

Seq Scan on ecommerce_loan_collection_detail elcd_2 (cost=0.00..361.20 rows=474 width=12) (actual time=0.013..0.914 rows=809 loops=7,758)

  • Filter: (elcd_installment_to = ccv.ccv_inst_ke)
  • Rows Removed by Filter: 10567
13. 2.560 667.532 ↓ 0.0 0 7,762

Result (cost=0.00..929.09 rows=1 width=4) (actual time=0.033..0.086 rows=0 loops=7,762)

  • One-Time Filter: (ccv.ccv_result_handling = ANY ('{"SUDAH BAYAR","JANJI BAYAR "}'::text[]))
14. 11.186 664.972 ↑ 1.0 1 238

Nested Loop (cost=0.00..929.09 rows=1 width=8) (actual time=1.076..2.794 rows=1 loops=238)

  • Join Filter: (elcd_3.elcd_eld_id = eld_3.eld_id)
  • Rows Removed by Join Filter: 726
15. 437.682 437.682 ↑ 1.0 1 238

Seq Scan on ecommerce_loan_data eld_3 (cost=0.00..561.96 rows=1 width=4) (actual time=0.546..1.839 rows=1 loops=238)

  • Filter: ((eld_loan_disbursement_date IS NOT NULL) AND ((eld_loan_number)::text = (ccv.ccv_contract_no)::text))
  • Rows Removed by Filter: 11996
16. 216.104 216.104 ↓ 1.5 727 238

Seq Scan on ecommerce_loan_collection_detail elcd_3 (cost=0.00..361.20 rows=474 width=12) (actual time=0.017..0.908 rows=727 loops=238)

  • Filter: (elcd_installment_to = ccv.ccv_inst_ke)
  • Rows Removed by Filter: 10649
17. 15.524 77.620 ↑ 1.0 1 7,762

Unique (cost=8.31..8.32 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=7,762)

18. 23.286 62.096 ↑ 1.0 1 7,762

Sort (cost=8.31..8.32 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=7,762)

  • Sort Key: dd.week_of_month
  • Sort Method: quicksort Memory: 25kB
19. 38.810 38.810 ↑ 1.0 1 7,762

Index Scan using d_date_date_actual_idx on d_date dd (cost=0.29..8.30 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=7,762)

  • Index Cond: (date_actual = ccv.ccv_tanggal_handling)
20. 403.624 21,741.362 ↑ 1.0 1 7,762

Nested Loop (cost=0.00..929.09 rows=1 width=4) (actual time=1.075..2.801 rows=1 loops=7,762)

  • Join Filter: (elcd_4.elcd_eld_id = eld_4.eld_id)
  • Rows Removed by Join Filter: 808
21. 14,196.698 14,196.698 ↑ 1.0 1 7,762

Seq Scan on ecommerce_loan_data eld_4 (cost=0.00..561.96 rows=1 width=4) (actual time=0.543..1.829 rows=1 loops=7,762)

  • Filter: ((eld_loan_disbursement_date IS NOT NULL) AND ((eld_loan_number)::text = (ccv.ccv_contract_no)::text))
  • Rows Removed by Filter: 11996
22. 7,141.040 7,141.040 ↓ 1.7 809 7,762

Seq Scan on ecommerce_loan_collection_detail elcd_4 (cost=0.00..361.20 rows=474 width=12) (actual time=0.013..0.920 rows=809 loops=7,762)

  • Filter: (elcd_installment_to = ccv.ccv_inst_ke)
  • Rows Removed by Filter: 10567
23. 393.363 21,565.548 ↑ 1.0 1 7,713

Nested Loop (cost=0.00..929.09 rows=1 width=4) (actual time=1.073..2.796 rows=1 loops=7,713)

  • Join Filter: (elcd_5.elcd_eld_id = eld_5.eld_id)
  • Rows Removed by Join Filter: 808
24. 14,114.790 14,114.790 ↑ 1.0 1 7,713

Seq Scan on ecommerce_loan_data eld_5 (cost=0.00..561.96 rows=1 width=4) (actual time=0.543..1.830 rows=1 loops=7,713)

  • Filter: ((eld_loan_disbursement_date IS NOT NULL) AND ((eld_loan_number)::text = (ccv.ccv_contract_no)::text))
  • Rows Removed by Filter: 11996
25. 7,057.395 7,057.395 ↓ 1.7 809 7,713

Seq Scan on ecommerce_loan_collection_detail elcd_5 (cost=0.00..361.20 rows=474 width=12) (actual time=0.013..0.915 rows=809 loops=7,713)

  • Filter: (elcd_installment_to = ccv.ccv_inst_ke)
  • Rows Removed by Filter: 10567
26. 384.800 21,510.320 ↑ 1.0 1 7,696

Nested Loop (cost=0.00..929.09 rows=1 width=4) (actual time=1.073..2.795 rows=1 loops=7,696)

  • Join Filter: (elcd_6.elcd_eld_id = eld_6.eld_id)
  • Rows Removed by Join Filter: 808
27. 14,060.592 14,060.592 ↑ 1.0 1 7,696

Seq Scan on ecommerce_loan_data eld_6 (cost=0.00..561.96 rows=1 width=4) (actual time=0.542..1.827 rows=1 loops=7,696)

  • Filter: ((eld_loan_disbursement_date IS NOT NULL) AND ((eld_loan_number)::text = (ccv.ccv_contract_no)::text))
  • Rows Removed by Filter: 11996
28. 7,064.928 7,064.928 ↓ 1.7 809 7,696

Seq Scan on ecommerce_loan_collection_detail elcd_6 (cost=0.00..361.20 rows=474 width=12) (actual time=0.013..0.918 rows=809 loops=7,696)

  • Filter: (elcd_installment_to = ccv.ccv_inst_ke)
  • Rows Removed by Filter: 10567
Planning time : 0.896 ms
Execution time : 130,770.319 ms