explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XJT8

Settings
# exclusive inclusive rows x rows loops node
1. 0.425 569.318 ↑ 27.2 10,816 1

Append (cost=18,679.63..2,698,495.25 rows=294,139 width=1,792) (actual time=358.876..569.318 rows=10,816 loops=1)

2. 17.134 540.551 ↑ 13.8 10,261 1

Gather (cost=18,679.63..1,385,072.26 rows=141,290 width=1,758) (actual time=358.874..540.551 rows=10,261 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 3.232 513.156 ↑ 17.2 3,420 3 / 3

Hash Left Join (cost=17,679.63..215,250.73 rows=58,871 width=1,655) (actual time=349.401..513.156 rows=3,420 loops=3)

  • Hash Cond: (ps_eps.earlypaymentmapping_id = bpt.mapping_id)
4. 3.084 509.920 ↑ 17.2 3,420 3 / 3

Hash Left Join (cost=17,669.41..215,019.73 rows=58,871 width=1,655) (actual time=349.379..509.920 rows=3,420 loops=3)

  • Hash Cond: (si.paymentadvice_id = ipa.id)
5. 3.061 506.831 ↑ 17.2 3,420 3 / 3

Hash Left Join (cost=17,659.19..214,854.97 rows=58,871 width=611) (actual time=349.358..506.831 rows=3,420 loops=3)

  • Hash Cond: (ps_eps.earlypaymentadvice_id = eps_epa.id)
6. 3.136 503.055 ↑ 17.2 3,420 3 / 3

Hash Left Join (cost=17,626.92..214,668.17 rows=58,871 width=597) (actual time=348.626..503.055 rows=3,420 loops=3)

  • Hash Cond: (si.currency_id = c.id)
7. 5.921 499.906 ↑ 17.2 3,420 3 / 3

Nested Loop Left Join (cost=17,625.79..214,403.34 rows=58,871 width=601) (actual time=348.596..499.906 rows=3,420 loops=3)

8. 3.114 487.144 ↑ 17.2 3,420 3 / 3

Hash Left Join (cost=17,625.35..185,113.67 rows=58,871 width=601) (actual time=348.577..487.144 rows=3,420 loops=3)

  • Hash Cond: (si.supplier_id = s_cb.id)
9. 3.151 482.522 ↑ 17.2 3,420 3 / 3

Hash Left Join (cost=17,414.23..184,747.61 rows=58,871 width=591) (actual time=347.051..482.522 rows=3,420 loops=3)

  • Hash Cond: (od_db.buyer_id = od_c_cb.id)
10. 3.244 477.873 ↑ 17.2 3,420 3 / 3

Hash Left Join (cost=17,203.10..184,381.55 rows=58,871 width=581) (actual time=345.535..477.873 rows=3,420 loops=3)

  • Hash Cond: (si.originatordivision_id = od_db.id)
11. 3.371 474.605 ↑ 17.2 3,420 3 / 3

Hash Left Join (cost=17,201.79..184,178.92 rows=58,871 width=569) (actual time=345.493..474.605 rows=3,420 loops=3)

  • Hash Cond: (ps_apfeps_t_apfda.bank_id = ps_eps_t_bc_cb.id)
12. 4.679 469.486 ↑ 17.2 3,420 3 / 3

Parallel Hash Left Join (cost=16,990.67..183,812.86 rows=58,871 width=559) (actual time=343.724..469.486 rows=3,420 loops=3)

  • Hash Cond: (ps_apffc_fc_fcb.id = ps_apffc_fc_afc.id)
13. 4.532 386.357 ↑ 17.2 3,420 3 / 3

Parallel Hash Left Join (cost=9,845.58..176,513.23 rows=58,871 width=443) (actual time=264.456..386.357 rows=3,420 loops=3)

  • Hash Cond: (ps_apfeps.financingcontext_id = ps_apffc_fc_fcb.id)
14. 6.787 260.359 ↑ 17.2 3,420 3 / 3

Nested Loop (cost=2.17..166,515.28 rows=58,871 width=427) (actual time=142.182..260.359 rows=3,420 loops=3)

15. 24.016 246.687 ↑ 17.1 3,443 3 / 3

Nested Loop (cost=1.73..128,761.94 rows=58,890 width=236) (actual time=142.163..246.687 rows=3,443 loops=3)

16. 93.053 169.548 ↑ 2.6 26,562 3 / 3

Hash Join (cost=1.30..9,862.01 rows=69,276 width=24) (actual time=142.132..169.548 rows=26,562 loops=3)

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
17. 76.469 76.469 ↑ 1.3 277,103 3 / 3

Parallel Seq Scan on apfearlypaymentsettlement ps_apfeps (cost=0.00..8,758.79 rows=346,379 width=24) (actual time=0.004..76.469 rows=277,103 loops=3)

18. 0.009 0.026 ↑ 1.0 4 3 / 3

Hash (cost=1.25..1.25 rows=4 width=16) (actual time=0.025..0.026 rows=4 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.017 0.017 ↑ 1.0 4 3 / 3

Seq Scan on apfdebtoragreement ps_apfeps_t_apfda (cost=0.00..1.25 rows=4 width=16) (actual time=0.016..0.017 rows=4 loops=3)

  • Filter: (buyer_id = 67002626)
  • Rows Removed by Filter: 16
20. 53.123 53.123 ↓ 0.0 0 79,685 / 3

Index Scan using earlypaymentsettlement_pkey on earlypaymentsettlement ps_eps (cost=0.43..1.72 rows=1 width=220) (actual time=0.002..0.002 rows=0 loops=79,685)

  • Index Cond: (id = ps_apfeps.id)
  • Filter: (creationdate >= '2019-01-01'::date)
  • Rows Removed by Filter: 1
21. 6.885 6.885 ↑ 1.0 1 10,328 / 3

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..0.64 rows=1 width=207) (actual time=0.002..0.002 rows=1 loops=10,328)

  • Index Cond: (id = ps_eps.invoice_id)
  • Filter: (nettingbundle_id IS NULL)
  • Rows Removed by Filter: 0
22. 66.063 121.466 ↑ 1.3 131,499 3 / 3

Parallel Hash (cost=7,788.74..7,788.74 rows=164,374 width=24) (actual time=121.466..121.466 rows=131,499 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 26656kB
23. 55.403 55.403 ↑ 1.3 131,499 3 / 3

Parallel Seq Scan on financingcontextbase ps_apffc_fc_fcb (cost=0.00..7,788.74 rows=164,374 width=24) (actual time=0.006..55.403 rows=131,499 loops=3)

24. 41.907 78.450 ↑ 1.2 79,932 3 / 3

Parallel Hash (cost=5,896.15..5,896.15 rows=99,915 width=132) (actual time=78.450..78.450 rows=79,932 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 20832kB
25. 36.543 36.543 ↑ 1.2 79,932 3 / 3

Parallel Seq Scan on apffinancingcontext ps_apffc_fc_afc (cost=0.00..5,896.15 rows=99,915 width=132) (actual time=0.006..36.543 rows=79,932 loops=3)

26. 0.687 1.748 ↑ 1.0 1,650 3 / 3

Hash (cost=190.50..190.50 rows=1,650 width=26) (actual time=1.748..1.748 rows=1,650 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
27. 1.061 1.061 ↑ 1.0 1,650 3 / 3

Seq Scan on corporatebase ps_eps_t_bc_cb (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.017..1.061 rows=1,650 loops=3)

28. 0.010 0.024 ↑ 1.0 14 3 / 3

Hash (cost=1.14..1.14 rows=14 width=28) (actual time=0.024..0.024 rows=14 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.014 0.014 ↑ 1.0 14 3 / 3

Seq Scan on divisionbase od_db (cost=0.00..1.14 rows=14 width=28) (actual time=0.006..0.014 rows=14 loops=3)

30. 0.681 1.498 ↑ 1.0 1,650 3 / 3

Hash (cost=190.50..190.50 rows=1,650 width=26) (actual time=1.498..1.498 rows=1,650 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
31. 0.817 0.817 ↑ 1.0 1,650 3 / 3

Seq Scan on corporatebase od_c_cb (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.002..0.817 rows=1,650 loops=3)

32. 0.683 1.508 ↑ 1.0 1,650 3 / 3

Hash (cost=190.50..190.50 rows=1,650 width=26) (actual time=1.508..1.508 rows=1,650 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
33. 0.825 0.825 ↑ 1.0 1,650 3 / 3

Seq Scan on corporatebase s_cb (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.003..0.825 rows=1,650 loops=3)

34. 6.841 6.841 ↑ 1.0 1 10,261 / 3

Index Scan using arpimportbatch_pkey on arpimportbatch ib (cost=0.43..0.50 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=10,261)

  • Index Cond: (si.importbatch_id = id)
35. 0.005 0.013 ↑ 1.0 6 3 / 3

Hash (cost=1.06..1.06 rows=6 width=12) (actual time=0.013..0.013 rows=6 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
36. 0.008 0.008 ↑ 1.0 6 3 / 3

Seq Scan on crxcurrency c (cost=0.00..1.06 rows=6 width=12) (actual time=0.006..0.008 rows=6 loops=3)

37. 0.377 0.715 ↑ 1.0 945 3 / 3

Hash (cost=20.45..20.45 rows=945 width=30) (actual time=0.715..0.715 rows=945 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
38. 0.338 0.338 ↑ 1.0 945 3 / 3

Seq Scan on earlypaymentadvice eps_epa (cost=0.00..20.45 rows=945 width=30) (actual time=0.005..0.338 rows=945 loops=3)

39. 0.001 0.005 ↓ 0.0 0 3 / 3

Hash (cost=10.10..10.10 rows=10 width=1,052) (actual time=0.004..0.005 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
40. 0.004 0.004 ↓ 0.0 0 3 / 3

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

41. 0.000 0.004 ↓ 0.0 0 3 / 3

Hash (cost=10.10..10.10 rows=10 width=16) (actual time=0.004..0.004 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
42. 0.004 0.004 ↓ 0.0 0 3 / 3

Seq Scan on bankpaymenttransaction bpt (cost=0.00..10.10 rows=10 width=16) (actual time=0.003..0.004 rows=0 loops=3)

43.          

SubPlan (for Gather)

44. 10.261 10.261 ↑ 1.0 1 10,261

Aggregate (cost=8.15..8.16 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=10,261)

45. 0.000 0.000 ↓ 0.0 0 10,261

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt_3 (cost=0.14..8.15 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=10,261)

  • Index Cond: (mapping_id = ps_eps.maturitypaymentmapping_id)
46. 0.001 2.074 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.97..17,636.11 rows=13 width=1,790) (actual time=2.074..2.074 rows=0 loops=1)

  • Join Filter: (fi_si.paymentadvice_id = fi_ipa.id)
47. 0.001 2.073 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.97..17,517.83 rows=13 width=387) (actual time=2.073..2.073 rows=0 loops=1)

  • Join Filter: (bpt_1.mapping_id = fi_eps.earlypaymentmapping_id)
48. 0.000 2.072 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.97..17,505.75 rows=13 width=387) (actual time=2.072..2.072 rows=0 loops=1)

49. 0.002 2.072 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.70..17,501.95 rows=13 width=373) (actual time=2.071..2.072 rows=0 loops=1)

50. 0.000 2.070 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.28..17,495.92 rows=13 width=257) (actual time=2.070..2.070 rows=0 loops=1)

  • Join Filter: (scn.currency_id = c_1.id)
51. 0.001 2.070 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.28..17,493.80 rows=13 width=261) (actual time=2.070..2.070 rows=0 loops=1)

52. 0.001 2.069 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.84..17,387.72 rows=13 width=261) (actual time=2.069..2.069 rows=0 loops=1)

53. 0.000 2.068 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.57..17,305.88 rows=13 width=251) (actual time=2.068..2.068 rows=0 loops=1)

  • Join Filter: (fi_si.originatordivision_id = od_db_1.id)
54. 0.001 2.068 ↓ 0.0 0 1

Nested Loop (cost=1.57..17,302.16 rows=13 width=239) (actual time=2.068..2.068 rows=0 loops=1)

  • Join Filter: (scn.referencedinvoice_id = fi_si.id)
55. 0.000 2.067 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.14..17,301.53 rows=1 width=201) (actual time=2.067..2.067 rows=0 loops=1)

56. 0.001 2.067 ↓ 0.0 0 1

Nested Loop (cost=0.86..17,300.89 rows=1 width=191) (actual time=2.066..2.067 rows=0 loops=1)

  • Join Filter: (fi_ps_apfeps.apfda_id = ps_apfeps_t_apfda_1.id)
57. 0.001 2.066 ↓ 0.0 0 1

Nested Loop (cost=0.86..17,299.63 rows=1 width=199) (actual time=2.066..2.066 rows=0 loops=1)

58. 1.573 2.065 ↓ 0.0 0 1

Nested Loop (cost=0.43..17,299.18 rows=1 width=191) (actual time=2.065..2.065 rows=0 loops=1)

59. 0.492 0.492 ↑ 1.0 2,096 1

Seq Scan on suppliercreditnote scn (cost=0.00..78.96 rows=2,096 width=151) (actual time=0.008..0.492 rows=2,096 loops=1)

60. 0.000 0.000 ↓ 0.0 0 2,096

Index Scan using earlypaymentsettlement_invoice_idx on earlypaymentsettlement fi_eps (cost=0.43..8.21 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=2,096)

  • Index Cond: (invoice_id = scn.referencedinvoice_id)
  • Filter: (creationdate >= '2012-01-01'::date)
61. 0.000 0.000 ↓ 0.0 0

Index Scan using apfearlypaymentsettlement_pkey on apfearlypaymentsettlement fi_ps_apfeps (cost=0.42..0.45 rows=1 width=24) (never executed)

  • Index Cond: (id = fi_eps.id)
62. 0.000 0.000 ↓ 0.0 0

Seq Scan on apfdebtoragreement ps_apfeps_t_apfda_1 (cost=0.00..1.25 rows=1 width=8) (never executed)

  • Filter: (buyer_id = 3065)
63. 0.000 0.000 ↓ 0.0 0

Index Scan using corporatebase_pkey on corporatebase s_cb_1 (cost=0.28..0.64 rows=1 width=26) (never executed)

  • Index Cond: (id = scn.supplier_id)
64. 0.000 0.000 ↓ 0.0 0

Index Scan using supplierinvoice_pkey on supplierinvoice fi_si (cost=0.43..0.61 rows=1 width=54) (never executed)

  • Index Cond: (id = fi_eps.invoice_id)
  • Filter: (nettingbundle_id IS NULL)
65. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.21 rows=14 width=28) (never executed)

66. 0.000 0.000 ↓ 0.0 0

Seq Scan on divisionbase od_db_1 (cost=0.00..1.14 rows=14 width=28) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Index Scan using corporatebase_pkey on corporatebase od_c_cb_1 (cost=0.28..6.29 rows=1 width=26) (never executed)

  • Index Cond: (id = od_db_1.buyer_id)
68. 0.000 0.000 ↓ 0.0 0

Index Scan using arpimportbatch_pkey on arpimportbatch ib_1 (cost=0.43..8.16 rows=1 width=16) (never executed)

  • Index Cond: (scn.importbatch_id = id)
69. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.09 rows=6 width=12) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Seq Scan on crxcurrency c_1 (cost=0.00..1.06 rows=6 width=12) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Index Scan using apffinancingcontext_pkey on apffinancingcontext fi_ps_apffc_fc_afc (cost=0.42..0.46 rows=1 width=132) (never executed)

  • Index Cond: (id = fi_ps_apfeps.financingcontext_id)
72. 0.000 0.000 ↓ 0.0 0

Index Scan using earlypaymentadvice_pkey on earlypaymentadvice fi_eps_epa (cost=0.28..0.29 rows=1 width=30) (never executed)

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

Materialize (cost=0.00..10.15 rows=10 width=16) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Seq Scan on bankpaymenttransaction bpt_1 (cost=0.00..10.10 rows=10 width=16) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..10.15 rows=10 width=1,052) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Seq Scan on invoicepaymentadvice fi_ipa (cost=0.00..10.10 rows=10 width=1,052) (never executed)

77.          

SubPlan (for Nested Loop Left Join)

78. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.15..8.16 rows=1 width=8) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt_4 (cost=0.14..8.15 rows=1 width=8) (never executed)

  • Index Cond: (mapping_id = fi_eps.maturitypaymentmapping_id)
80. 0.210 4.282 ↓ 1.9 86 1

Nested Loop Left Join (cost=3.68..2,828.84 rows=45 width=1,790) (actual time=1.201..4.282 rows=86 loops=1)

  • Join Filter: (fi_si_1.paymentadvice_id = fi_ipa_1.id)
81. 0.095 3.986 ↓ 1.9 86 1

Nested Loop Left Join (cost=3.68..2,444.32 rows=45 width=387) (actual time=1.178..3.986 rows=86 loops=1)

  • Join Filter: (bpt_2.mapping_id = fi_eps_1.earlypaymentmapping_id)
82. 0.060 3.891 ↓ 1.9 86 1

Nested Loop Left Join (cost=3.68..2,427.44 rows=45 width=387) (actual time=1.171..3.891 rows=86 loops=1)

83. 0.106 3.659 ↓ 1.9 86 1

Nested Loop Left Join (cost=3.41..2,414.28 rows=45 width=373) (actual time=1.160..3.659 rows=86 loops=1)

  • Join Filter: (scn_1.currency_id = c_2.id)
84. 0.088 3.553 ↓ 1.9 86 1

Nested Loop Left Join (cost=3.41..2,409.67 rows=45 width=377) (actual time=1.146..3.553 rows=86 loops=1)

85. 0.155 3.293 ↓ 1.9 86 1

Nested Loop Left Join (cost=2.98..2,042.47 rows=45 width=377) (actual time=1.134..3.293 rows=86 loops=1)

86. 0.337 3.052 ↓ 1.9 86 1

Nested Loop Left Join (cost=2.70..2,013.65 rows=45 width=367) (actual time=1.123..3.052 rows=86 loops=1)

  • Join Filter: (fi_si_1.originatordivision_id = od_db_2.id)
  • Rows Removed by Join Filter: 1118
87. 0.105 2.371 ↓ 1.9 86 1

Nested Loop Left Join (cost=2.42..1,914.89 rows=45 width=345) (actual time=1.046..2.371 rows=86 loops=1)

88. 0.110 2.266 ↓ 1.9 86 1

Nested Loop (cost=1.99..1,537.51 rows=45 width=315) (actual time=1.040..2.266 rows=86 loops=1)

89. 0.074 2.022 ↓ 16.8 67 1

Nested Loop Left Join (cost=1.71..1,529.81 rows=4 width=172) (actual time=1.025..2.022 rows=67 loops=1)

90. 0.103 1.814 ↓ 16.8 67 1

Nested Loop (cost=1.29..1,527.95 rows=4 width=56) (actual time=1.014..1.814 rows=67 loops=1)

  • Join Filter: (nb.surplus_id = fi_si_1.id)
91. 0.227 1.577 ↓ 16.8 67 1

Nested Loop (cost=0.86..1,525.34 rows=4 width=56) (actual time=1.001..1.577 rows=67 loops=1)

  • Join Filter: (fi_ps_apfeps_1.apfda_id = fi_ps_apfeps_t_apfda.id)
  • Rows Removed by Join Filter: 525
92. 0.182 1.178 ↓ 9.1 172 1

Nested Loop (cost=0.86..1,522.97 rows=19 width=64) (actual time=0.033..1.178 rows=172 loops=1)

93. 0.258 0.652 ↓ 1.2 172 1

Nested Loop (cost=0.43..1,457.55 rows=146 width=56) (actual time=0.022..0.652 rows=172 loops=1)

94. 0.050 0.050 ↑ 1.0 172 1

Seq Scan on nettingbundle nb (cost=0.00..3.72 rows=172 width=16) (actual time=0.003..0.050 rows=172 loops=1)

95. 0.344 0.344 ↑ 1.0 1 172

Index Scan using earlypaymentsettlement_invoice_idx on earlypaymentsettlement fi_eps_1 (cost=0.43..8.45 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=172)

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

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

  • Index Cond: (id = fi_eps_1.id)
97. 0.166 0.172 ↑ 1.3 3 172

Materialize (cost=0.00..1.27 rows=4 width=8) (actual time=0.000..0.001 rows=3 loops=172)

98. 0.006 0.006 ↑ 1.0 4 1

Seq Scan on apfdebtoragreement fi_ps_apfeps_t_apfda (cost=0.00..1.25 rows=4 width=8) (actual time=0.004..0.006 rows=4 loops=1)

  • Filter: (buyer_id = 67002626)
  • Rows Removed by Filter: 16
99. 0.134 0.134 ↑ 1.0 1 67

Index Scan using supplierinvoice_pkey on supplierinvoice fi_si_1 (cost=0.43..0.64 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=67)

  • Index Cond: (id = fi_eps_1.invoice_id)
100. 0.134 0.134 ↑ 1.0 1 67

Index Scan using apffinancingcontext_pkey on apffinancingcontext fi_ps_apffc_fc_afc_1 (cost=0.42..0.46 rows=1 width=132) (actual time=0.002..0.002 rows=1 loops=67)

  • Index Cond: (id = fi_ps_apfeps_1.financingcontext_id)
101. 0.134 0.134 ↑ 4.0 1 67

Index Scan using suppliercreditnote_nettingbundle_idx on suppliercreditnote scn_1 (cost=0.28..1.88 rows=4 width=151) (actual time=0.002..0.002 rows=1 loops=67)

  • Index Cond: (nettingbundle_id = nb.id)
102. 0.000 0.000 ↓ 0.0 0 86

Index Scan using supplierinvoice_pkey on supplierinvoice ref_si (cost=0.43..8.21 rows=1 width=38) (actual time=0.000..0.000 rows=0 loops=86)

  • Index Cond: (id = scn_1.referencedinvoice_id)
103. 0.283 0.344 ↑ 1.0 14 86

Materialize (cost=0.28..89.35 rows=14 width=38) (actual time=0.000..0.004 rows=14 loops=86)

104. 0.027 0.061 ↑ 1.0 14 1

Nested Loop Left Join (cost=0.28..89.28 rows=14 width=38) (actual time=0.014..0.061 rows=14 loops=1)

105. 0.006 0.006 ↑ 1.0 14 1

Seq Scan on divisionbase od_db_2 (cost=0.00..1.14 rows=14 width=28) (actual time=0.003..0.006 rows=14 loops=1)

106. 0.028 0.028 ↑ 1.0 1 14

Index Scan using corporatebase_pkey on corporatebase od_c_cb_2 (cost=0.28..6.29 rows=1 width=26) (actual time=0.002..0.002 rows=1 loops=14)

  • Index Cond: (id = od_db_2.buyer_id)
107. 0.086 0.086 ↑ 1.0 1 86

Index Scan using corporatebase_pkey on corporatebase s_cb_2 (cost=0.28..0.64 rows=1 width=26) (actual time=0.001..0.001 rows=1 loops=86)

  • Index Cond: (id = scn_1.supplier_id)
108. 0.172 0.172 ↑ 1.0 1 86

Index Scan using arpimportbatch_pkey on arpimportbatch ib_2 (cost=0.43..8.16 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=86)

  • Index Cond: (scn_1.importbatch_id = id)
109. 0.000 0.000 ↑ 6.0 1 86

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

110. 0.004 0.004 ↑ 6.0 1 1

Seq Scan on crxcurrency c_2 (cost=0.00..1.06 rows=6 width=12) (actual time=0.003..0.004 rows=1 loops=1)

111. 0.172 0.172 ↑ 1.0 1 86

Index Scan using earlypaymentadvice_pkey on earlypaymentadvice fi_eps_epa_1 (cost=0.28..0.29 rows=1 width=30) (actual time=0.002..0.002 rows=1 loops=86)

  • Index Cond: (id = fi_eps_1.earlypaymentadvice_id)
112. 0.000 0.000 ↓ 0.0 0 86

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

113. 0.002 0.002 ↓ 0.0 0 1

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

114. 0.000 0.000 ↓ 0.0 0 86

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

115. 0.002 0.002 ↓ 0.0 0 1

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

116.          

SubPlan (for Nested Loop Left Join)

117. 0.086 0.086 ↑ 1.0 1 86

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

118. 0.000 0.000 ↓ 0.0 0 86

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

  • Index Cond: (mapping_id = fi_eps_1.maturitypaymentmapping_id)
119. 13.479 17.520 ↑ 380.1 402 1

Gather (cost=3,008.77..1,286,915.04 rows=152,787 width=1,824) (actual time=11.905..17.520 rows=402 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
120. 0.064 3.639 ↑ 477.5 80 5 / 5

Hash Left Join (cost=2,008.77..21,984.58 rows=38,197 width=1,433) (actual time=2.884..3.639 rows=80 loops=5)

  • Hash Cond: (fi_eps_2.earlypaymentmapping_id = fi_bpt.mapping_id)
121. 0.061 3.573 ↑ 477.5 80 5 / 5

Hash Left Join (cost=1,998.55..21,831.11 rows=38,197 width=1,433) (actual time=2.875..3.573 rows=80 loops=5)

  • Hash Cond: (fi_si_2.paymentadvice_id = fi_ipa_2.id)
122. 0.067 3.510 ↑ 477.5 80 5 / 5

Hash Left Join (cost=1,988.32..21,720.62 rows=38,197 width=389) (actual time=2.868..3.510 rows=80 loops=5)

  • Hash Cond: (fi_eps_2.earlypaymentadvice_id = fi_eps_epa_2.id)
123. 0.080 3.173 ↑ 477.5 80 5 / 5

Nested Loop Left Join (cost=1,956.06..21,588.09 rows=38,197 width=375) (actual time=2.592..3.173 rows=80 loops=5)

124. 0.062 2.932 ↑ 477.5 80 5 / 5

Hash Left Join (cost=1,955.63..2,584.80 rows=38,197 width=375) (actual time=2.587..2.932 rows=80 loops=5)

  • Hash Cond: (si_1.currency_id = c_3.id)
125. 0.063 2.865 ↑ 477.5 80 5 / 5

Hash Left Join (cost=1,954.49..2,412.57 rows=38,197 width=379) (actual time=2.577..2.865 rows=80 loops=5)

  • Hash Cond: (si_1.supplier_id = s_cb_3.id)
126. 0.076 2.233 ↑ 477.5 80 5 / 5

Hash Left Join (cost=1,743.37..2,100.93 rows=38,197 width=369) (actual time=2.002..2.233 rows=80 loops=5)

  • Hash Cond: (od_db_3.buyer_id = od_c_cb_3.id)
127. 0.259 1.538 ↑ 477.5 80 5 / 5

Merge Join (cost=1,532.24..1,789.28 rows=38,197 width=359) (actual time=1.365..1.538 rows=80 loops=5)

  • Merge Cond: (si_1.nettingbundle_id = nb_1.id)
128. 0.221 0.221 ↑ 3,116.6 527 5 / 5

Parallel Index Scan using supplierinvoice_nettingbundle_idx on supplierinvoice si_1 (cost=0.43..784,438.39 rows=1,642,460 width=183) (actual time=0.009..0.221 rows=527 loops=5)

129. 0.049 1.058 ↓ 56.8 227 2 / 5

Sort (cost=1,531.81..1,531.82 rows=4 width=184) (actual time=2.580..2.644 rows=227 loops=2)

  • Sort Key: nb_1.id
  • Sort Method: quicksort Memory: 34kB
  • Worker 3: Sort Method: quicksort Memory: 34kB
130. 0.026 1.009 ↓ 16.8 67 2 / 5

Nested Loop Left Join (cost=1.71..1,531.77 rows=4 width=184) (actual time=1.109..2.522 rows=67 loops=2)

131. 0.126 0.929 ↓ 16.8 67 2 / 5

Nested Loop Left Join (cost=1.29..1,529.91 rows=4 width=68) (actual time=1.096..2.322 rows=67 loops=2)

  • Join Filter: (fi_si_2.originatordivision_id = od_db_3.id)
  • Rows Removed by Join Filter: 871
132. 0.032 0.722 ↓ 16.8 67 2 / 5

Nested Loop (cost=1.29..1,527.90 rows=4 width=56) (actual time=1.065..1.805 rows=67 loops=2)

133. 0.102 0.636 ↓ 16.8 67 2 / 5

Nested Loop (cost=0.86..1,525.34 rows=4 width=56) (actual time=1.054..1.590 rows=67 loops=2)

  • Join Filter: (fi_ps_apfeps_2.apfda_id = fi_ps_apfeps_t_apfda_1.id)
  • Rows Removed by Join Filter: 525
134. 0.073 0.466 ↓ 9.1 172 2 / 5

Nested Loop (cost=0.86..1,522.97 rows=19 width=64) (actual time=0.030..1.164 rows=172 loops=2)

135. 0.097 0.255 ↓ 1.2 172 2 / 5

Nested Loop (cost=0.43..1,457.55 rows=146 width=56) (actual time=0.020..0.637 rows=172 loops=2)

136. 0.020 0.020 ↑ 1.0 172 2 / 5

Seq Scan on nettingbundle nb_1 (cost=0.00..3.72 rows=172 width=16) (actual time=0.007..0.051 rows=172 loops=2)

137. 0.138 0.138 ↑ 1.0 1 344 / 5

Index Scan using earlypaymentsettlement_invoice_idx on earlypaymentsettlement fi_eps_2 (cost=0.43..8.45 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=344)

  • Index Cond: (invoice_id = nb_1.surplus_id)
  • Filter: (creationdate >= '2019-01-01'::date)
138. 0.138 0.138 ↑ 1.0 1 344 / 5

Index Scan using apfearlypaymentsettlement_pkey on apfearlypaymentsettlement fi_ps_apfeps_2 (cost=0.42..0.45 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=344)

  • Index Cond: (id = fi_eps_2.id)
139. 0.066 0.069 ↑ 1.3 3 344 / 5

Materialize (cost=0.00..1.27 rows=4 width=8) (actual time=0.000..0.001 rows=3 loops=344)

140. 0.003 0.003 ↑ 1.0 4 2 / 5

Seq Scan on apfdebtoragreement fi_ps_apfeps_t_apfda_1 (cost=0.00..1.25 rows=4 width=8) (actual time=0.006..0.007 rows=4 loops=2)

  • Filter: (buyer_id = 67002626)
  • Rows Removed by Filter: 16
141. 0.054 0.054 ↑ 1.0 1 134 / 5

Index Scan using supplierinvoice_pkey on supplierinvoice fi_si_2 (cost=0.43..0.64 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=134)

  • Index Cond: (id = fi_eps_2.invoice_id)
142. 0.076 0.080 ↑ 1.0 14 134 / 5

Materialize (cost=0.00..1.21 rows=14 width=28) (actual time=0.000..0.003 rows=14 loops=134)

143. 0.005 0.005 ↑ 1.0 14 2 / 5

Seq Scan on divisionbase od_db_3 (cost=0.00..1.14 rows=14 width=28) (actual time=0.005..0.012 rows=14 loops=2)

144. 0.054 0.054 ↑ 1.0 1 134 / 5

Index Scan using apffinancingcontext_pkey on apffinancingcontext fi_ps_apffc_fc_afc_2 (cost=0.42..0.46 rows=1 width=132) (actual time=0.002..0.002 rows=1 loops=134)

  • Index Cond: (fi_ps_apfeps_2.financingcontext_id = id)
145. 0.241 0.619 ↑ 1.0 1,650 2 / 5

Hash (cost=190.50..190.50 rows=1,650 width=26) (actual time=1.547..1.547 rows=1,650 loops=2)

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
146. 0.378 0.378 ↑ 1.0 1,650 2 / 5

Seq Scan on corporatebase od_c_cb_3 (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.006..0.944 rows=1,650 loops=2)

147. 0.255 0.569 ↑ 1.0 1,650 2 / 5

Hash (cost=190.50..190.50 rows=1,650 width=26) (actual time=1.422..1.423 rows=1,650 loops=2)

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
148. 0.314 0.314 ↑ 1.0 1,650 2 / 5

Seq Scan on corporatebase s_cb_3 (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.002..0.785 rows=1,650 loops=2)

149. 0.002 0.005 ↑ 1.0 6 2 / 5

Hash (cost=1.06..1.06 rows=6 width=12) (actual time=0.012..0.012 rows=6 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
150. 0.003 0.003 ↑ 1.0 6 2 / 5

Seq Scan on crxcurrency c_3 (cost=0.00..1.06 rows=6 width=12) (actual time=0.005..0.007 rows=6 loops=2)

151. 0.161 0.161 ↑ 1.0 1 402 / 5

Index Scan using arpimportbatch_pkey on arpimportbatch ib_3 (cost=0.43..0.50 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=402)

  • Index Cond: (si_1.importbatch_id = id)
152. 0.141 0.270 ↑ 1.0 945 2 / 5

Hash (cost=20.45..20.45 rows=945 width=30) (actual time=0.674..0.674 rows=945 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
153. 0.129 0.129 ↑ 1.0 945 2 / 5

Seq Scan on earlypaymentadvice fi_eps_epa_2 (cost=0.00..20.45 rows=945 width=30) (actual time=0.005..0.322 rows=945 loops=2)

154. 0.000 0.002 ↓ 0.0 0 2 / 5

Hash (cost=10.10..10.10 rows=10 width=1,052) (actual time=0.004..0.004 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
155. 0.001 0.001 ↓ 0.0 0 2 / 5

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

156. 0.000 0.002 ↓ 0.0 0 2 / 5

Hash (cost=10.10..10.10 rows=10 width=16) (actual time=0.003..0.004 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
157. 0.001 0.001 ↓ 0.0 0 2 / 5

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

158.          

SubPlan (for Gather)

159. 0.402 0.402 ↑ 1.0 1 402

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

160. 0.000 0.000 ↓ 0.0 0 402

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

  • Index Cond: (mapping_id = fi_eps_2.maturitypaymentmapping_id)
161. 0.181 4.466 ↓ 16.8 67 1

Nested Loop Left Join (cost=3.95..1,630.91 rows=4 width=1,758) (actual time=1.144..4.466 rows=67 loops=1)

  • Join Filter: (fi_bpt_1.mapping_id = fi_eps_3.earlypaymentmapping_id)
162. 0.090 4.218 ↓ 16.8 67 1

Nested Loop Left Join (cost=3.95..1,587.50 rows=4 width=1,655) (actual time=1.120..4.218 rows=67 loops=1)

  • Join Filter: (fi_si_3.paymentadvice_id = fi_ipa_3.id)
163. 0.082 4.128 ↓ 16.8 67 1

Nested Loop Left Join (cost=3.95..1,576.77 rows=4 width=611) (actual time=1.112..4.128 rows=67 loops=1)

164. 0.106 3.912 ↓ 16.8 67 1

Nested Loop Left Join (cost=3.68..1,575.60 rows=4 width=597) (actual time=1.095..3.912 rows=67 loops=1)

165. 0.090 3.672 ↓ 16.8 67 1

Nested Loop Left Join (cost=3.25..1,573.61 rows=4 width=597) (actual time=1.084..3.672 rows=67 loops=1)

  • Join Filter: (fi_si_3.currency_id = c_4.id)
166. 0.131 3.582 ↓ 16.8 67 1

Nested Loop Left Join (cost=3.25..1,572.24 rows=4 width=601) (actual time=1.075..3.582 rows=67 loops=1)

167. 0.068 3.384 ↓ 16.8 67 1

Nested Loop Left Join (cost=2.97..1,571.06 rows=4 width=591) (actual time=1.063..3.384 rows=67 loops=1)

168. 0.109 3.182 ↓ 16.8 67 1

Nested Loop Left Join (cost=2.69..1,545.87 rows=4 width=581) (actual time=1.051..3.182 rows=67 loops=1)

169. 0.062 2.939 ↓ 16.8 67 1

Merge Left Join (cost=2.27..1,544.01 rows=4 width=465) (actual time=1.039..2.939 rows=67 loops=1)

  • Merge Cond: (fi_ps_apfeps_t_apfda_2.bank_id = fi_ps_eps_t_bc_cb.id)
170. 0.116 2.865 ↓ 16.8 67 1

Nested Loop Left Join (cost=1.85..1,542.97 rows=4 width=455) (actual time=1.022..2.865 rows=67 loops=1)

171. 0.279 2.615 ↓ 16.8 67 1

Nested Loop Left Join (cost=1.43..1,541.07 rows=4 width=439) (actual time=1.008..2.615 rows=67 loops=1)

  • Join Filter: (fi_si_3.originatordivision_id = od_db_4.id)
  • Rows Removed by Join Filter: 871
172. 0.141 2.135 ↓ 16.8 67 1

Nested Loop (cost=1.43..1,539.05 rows=4 width=427) (actual time=0.980..2.135 rows=67 loops=1)

173. 0.344 1.860 ↓ 16.8 67 1

Nested Loop (cost=0.99..1,536.49 rows=4 width=244) (actual time=0.968..1.860 rows=67 loops=1)

  • Join Filter: (fi_ps_apfeps_3.apfda_id = fi_ps_apfeps_t_apfda_2.id)
  • Rows Removed by Join Filter: 621
174. 0.012 0.012 ↑ 1.0 4 1

Index Scan using apfdebtoragreement_uq on apfdebtoragreement fi_ps_apfeps_t_apfda_2 (cost=0.14..12.33 rows=4 width=16) (actual time=0.009..0.012 rows=4 loops=1)

  • Index Cond: (buyer_id = 67002626)
175. 0.272 1.504 ↓ 9.1 172 4

Materialize (cost=0.86..1,523.07 rows=19 width=244) (actual time=0.011..0.376 rows=172 loops=4)

176. 0.192 1.232 ↓ 9.1 172 1

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

177. 0.306 0.696 ↓ 1.2 172 1

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

178. 0.046 0.046 ↑ 1.0 172 1

Seq Scan on nettingbundle nb_2 (cost=0.00..3.72 rows=172 width=8) (actual time=0.005..0.046 rows=172 loops=1)

179. 0.344 0.344 ↑ 1.0 1 172

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

  • Index Cond: (invoice_id = nb_2.surplus_id)
  • Filter: (creationdate >= '2019-01-01'::date)
180. 0.344 0.344 ↑ 1.0 1 172

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

  • Index Cond: (id = fi_eps_3.id)
181. 0.134 0.134 ↑ 1.0 1 67

Index Scan using supplierinvoice_pkey on supplierinvoice fi_si_3 (cost=0.43..0.64 rows=1 width=207) (actual time=0.002..0.002 rows=1 loops=67)

  • Index Cond: (id = fi_eps_3.invoice_id)
182. 0.189 0.201 ↑ 1.0 14 67

Materialize (cost=0.00..1.21 rows=14 width=28) (actual time=0.000..0.003 rows=14 loops=67)

183. 0.012 0.012 ↑ 1.0 14 1

Seq Scan on divisionbase od_db_4 (cost=0.00..1.14 rows=14 width=28) (actual time=0.006..0.012 rows=14 loops=1)

184. 0.134 0.134 ↑ 1.0 1 67

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

  • Index Cond: (id = fi_ps_apfeps_3.financingcontext_id)
185. 0.012 0.012 ↑ 330.0 5 1

Index Scan using corporatebase_pkey on corporatebase fi_ps_eps_t_bc_cb (cost=0.28..234.48 rows=1,650 width=26) (actual time=0.010..0.012 rows=5 loops=1)

186. 0.134 0.134 ↑ 1.0 1 67

Index Scan using apffinancingcontext_pkey on apffinancingcontext fi_ps_apffc_fc_afc_3 (cost=0.42..0.46 rows=1 width=132) (actual time=0.002..0.002 rows=1 loops=67)

  • Index Cond: (fi_ps_apfeps_3.financingcontext_id = id)
187. 0.134 0.134 ↑ 1.0 1 67

Index Scan using corporatebase_pkey on corporatebase od_c_cb_4 (cost=0.28..6.29 rows=1 width=26) (actual time=0.002..0.002 rows=1 loops=67)

  • Index Cond: (id = od_db_4.buyer_id)
188. 0.067 0.067 ↑ 1.0 1 67

Index Scan using corporatebase_pkey on corporatebase s_cb_4 (cost=0.28..0.30 rows=1 width=26) (actual time=0.001..0.001 rows=1 loops=67)

  • Index Cond: (id = fi_si_3.supplier_id)
189. 0.000 0.000 ↑ 6.0 1 67

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

190. 0.003 0.003 ↑ 6.0 1 1

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

191. 0.134 0.134 ↑ 1.0 1 67

Index Scan using arpimportbatch_pkey on arpimportbatch ib_4 (cost=0.43..0.50 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=67)

  • Index Cond: (fi_si_3.importbatch_id = id)
192. 0.134 0.134 ↑ 1.0 1 67

Index Scan using earlypaymentadvice_pkey on earlypaymentadvice fi_eps_epa_3 (cost=0.28..0.29 rows=1 width=30) (actual time=0.002..0.002 rows=1 loops=67)

  • Index Cond: (id = fi_eps_3.earlypaymentadvice_id)
193. 0.000 0.000 ↓ 0.0 0 67

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

194. 0.001 0.001 ↓ 0.0 0 1

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

195. 0.000 0.000 ↓ 0.0 0 67

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

196. 0.002 0.002 ↓ 0.0 0 1

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

197.          

SubPlan (for Nested Loop Left Join)

198. 0.067 0.067 ↑ 1.0 1 67

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

199. 0.000 0.000 ↓ 0.0 0 67

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

  • Index Cond: (mapping_id = fi_eps_3.maturitypaymentmapping_id)
Planning time : 47.383 ms
Execution time : 578.660 ms