explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s0BI

Settings
# exclusive inclusive rows x rows loops node
1. 0.180 518.668 ↑ 27.2 10,816 1

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

2. 16.395 491.206 ↑ 13.8 10,261 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 3.137 464.550 ↑ 17.2 3,420 3 / 3

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

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

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

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

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

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

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

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

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

8. 2.986 440.023 ↑ 17.2 3,420 3 / 3

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

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

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

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

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

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

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

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

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

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

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

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

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

15. 20.132 222.884 ↑ 17.1 3,443 3 / 3

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

16. 83.916 149.629 ↑ 2.6 26,562 3 / 3

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

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
17. 65.689 65.689 ↑ 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..65.689 rows=277,103 loops=3)

18. 0.008 0.024 ↑ 1.0 4 3 / 3

Hash (cost=1.25..1.25 rows=4 width=16) (actual time=0.023..0.024 rows=4 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.016 0.016 ↑ 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.014..0.016 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. 59.212 109.646 ↑ 1.3 131,499 3 / 3

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

  • Buckets: 524288 Batches: 1 Memory Usage: 26688kB
23. 50.434 50.434 ↑ 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.007..50.434 rows=131,499 loops=3)

24. 36.625 69.267 ↑ 1.2 79,932 3 / 3

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

  • Buckets: 262144 Batches: 1 Memory Usage: 20832kB
25. 32.642 32.642 ↑ 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..32.642 rows=79,932 loops=3)

26. 0.606 1.511 ↑ 1.0 1,650 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
27. 0.905 0.905 ↑ 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..0.905 rows=1,650 loops=3)

28. 0.010 0.022 ↑ 1.0 14 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.012 0.012 ↑ 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.012 rows=14 loops=3)

30. 0.598 1.323 ↑ 1.0 1,650 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
31. 0.725 0.725 ↑ 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.725 rows=1,650 loops=3)

32. 0.582 1.304 ↑ 1.0 1,650 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
33. 0.722 0.722 ↑ 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.002..0.722 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.006 0.013 ↑ 1.0 6 3 / 3

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

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

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

37. 0.321 0.613 ↑ 1.0 945 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
38. 0.292 0.292 ↑ 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.292 rows=945 loops=3)

39. 0.000 0.004 ↓ 0.0 0 3 / 3

Hash (cost=10.10..10.10 rows=10 width=1,052) (actual time=0.004..0.004 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.003..0.004 rows=0 loops=3)

41. 0.001 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.003 0.003 ↓ 0.0 0 3 / 3

Seq Scan on bankpaymenttransaction bpt (cost=0.00..10.10 rows=10 width=16) (actual time=0.003..0.003 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.001 2.072 ↓ 0.0 0 1

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

50. 0.001 2.071 ↓ 0.0 0 1

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

  • Join Filter: (scn.currency_id = c_1.id)
51. 0.000 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.070 ↓ 0.0 0 1

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

53. 0.001 2.069 ↓ 0.0 0 1

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

  • Join Filter: (fi_si.originatordivision_id = od_db_1.id)
54. 0.000 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.001 2.068 ↓ 0.0 0 1

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

56. 0.000 2.067 ↓ 0.0 0 1

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

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

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

58. 1.575 2.066 ↓ 0.0 0 1

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

59. 0.491 0.491 ↑ 1.0 2,096 1

Seq Scan on suppliercreditnote scn (cost=0.00..78.96 rows=2,096 width=151) (actual time=0.004..0.491 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.208 4.198 ↓ 1.9 86 1

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

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

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

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

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

83. 0.097 3.577 ↓ 1.9 86 1

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

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

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

85. 0.155 3.216 ↓ 1.9 86 1

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

86. 0.323 2.975 ↓ 1.9 86 1

Nested Loop Left Join (cost=2.70..2,013.65 rows=45 width=367) (actual time=1.054..2.975 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.308 ↓ 1.9 86 1

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

88. 0.110 2.203 ↓ 1.9 86 1

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

89. 0.087 1.959 ↓ 16.8 67 1

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

90. 0.090 1.738 ↓ 16.8 67 1

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

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

Nested Loop (cost=0.86..1,525.34 rows=4 width=56) (actual time=0.951..1.514 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.167 1.143 ↓ 9.1 172 1

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

93. 0.242 0.632 ↓ 1.2 172 1

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

94. 0.046 0.046 ↑ 1.0 172 1

Seq Scan on nettingbundle nb (cost=0.00..3.72 rows=172 width=16) (actual time=0.003..0.046 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.005..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.287 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.023 0.057 ↑ 1.0 14 1

Nested Loop Left Join (cost=0.28..89.28 rows=14 width=38) (actual time=0.011..0.057 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.003 0.003 ↑ 6.0 1 1

Seq Scan on crxcurrency c_2 (cost=0.00..1.06 rows=6 width=12) (actual time=0.003..0.003 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.002..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.094 16.834 ↑ 380.1 402 1

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

  • Workers Planned: 4
  • Workers Launched: 4
120. 0.056 3.338 ↑ 477.5 80 5 / 5

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

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

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

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

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

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

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

124. 0.056 2.697 ↑ 477.5 80 5 / 5

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

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

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

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

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

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

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

  • Merge Cond: (si_1.nettingbundle_id = nb_1.id)
128. 0.212 0.212 ↑ 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.212 rows=527 loops=5)

129. 0.042 0.956 ↓ 56.8 227 2 / 5

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

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

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

131. 0.107 0.840 ↓ 16.8 67 2 / 5

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

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

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

133. 0.088 0.572 ↓ 16.8 67 2 / 5

Nested Loop (cost=0.86..1,525.34 rows=4 width=56) (actual time=0.925..1.429 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.048 0.414 ↓ 9.1 172 2 / 5

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

135. 0.072 0.229 ↓ 1.2 172 2 / 5

Nested Loop (cost=0.43..1,457.55 rows=146 width=56) (actual time=0.017..0.573 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.049 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.005..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.077 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.004 0.004 ↑ 1.0 14 2 / 5

Seq Scan on divisionbase od_db_3 (cost=0.00..1.14 rows=14 width=28) (actual time=0.004..0.009 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.218 0.577 ↑ 1.0 1,650 2 / 5

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
146. 0.359 0.359 ↑ 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.897 rows=1,650 loops=2)

147. 0.222 0.510 ↑ 1.0 1,650 2 / 5

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
148. 0.288 0.288 ↑ 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.719 rows=1,650 loops=2)

149. 0.002 0.004 ↑ 1.0 6 2 / 5

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

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

Seq Scan on crxcurrency c_3 (cost=0.00..1.06 rows=6 width=12) (actual time=0.004..0.006 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.126 0.240 ↑ 1.0 945 2 / 5

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

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
153. 0.114 0.114 ↑ 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.285 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.001 ↓ 0.0 0 2 / 5

Hash (cost=10.10..10.10 rows=10 width=16) (actual time=0.003..0.003 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.002..0.002 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.173 4.176 ↓ 16.8 67 1

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

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

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

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

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

164. 0.087 3.650 ↓ 16.8 67 1

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

165. 0.096 3.429 ↓ 16.8 67 1

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

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

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

167. 0.122 3.146 ↓ 16.8 67 1

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

168. 0.095 2.957 ↓ 16.8 67 1

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

169. 0.062 2.728 ↓ 16.8 67 1

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

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

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

171. 0.265 2.423 ↓ 16.8 67 1

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

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

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

173. 0.278 1.691 ↓ 16.8 67 1

Nested Loop (cost=0.99..1,536.49 rows=4 width=244) (actual time=0.883..1.691 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.009 0.009 ↑ 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.007..0.009 rows=4 loops=1)

  • Index Cond: (buyer_id = 67002626)
175. 0.261 1.404 ↓ 9.1 172 4

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

176. 0.162 1.143 ↓ 9.1 172 1

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

177. 0.248 0.637 ↓ 1.2 172 1

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

178. 0.045 0.045 ↑ 1.0 172 1

Seq Scan on nettingbundle nb_2 (cost=0.00..3.72 rows=172 width=8) (actual time=0.004..0.045 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.192 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.009 0.009 ↑ 1.0 14 1

Seq Scan on divisionbase od_db_4 (cost=0.00..1.14 rows=14 width=28) (actual time=0.003..0.009 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.011 0.011 ↑ 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.011 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.067 0.067 ↑ 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.001..0.001 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.002 0.002 ↑ 6.0 1 1

Seq Scan on crxcurrency c_4 (cost=0.00..1.06 rows=6 width=12) (actual time=0.002..0.002 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.002 0.002 ↓ 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.002 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.001 0.001 ↓ 0.0 0 1

Seq Scan on bankpaymenttransaction fi_bpt_1 (cost=0.00..10.10 rows=10 width=16) (actual time=0.001..0.001 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 : 46.106 ms
Execution time : 527.357 ms