explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vgwn

Settings
# exclusive inclusive rows x rows loops node
1. 0.465 575.661 ↑ 27.4 10,749 1

Append (cost=18,679.63..2,698,495.28 rows=294,139 width=1,792) (actual time=367.655..575.661 rows=10,749 loops=1)

2. 16.433 546.998 ↑ 13.8 10,261 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 3.294 520.304 ↑ 17.2 3,420 3 / 3

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

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

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

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

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

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

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

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

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

8. 3.122 494.918 ↑ 17.2 3,420 3 / 3

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

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

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

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

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

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

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

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

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

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

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

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

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

15. 23.171 251.685 ↑ 17.1 3,443 3 / 3

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

16. 96.494 175.391 ↑ 2.6 26,562 3 / 3

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

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
17. 78.873 78.873 ↑ 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..78.873 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.024..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. 67.362 124.714 ↑ 1.3 131,499 3 / 3

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

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

24. 41.862 79.164 ↑ 1.2 79,932 3 / 3

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

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

26. 0.682 1.698 ↑ 1.0 1,650 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
27. 1.016 1.016 ↑ 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.018..1.016 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.023..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.665 1.481 ↑ 1.0 1,650 3 / 3

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

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

32. 0.660 1.464 ↑ 1.0 1,650 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
33. 0.804 0.804 ↑ 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.804 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.005..0.008 rows=6 loops=3)

37. 0.366 0.701 ↑ 1.0 945 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
38. 0.335 0.335 ↑ 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.335 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.001 0.005 ↓ 0.0 0 3 / 3

Hash (cost=10.10..10.10 rows=10 width=16) (actual time=0.004..0.005 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.088 ↓ 0.0 0 1

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

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

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

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

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

49. 0.001 2.086 ↓ 0.0 0 1

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

50. 0.000 2.085 ↓ 0.0 0 1

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

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

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

52. 0.001 2.084 ↓ 0.0 0 1

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

53. 0.000 2.083 ↓ 0.0 0 1

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

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

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

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

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

56. 0.001 2.082 ↓ 0.0 0 1

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

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

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

58. 1.586 2.080 ↓ 0.0 0 1

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

59. 0.494 0.494 ↑ 1.0 2,096 1

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

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

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

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

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

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

83. 0.101 3.680 ↓ 1.9 86 1

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

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

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

85. 0.081 3.298 ↓ 1.9 86 1

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

86. 0.334 3.045 ↓ 1.9 86 1

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

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

88. 0.126 2.262 ↓ 1.9 86 1

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

89. 0.083 2.002 ↓ 16.8 67 1

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

90. 0.107 1.785 ↓ 16.8 67 1

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

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

Nested Loop (cost=0.86..1,525.34 rows=4 width=56) (actual time=0.959..1.544 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.177 1.170 ↓ 9.1 172 1

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

93. 0.258 0.649 ↓ 1.2 172 1

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

94. 0.047 0.047 ↑ 1.0 172 1

Seq Scan on nettingbundle nb (cost=0.00..3.72 rows=172 width=16) (actual time=0.004..0.047 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.285 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.025 0.059 ↑ 1.0 14 1

Nested Loop Left Join (cost=0.28..89.28 rows=14 width=38) (actual time=0.013..0.059 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.172 0.172 ↑ 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.002..0.002 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.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.002..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.444 17.235 ↑ 456.1 335 1

Gather (cost=3,008.77..1,286,915.07 rows=152,787 width=1,824) (actual time=11.563..17.235 rows=335 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
120. 0.052 3.456 ↑ 570.1 67 5 / 5

Hash Left Join (cost=2,008.77..21,984.61 rows=38,197 width=1,433) (actual time=2.812..3.456 rows=67 loops=5)

  • Hash Cond: (fi_eps_2.earlypaymentmapping_id = fi_bpt.mapping_id)
121. 0.051 3.402 ↑ 570.1 67 5 / 5

Hash Left Join (cost=1,998.55..21,831.14 rows=38,197 width=1,433) (actual time=2.806..3.402 rows=67 loops=5)

  • Hash Cond: (fi_si_2.paymentadvice_id = fi_ipa_2.id)
122. 0.054 3.349 ↑ 570.1 67 5 / 5

Hash Left Join (cost=1,988.32..21,720.65 rows=38,197 width=389) (actual time=2.799..3.349 rows=67 loops=5)

  • Hash Cond: (fi_eps_2.earlypaymentadvice_id = fi_eps_epa_2.id)
123. 0.064 3.049 ↑ 570.1 67 5 / 5

Nested Loop Left Join (cost=1,956.06..21,588.12 rows=38,197 width=375) (actual time=2.548..3.049 rows=67 loops=5)

124. 0.051 2.851 ↑ 570.1 67 5 / 5

Hash Left Join (cost=1,955.63..2,584.83 rows=38,197 width=375) (actual time=2.543..2.851 rows=67 loops=5)

  • Hash Cond: (si_1.currency_id = c_3.id)
125. 0.051 2.796 ↑ 570.1 67 5 / 5

Hash Left Join (cost=1,954.49..2,412.60 rows=38,197 width=379) (actual time=2.534..2.796 rows=67 loops=5)

  • Hash Cond: (si_1.supplier_id = s_cb_3.id)
126. 0.064 2.207 ↑ 570.1 67 5 / 5

Hash Left Join (cost=1,743.37..2,100.96 rows=38,197 width=369) (actual time=1.991..2.207 rows=67 loops=5)

  • Hash Cond: (od_db_3.buyer_id = od_c_cb_3.id)
127. 0.254 1.517 ↑ 570.1 67 5 / 5

Merge Join (cost=1,532.24..1,789.31 rows=38,197 width=359) (actual time=1.348..1.517 rows=67 loops=5)

  • Merge Cond: (si_1.nettingbundle_id = nb_1.id)
  • Join Filter: (si_1.id <> nb_1.surplus_id)
  • Rows Removed by Join Filter: 13
128. 0.222 0.222 ↑ 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=191) (actual time=0.009..0.222 rows=527 loops=5)

129. 0.048 1.041 ↓ 56.8 227 2 / 5

Sort (cost=1,531.81..1,531.82 rows=4 width=192) (actual time=2.539..2.602 rows=227 loops=2)

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

Nested Loop Left Join (cost=1.71..1,531.77 rows=4 width=192) (actual time=1.088..2.482 rows=67 loops=2)

131. 0.122 0.916 ↓ 16.8 67 2 / 5

Nested Loop Left Join (cost=1.29..1,529.91 rows=4 width=76) (actual time=1.078..2.289 rows=67 loops=2)

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

Nested Loop (cost=1.29..1,527.90 rows=4 width=64) (actual time=1.050..1.782 rows=67 loops=2)

133. 0.102 0.626 ↓ 16.8 67 2 / 5

Nested Loop (cost=0.86..1,525.34 rows=4 width=56) (actual time=1.040..1.564 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.068 0.455 ↓ 9.1 172 2 / 5

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

135. 0.092 0.250 ↓ 1.2 172 2 / 5

Nested Loop (cost=0.43..1,457.55 rows=146 width=56) (actual time=0.017..0.624 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.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.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.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.011 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.242 0.626 ↑ 1.0 1,650 2 / 5

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

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

147. 0.234 0.538 ↑ 1.0 1,650 2 / 5

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
148. 0.305 0.305 ↑ 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.762 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.011..0.011 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.134 0.134 ↑ 1.0 1 335 / 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=335)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
153. 0.121 0.121 ↑ 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.303 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.003..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.335 0.335 ↑ 1.0 1 335

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

160. 0.000 0.000 ↓ 0.0 0 335

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=335)

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

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

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

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

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

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

164. 0.109 3.995 ↓ 16.8 67 1

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

165. 0.096 3.752 ↓ 16.8 67 1

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

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

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

167. 0.068 3.461 ↓ 16.8 67 1

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

168. 0.127 3.259 ↓ 16.8 67 1

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

169. 0.064 2.998 ↓ 16.8 67 1

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

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

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

171. 0.272 2.667 ↓ 16.8 67 1

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

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

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

173. 0.367 1.912 ↓ 16.8 67 1

Nested Loop (cost=0.99..1,536.49 rows=4 width=244) (actual time=0.972..1.912 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.013 0.013 ↑ 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.010..0.013 rows=4 loops=1)

  • Index Cond: (buyer_id = 67002626)
175. 0.265 1.532 ↓ 9.1 172 4

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

176. 0.207 1.267 ↓ 9.1 172 1

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

177. 0.326 0.716 ↓ 1.2 172 1

Nested Loop (cost=0.43..1,457.55 rows=146 width=228) (actual time=0.020..0.716 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.004..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.201 0.201 ↑ 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.003..0.003 rows=1 loops=67)

  • Index Cond: (id = fi_eps_3.invoice_id)
182. 0.191 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.010 0.010 ↑ 1.0 14 1

Seq Scan on divisionbase od_db_4 (cost=0.00..1.14 rows=14 width=28) (actual time=0.004..0.010 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.009..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.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.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.002..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.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 : 48.087 ms
Execution time : 584.719 ms