explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rmTj

Settings
# exclusive inclusive rows x rows loops node
1. 0.162 114.393 ↓ 10.2 51 1

Nested Loop Left Join (cost=3.67..1,645.09 rows=5 width=1,810) (actual time=24.960..114.393 rows=51 loops=1)

  • Join Filter: (fi_bpt.mapping_id = fi_eps.earlypaymentmapping_id)
2. 0.080 114.129 ↓ 10.2 51 1

Nested Loop Left Join (cost=3.67..1,593.35 rows=5 width=1,655) (actual time=24.933..114.129 rows=51 loops=1)

  • Join Filter: (fi_si.paymentadvice_id = fi_ipa.id)
3. 0.076 114.049 ↓ 10.2 51 1

Nested Loop Left Join (cost=3.67..1,582.48 rows=5 width=611) (actual time=24.924..114.049 rows=51 loops=1)

4. 0.076 110.148 ↓ 10.2 51 1

Nested Loop Left Join (cost=3.40..1,581.01 rows=5 width=597) (actual time=23.667..110.148 rows=51 loops=1)

5. 0.084 104.615 ↓ 10.2 51 1

Nested Loop Left Join (cost=2.96..1,578.53 rows=5 width=597) (actual time=22.944..104.615 rows=51 loops=1)

  • Join Filter: (fi_si.currency_id = c.id)
6. 0.084 102.899 ↓ 10.2 51 1

Nested Loop Left Join (cost=2.96..1,577.07 rows=5 width=601) (actual time=21.305..102.899 rows=51 loops=1)

7. 0.115 97.664 ↓ 10.2 51 1

Nested Loop Left Join (cost=2.69..1,575.59 rows=5 width=591) (actual time=20.942..97.664 rows=51 loops=1)

8. 0.067 95.203 ↓ 10.2 51 1

Nested Loop Left Join (cost=2.41..1,544.11 rows=5 width=581) (actual time=20.581..95.203 rows=51 loops=1)

9. 0.049 92.433 ↓ 10.2 51 1

Nested Loop Left Join (cost=1.99..1,541.79 rows=5 width=465) (actual time=19.762..92.433 rows=51 loops=1)

  • Join Filter: (fi_ps_eps_t_bc_cb.id = fi_ps_apfeps_t_apfda.bank_id)
10. 0.077 91.772 ↓ 10.2 51 1

Nested Loop Left Join (cost=1.71..1,533.41 rows=5 width=455) (actual time=19.174..91.772 rows=51 loops=1)

11. 0.143 89.247 ↓ 10.2 51 1

Nested Loop Left Join (cost=1.29..1,531.04 rows=5 width=439) (actual time=18.269..89.247 rows=51 loops=1)

  • Join Filter: (fi_si.originatordivision_id = od_db.id)
  • Rows Removed by Join Filter: 322
12. 0.105 87.217 ↓ 10.2 51 1

Nested Loop (cost=1.29..1,528.81 rows=5 width=427) (actual time=16.477..87.217 rows=51 loops=1)

13. 0.275 61.918 ↓ 10.2 51 1

Nested Loop (cost=0.86..1,525.61 rows=5 width=244) (actual time=13.066..61.918 rows=51 loops=1)

  • Join Filter: (fi_ps_apfeps.apfda_id = fi_ps_apfeps_t_apfda.id)
  • Rows Removed by Join Filter: 691
14. 0.195 60.955 ↓ 9.1 172 1

Nested Loop (cost=0.86..1,522.97 rows=19 width=244) (actual time=5.680..60.955 rows=172 loops=1)

15. 0.235 53.880 ↓ 1.2 172 1

Nested Loop (cost=0.43..1,457.55 rows=146 width=228) (actual time=4.709..53.880 rows=172 loops=1)

16. 0.669 0.669 ↑ 1.0 172 1

Seq Scan on nettingbundle nb (cost=0.00..3.72 rows=172 width=8) (actual time=0.602..0.669 rows=172 loops=1)

17. 52.976 52.976 ↑ 1.0 1 172

Index Scan using earlypaymentsettlement_invoice_idx on earlypaymentsettlement fi_eps (cost=0.43..8.45 rows=1 width=220) (actual time=0.308..0.308 rows=1 loops=172)

  • Index Cond: (invoice_id = nb.surplus_id)
  • Filter: (creationdate >= '2019-01-01'::date)
18. 6.880 6.880 ↑ 1.0 1 172

Index Scan using apfearlypaymentsettlement_pkey on apfearlypaymentsettlement fi_ps_apfeps (cost=0.42..0.45 rows=1 width=24) (actual time=0.040..0.040 rows=1 loops=172)

  • Index Cond: (id = fi_eps.id)
19. 0.203 0.688 ↑ 1.2 4 172

Materialize (cost=0.00..1.27 rows=5 width=16) (actual time=0.003..0.004 rows=4 loops=172)

20. 0.485 0.485 ↑ 1.0 5 1

Seq Scan on apfdebtoragreement fi_ps_apfeps_t_apfda (cost=0.00..1.25 rows=5 width=16) (actual time=0.481..0.485 rows=5 loops=1)

  • Filter: (bank_id = 3053)
  • Rows Removed by Filter: 15
21. 25.194 25.194 ↑ 1.0 1 51

Index Scan using supplierinvoice_pkey on supplierinvoice fi_si (cost=0.43..0.64 rows=1 width=207) (actual time=0.494..0.494 rows=1 loops=51)

  • Index Cond: (id = fi_eps.invoice_id)
22. 0.102 1.887 ↑ 2.0 7 51

Materialize (cost=0.00..1.21 rows=14 width=28) (actual time=0.035..0.037 rows=7 loops=51)

23. 1.785 1.785 ↑ 1.0 14 1

Seq Scan on divisionbase od_db (cost=0.00..1.14 rows=14 width=28) (actual time=1.775..1.785 rows=14 loops=1)

24. 2.448 2.448 ↑ 1.0 1 51

Index Scan using financingcontextbase_pkey on financingcontextbase fi_ps_apffc_fc_fcb (cost=0.42..0.47 rows=1 width=24) (actual time=0.048..0.048 rows=1 loops=51)

  • Index Cond: (id = fi_ps_apfeps.financingcontext_id)
25. 0.035 0.612 ↑ 1.0 1 51

Materialize (cost=0.28..8.30 rows=1 width=26) (actual time=0.012..0.012 rows=1 loops=51)

26. 0.577 0.577 ↑ 1.0 1 1

Index Scan using corporatebase_pkey on corporatebase fi_ps_eps_t_bc_cb (cost=0.28..8.29 rows=1 width=26) (actual time=0.577..0.577 rows=1 loops=1)

  • Index Cond: (id = 3053)
27. 2.703 2.703 ↑ 1.0 1 51

Index Scan using apffinancingcontext_pkey on apffinancingcontext fi_ps_apffc_fc_afc (cost=0.42..0.46 rows=1 width=132) (actual time=0.053..0.053 rows=1 loops=51)

  • Index Cond: (fi_ps_apfeps.financingcontext_id = id)
28. 2.346 2.346 ↑ 1.0 1 51

Index Scan using corporatebase_pkey on corporatebase od_c_cb (cost=0.28..6.29 rows=1 width=26) (actual time=0.046..0.046 rows=1 loops=51)

  • Index Cond: (id = od_db.buyer_id)
29. 5.151 5.151 ↑ 1.0 1 51

Index Scan using corporatebase_pkey on corporatebase s_cb (cost=0.28..0.30 rows=1 width=26) (actual time=0.101..0.101 rows=1 loops=51)

  • Index Cond: (id = fi_si.supplier_id)
30. 0.001 1.632 ↑ 6.0 1 51

Materialize (cost=0.00..1.09 rows=6 width=12) (actual time=0.032..0.032 rows=1 loops=51)

31. 1.631 1.631 ↑ 6.0 1 1

Seq Scan on crxcurrency c (cost=0.00..1.06 rows=6 width=12) (actual time=1.631..1.631 rows=1 loops=1)

32. 5.457 5.457 ↑ 1.0 1 51

Index Scan using arpimportbatch_pkey on arpimportbatch ib (cost=0.43..0.50 rows=1 width=16) (actual time=0.107..0.107 rows=1 loops=51)

  • Index Cond: (fi_si.importbatch_id = id)
33. 3.825 3.825 ↑ 1.0 1 51

Index Scan using earlypaymentadvice_pkey on earlypaymentadvice fi_eps_epa (cost=0.28..0.29 rows=1 width=30) (actual time=0.075..0.075 rows=1 loops=51)

  • Index Cond: (id = fi_eps.earlypaymentadvice_id)
34. 0.000 0.000 ↓ 0.0 0 51

Materialize (cost=0.00..10.15 rows=10 width=1,052) (actual time=0.000..0.000 rows=0 loops=51)

35. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on invoicepaymentadvice fi_ipa (cost=0.00..10.10 rows=10 width=1,052) (actual time=0.002..0.002 rows=0 loops=1)

36. 0.000 0.000 ↓ 0.0 0 51

Materialize (cost=0.00..10.15 rows=10 width=16) (actual time=0.000..0.000 rows=0 loops=51)

37. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on bankpaymenttransaction fi_bpt (cost=0.00..10.10 rows=10 width=16) (actual time=0.001..0.002 rows=0 loops=1)

38.          

SubPlan (for Nested Loop Left Join)

39. 0.102 0.102 ↑ 1.0 1 51

Aggregate (cost=8.15..8.16 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=51)

40. 0.000 0.000 ↓ 0.0 0 51

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt (cost=0.14..8.15 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=51)

  • Index Cond: (mapping_id = fi_eps.maturitypaymentmapping_id)
Planning time : 165.748 ms
Execution time : 114.921 ms