explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VBmu

Settings
# exclusive inclusive rows x rows loops node
1. 0.521 689.162 ↑ 29.8 1,330 1

Append (cost=1,498.45..437,275.28 rows=39,617 width=1,822) (actual time=32.981..689.162 rows=1,330 loops=1)

2. 3.713 666.236 ↑ 1.1 1,271 1

Nested Loop Left Join (cost=1,498.45..92,137.29 rows=1,417 width=1,758) (actual time=32.980..666.236 rows=1,271 loops=1)

3. 6.956 661.252 ↑ 1.1 1,271 1

Gather (cost=1,498.18..80,142.37 rows=1,417 width=1,641) (actual time=32.950..661.252 rows=1,271 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
4. 0.322 654.296 ↑ 1.4 318 4 / 4

Hash Left Join (cost=498.18..79,000.67 rows=457 width=1,641) (actual time=22.881..654.296 rows=318 loops=4)

  • Hash Cond: (ps_eps.earlypaymentmapping_id = bpt.mapping_id)
5. 0.309 653.971 ↑ 1.4 318 4 / 4

Hash Left Join (cost=487.95..78,988.72 rows=457 width=1,641) (actual time=22.862..653.971 rows=318 loops=4)

  • Hash Cond: (si.paymentadvice_id = ipa.id)
6. 0.319 653.658 ↑ 1.4 318 4 / 4

Hash Left Join (cost=477.73..78,977.30 rows=457 width=597) (actual time=22.843..653.658 rows=318 loops=4)

  • Hash Cond: (si.currency_id = c.id)
7. 0.340 653.321 ↑ 1.4 318 4 / 4

Nested Loop Left Join (cost=476.59..78,974.12 rows=457 width=601) (actual time=22.807..653.321 rows=318 loops=4)

8. 0.317 648.215 ↑ 1.4 318 4 / 4

Hash Left Join (cost=476.16..75,787.73 rows=457 width=601) (actual time=21.869..648.215 rows=318 loops=4)

  • Hash Cond: (si.supplier_id = s_cb.id)
9. 0.309 647.872 ↑ 1.4 318 4 / 4

Hash Left Join (cost=467.85..75,773.14 rows=457 width=591) (actual time=21.827..647.872 rows=318 loops=4)

  • Hash Cond: (od_db.buyer_id = od_c_cb.id)
10. 0.318 645.845 ↑ 1.4 318 4 / 4

Hash Left Join (cost=256.73..75,560.81 rows=457 width=581) (actual time=20.093..645.845 rows=318 loops=4)

  • Hash Cond: (si.originatordivision_id = od_db.id)
11. 0.532 645.504 ↑ 1.4 318 4 / 4

Nested Loop Left Join (cost=255.41..75,557.93 rows=457 width=569) (actual time=20.053..645.504 rows=318 loops=4)

12. 0.539 644.337 ↑ 1.4 318 4 / 4

Nested Loop Left Join (cost=254.99..75,332.24 rows=457 width=453) (actual time=20.040..644.337 rows=318 loops=4)

13. 0.388 643.162 ↑ 1.4 318 4 / 4

Hash Left Join (cost=254.57..75,115.26 rows=457 width=437) (actual time=20.024..643.162 rows=318 loops=4)

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
14. 0.493 642.676 ↑ 1.4 318 4 / 4

Nested Loop (cost=251.39..75,105.80 rows=457 width=427) (actual time=19.853..642.676 rows=318 loops=4)

15. 2.143 635.828 ↑ 11.0 318 4 / 4

Nested Loop (cost=250.96..73,535.68 rows=3,504 width=411) (actual time=19.833..635.828 rows=318 loops=4)

16. 17.998 19.171 ↑ 1.3 3,340 4 / 4

Parallel Bitmap Heap Scan on supplierinvoice si (cost=250.53..42,721.90 rows=4,248 width=207) (actual time=6.182..19.171 rows=3,340 loops=4)

  • Recheck Cond: (supplier_id = 6167)
  • Filter: (nettingbundle_id IS NULL)
  • Rows Removed by Filter: 12
  • Heap Blocks: exact=271
17. 1.172 1.172 ↓ 1.0 13,406 1 / 4

Bitmap Index Scan on supplierinvoice_supplier_idx (cost=0.00..247.24 rows=13,174 width=0) (actual time=4.689..4.690 rows=13,406 loops=1)

  • Index Cond: (supplier_id = 6167)
18. 614.514 614.514 ↓ 0.0 0 13,359 / 4

Index Scan using earlypaymentsettlement_invoice_idx on earlypaymentsettlement ps_eps (cost=0.43..7.25 rows=1 width=220) (actual time=0.184..0.184 rows=0 loops=13,359)

  • Index Cond: (invoice_id = si.id)
  • Filter: (creationdate >= '2019-01-01'::date)
  • Rows Removed by Filter: 1
19. 6.355 6.355 ↑ 1.0 1 1,271 / 4

Index Scan using apfearlypaymentsettlement_pkey on apfearlypaymentsettlement ps_apfeps (cost=0.42..0.45 rows=1 width=24) (actual time=0.020..0.020 rows=1 loops=1,271)

  • Index Cond: (id = ps_eps.id)
20. 0.012 0.098 ↑ 1.0 20 4 / 4

Hash (cost=2.93..2.93 rows=20 width=26) (actual time=0.098..0.098 rows=20 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
21. 0.019 0.086 ↑ 1.0 20 4 / 4

Merge Right Join (cost=2.05..2.93 rows=20 width=26) (actual time=0.064..0.086 rows=20 loops=4)

  • Merge Cond: (ps_eps_t_bc_cb.id = ps_apfeps_t_apfda.bank_id)
22. 0.019 0.019 ↑ 275.0 6 4 / 4

Index Scan using corporatebase_pkey on corporatebase ps_eps_t_bc_cb (cost=0.28..234.48 rows=1,650 width=26) (actual time=0.016..0.019 rows=6 loops=4)

23. 0.033 0.048 ↑ 1.0 20 4 / 4

Sort (cost=1.63..1.68 rows=20 width=16) (actual time=0.042..0.048 rows=20 loops=4)

  • Sort Key: ps_apfeps_t_apfda.bank_id
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Worker 2: Sort Method: quicksort Memory: 25kB
24. 0.015 0.015 ↑ 1.0 20 4 / 4

Seq Scan on apfdebtoragreement ps_apfeps_t_apfda (cost=0.00..1.20 rows=20 width=16) (actual time=0.008..0.015 rows=20 loops=4)

25. 0.636 0.636 ↑ 1.0 1 1,271 / 4

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

  • Index Cond: (id = ps_apfeps.financingcontext_id)
26. 0.636 0.636 ↑ 1.0 1 1,271 / 4

Index Scan using apffinancingcontext_pkey on apffinancingcontext ps_apffc_fc_afc (cost=0.42..0.49 rows=1 width=132) (actual time=0.002..0.002 rows=1 loops=1,271)

  • Index Cond: (ps_apffc_fc_fcb.id = id)
27. 0.010 0.023 ↑ 1.0 14 4 / 4

Hash (cost=1.14..1.14 rows=14 width=28) (actual time=0.023..0.023 rows=14 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
28. 0.013 0.013 ↑ 1.0 14 4 / 4

Seq Scan on divisionbase od_db (cost=0.00..1.14 rows=14 width=28) (actual time=0.005..0.013 rows=14 loops=4)

29. 0.714 1.718 ↑ 1.0 1,650 4 / 4

Hash (cost=190.50..190.50 rows=1,650 width=26) (actual time=1.717..1.718 rows=1,650 loops=4)

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
30. 1.004 1.004 ↑ 1.0 1,650 4 / 4

Seq Scan on corporatebase od_c_cb (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.004..1.004 rows=1,650 loops=4)

31. 0.004 0.026 ↑ 1.0 1 4 / 4

Hash (cost=8.29..8.29 rows=1 width=26) (actual time=0.026..0.026 rows=1 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
32. 0.022 0.022 ↑ 1.0 1 4 / 4

Index Scan using corporatebase_pkey on corporatebase s_cb (cost=0.28..8.29 rows=1 width=26) (actual time=0.021..0.022 rows=1 loops=4)

  • Index Cond: (id = 6167)
33. 4.766 4.766 ↑ 1.0 1 1,271 / 4

Index Scan using arpimportbatch_pkey on arpimportbatch ib (cost=0.43..6.97 rows=1 width=16) (actual time=0.015..0.015 rows=1 loops=1,271)

  • Index Cond: (si.importbatch_id = id)
34. 0.007 0.018 ↑ 1.0 6 4 / 4

Hash (cost=1.06..1.06 rows=6 width=12) (actual time=0.017..0.018 rows=6 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
35. 0.011 0.011 ↑ 1.0 6 4 / 4

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

36. 0.001 0.004 ↓ 0.0 0 4 / 4

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
37. 0.003 0.003 ↓ 0.0 0 4 / 4

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

38. 0.000 0.003 ↓ 0.0 0 4 / 4

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
39. 0.003 0.003 ↓ 0.0 0 4 / 4

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

40. 0.000 0.000 ↓ 0.0 0 1,271

Index Scan using earlypaymentadvice_pkey on earlypaymentadvice eps_epa (cost=0.28..0.29 rows=1 width=30) (actual time=0.000..0.000 rows=0 loops=1,271)

  • Index Cond: (id = ps_eps.earlypaymentadvice_id)
41.          

SubPlan (for Nested Loop Left Join)

42. 1.271 1.271 ↑ 1.0 1 1,271

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

43. 0.000 0.000 ↓ 0.0 0 1,271

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=1,271)

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

Nested Loop Left Join (cost=2.70..17,379.18 rows=1 width=1,790) (actual time=2.106..2.106 rows=0 loops=1)

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

Nested Loop Left Join (cost=2.70..17,360.79 rows=1 width=387) (actual time=2.105..2.105 rows=0 loops=1)

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

Nested Loop Left Join (cost=2.70..17,350.56 rows=1 width=387) (actual time=2.105..2.105 rows=0 loops=1)

  • Join Filter: (fi_eps_epa.id = fi_eps.earlypaymentadvice_id)
47. 0.000 2.104 ↓ 0.0 0 1

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

48. 0.001 2.104 ↓ 0.0 0 1

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

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

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

50. 0.000 2.102 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.85..17,308.54 rows=1 width=261) (actual time=2.102..2.102 rows=0 loops=1)

51. 0.001 2.102 ↓ 0.0 0 1

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

52. 0.000 2.101 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.29..17,301.60 rows=1 width=241) (actual time=2.101..2.101 rows=0 loops=1)

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

Nested Loop (cost=1.29..17,300.28 rows=1 width=229) (actual time=2.100..2.101 rows=0 loops=1)

  • Join Filter: (scn.referencedinvoice_id = fi_si.id)
54. 0.001 2.100 ↓ 0.0 0 1

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

55. 1.587 2.099 ↓ 0.0 0 1

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

56. 0.512 0.512 ↑ 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.512 rows=2,096 loops=1)

57. 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 >= '2019-01-01'::date)
58. 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)
59. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = fi_eps.invoice_id)
  • Filter: ((nettingbundle_id IS NULL) AND (supplier_id = 6167))
60. 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)

61. 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)
62. 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)
63. 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)
64. 0.000 0.000 ↓ 0.0 0

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

65. 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)
66. 0.000 0.000 ↓ 0.0 0

Seq Scan on earlypaymentadvice fi_eps_epa (cost=0.00..20.45 rows=945 width=30) (never executed)

67. 0.000 0.000 ↓ 0.0 0

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

68. 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)

69.          

SubPlan (for Nested Loop Left Join)

70. 0.000 0.000 ↓ 0.0 0

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

71. 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)
72. 0.034 4.434 ↓ 11.0 11 1

Nested Loop Left Join (cost=3.68..1,530.10 rows=1 width=1,790) (actual time=1.422..4.434 rows=11 loops=1)

  • Join Filter: (fi_si_1.paymentadvice_id = fi_ipa_1.id)
73. 0.018 4.378 ↓ 11.0 11 1

Nested Loop Left Join (cost=3.68..1,511.71 rows=1 width=387) (actual time=1.402..4.378 rows=11 loops=1)

  • Join Filter: (bpt_2.mapping_id = fi_eps_1.earlypaymentmapping_id)
74. 0.019 4.360 ↓ 11.0 11 1

Nested Loop Left Join (cost=3.68..1,501.48 rows=1 width=387) (actual time=1.398..4.360 rows=11 loops=1)

75. 0.015 4.319 ↓ 11.0 11 1

Nested Loop Left Join (cost=3.41..1,501.19 rows=1 width=373) (actual time=1.382..4.319 rows=11 loops=1)

  • Join Filter: (scn_1.currency_id = c_2.id)
76. 0.018 4.293 ↓ 11.0 11 1

Nested Loop Left Join (cost=3.41..1,500.05 rows=1 width=377) (actual time=1.374..4.293 rows=11 loops=1)

77. 0.021 3.439 ↓ 11.0 11 1

Nested Loop Left Join (cost=2.98..1,491.89 rows=1 width=377) (actual time=0.550..3.439 rows=11 loops=1)

78. 0.015 3.407 ↓ 11.0 11 1

Nested Loop Left Join (cost=2.70..1,491.25 rows=1 width=367) (actual time=0.542..3.407 rows=11 loops=1)

79. 0.022 3.370 ↓ 11.0 11 1

Nested Loop Left Join (cost=2.42..1,484.95 rows=1 width=357) (actual time=0.530..3.370 rows=11 loops=1)

  • Join Filter: (fi_si_1.originatordivision_id = od_db_2.id)
  • Rows Removed by Join Filter: 11
80. 0.019 3.337 ↓ 11.0 11 1

Nested Loop Left Join (cost=2.42..1,483.64 rows=1 width=345) (actual time=0.523..3.337 rows=11 loops=1)

81. 0.018 3.318 ↓ 11.0 11 1

Nested Loop Left Join (cost=1.99..1,467.64 rows=1 width=315) (actual time=0.516..3.318 rows=11 loops=1)

82. 0.011 3.278 ↓ 11.0 11 1

Nested Loop (cost=1.57..1,467.18 rows=1 width=199) (actual time=0.507..3.278 rows=11 loops=1)

83. 0.004 3.255 ↑ 1.0 1 1

Nested Loop (cost=1.29..1,465.25 rows=1 width=56) (actual time=0.496..3.255 rows=1 loops=1)

84. 0.004 3.245 ↑ 1.0 1 1

Nested Loop (cost=0.86..1,464.80 rows=1 width=56) (actual time=0.487..3.245 rows=1 loops=1)

85. 0.090 3.231 ↑ 1.0 1 1

Nested Loop (cost=0.43..1,457.55 rows=1 width=40) (actual time=0.473..3.231 rows=1 loops=1)

86. 0.045 0.045 ↑ 1.0 172 1

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

87. 3.096 3.096 ↓ 0.0 0 172

Index Scan using supplierinvoice_pkey on supplierinvoice fi_si_1 (cost=0.43..8.45 rows=1 width=24) (actual time=0.018..0.018 rows=0 loops=172)

  • Index Cond: (id = nb.surplus_id)
  • Filter: (supplier_id = 6167)
  • Rows Removed by Filter: 1
88. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (invoice_id = fi_si_1.id)
  • Filter: (creationdate >= '2019-01-01'::date)
89. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (id = fi_eps_1.id)
90. 0.012 0.012 ↓ 2.8 11 1

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

  • Index Cond: (nettingbundle_id = nb.id)
91. 0.022 0.022 ↑ 1.0 1 11

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

  • Index Cond: (id = fi_ps_apfeps_1.financingcontext_id)
92. 0.000 0.000 ↓ 0.0 0 11

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

  • Index Cond: (id = scn_1.referencedinvoice_id)
93. 0.011 0.011 ↑ 7.0 2 11

Seq Scan on divisionbase od_db_2 (cost=0.00..1.14 rows=14 width=28) (actual time=0.001..0.001 rows=2 loops=11)

94. 0.022 0.022 ↑ 1.0 1 11

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

  • Index Cond: (id = od_db_2.buyer_id)
95. 0.011 0.011 ↑ 1.0 1 11

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

  • Index Cond: (id = scn_1.supplier_id)
96. 0.836 0.836 ↑ 1.0 1 11

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

  • Index Cond: (scn_1.importbatch_id = id)
97. 0.011 0.011 ↑ 6.0 1 11

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

98. 0.022 0.022 ↑ 1.0 1 11

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

  • Index Cond: (id = fi_eps_1.earlypaymentadvice_id)
99. 0.000 0.000 ↓ 0.0 0 11

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

100. 0.000 0.000 ↓ 0.0 0 11

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

101.          

SubPlan (for Nested Loop Left Join)

102. 0.011 0.022 ↑ 1.0 1 11

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

103. 0.011 0.011 ↓ 0.0 0 11

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

  • Index Cond: (mapping_id = fi_eps_1.maturitypaymentmapping_id)
104. 13.631 15.130 ↑ 812.7 47 1

Gather (cost=2,945.45..324,116.30 rows=38,197 width=1,824) (actual time=8.402..15.130 rows=47 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
105. 0.008 1.452 ↑ 1,061.0 9 5 / 5

Hash Left Join (cost=1,945.45..7,131.62 rows=9,549 width=1,433) (actual time=1.376..1.452 rows=9 loops=5)

  • Hash Cond: (fi_eps_2.earlypaymentmapping_id = fi_bpt.mapping_id)
106. 0.010 1.443 ↑ 1,061.0 9 5 / 5

Hash Left Join (cost=1,935.23..7,085.57 rows=9,549 width=1,433) (actual time=1.372..1.443 rows=9 loops=5)

  • Hash Cond: (fi_si_2.paymentadvice_id = fi_ipa_2.id)
107. 0.009 1.432 ↑ 1,061.0 9 5 / 5

Hash Left Join (cost=1,925.00..7,050.28 rows=9,549 width=389) (actual time=1.367..1.432 rows=9 loops=5)

  • Hash Cond: (fi_eps_2.earlypaymentadvice_id = fi_eps_epa_2.id)
108. 0.009 1.306 ↑ 1,061.0 9 5 / 5

Nested Loop Left Join (cost=1,892.74..6,992.95 rows=9,549 width=375) (actual time=1.247..1.306 rows=9 loops=5)

109. 0.009 1.278 ↑ 1,061.0 9 5 / 5

Hash Left Join (cost=1,892.31..2,242.26 rows=9,549 width=375) (actual time=1.244..1.278 rows=9 loops=5)

  • Hash Cond: (si_1.currency_id = c_3.id)
110. 0.009 1.267 ↑ 1,061.0 9 5 / 5

Hash Left Join (cost=1,891.17..2,198.34 rows=9,549 width=379) (actual time=1.239..1.267 rows=9 loops=5)

  • Hash Cond: (si_1.supplier_id = s_cb_3.id)
111. 0.012 1.004 ↑ 1,061.0 9 5 / 5

Hash Left Join (cost=1,680.05..1,962.09 rows=9,549 width=369) (actual time=0.981..1.004 rows=9 loops=5)

  • Hash Cond: (od_db_3.buyer_id = od_c_cb_3.id)
112. 0.014 0.668 ↑ 1,061.0 9 5 / 5

Merge Join (cost=1,468.92..1,725.83 rows=9,549 width=359) (actual time=0.651..0.668 rows=9 loops=5)

  • Merge Cond: (si_1.nettingbundle_id = nb_1.id)
113. 0.016 0.016 ↑ 164,246.0 10 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.011..0.016 rows=10 loops=5)

114. 0.006 0.638 ↑ 1.0 1 5 / 5

Materialize (cost=1,468.49..1,468.50 rows=1 width=184) (actual time=0.635..0.638 rows=1 loops=5)

115. 0.019 0.632 ↑ 1.0 1 5 / 5

Sort (cost=1,468.49..1,468.50 rows=1 width=184) (actual time=0.631..0.632 rows=1 loops=5)

  • Sort Key: nb_1.id
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Worker 2: Sort Method: quicksort Memory: 25kB
  • Worker 3: Sort Method: quicksort Memory: 25kB
116. 0.004 0.613 ↑ 1.0 1 5 / 5

Nested Loop Left Join (cost=1.71..1,468.48 rows=1 width=184) (actual time=0.068..0.613 rows=1 loops=5)

117. 0.003 0.598 ↑ 1.0 1 5 / 5

Nested Loop Left Join (cost=1.29..1,468.02 rows=1 width=68) (actual time=0.053..0.598 rows=1 loops=5)

  • Join Filter: (fi_si_2.originatordivision_id = od_db_3.id)
  • Rows Removed by Join Filter: 1
118. 0.003 0.592 ↑ 1.0 1 5 / 5

Nested Loop (cost=1.29..1,466.70 rows=1 width=56) (actual time=0.048..0.592 rows=1 loops=5)

  • Join Filter: (fi_ps_apfeps_2.apfda_id = fi_ps_apfeps_t_apfda.id)
  • Rows Removed by Join Filter: 3
119. 0.001 0.584 ↑ 1.0 1 5 / 5

Nested Loop (cost=1.29..1,465.25 rows=1 width=64) (actual time=0.041..0.584 rows=1 loops=5)

120. 0.003 0.575 ↑ 1.0 1 5 / 5

Nested Loop (cost=0.86..1,464.80 rows=1 width=56) (actual time=0.031..0.575 rows=1 loops=5)

121. 0.168 0.564 ↑ 1.0 1 5 / 5

Nested Loop (cost=0.43..1,457.55 rows=1 width=40) (actual time=0.021..0.564 rows=1 loops=5)

122. 0.052 0.052 ↑ 1.0 172 5 / 5

Seq Scan on nettingbundle nb_1 (cost=0.00..3.72 rows=172 width=16) (actual time=0.010..0.052 rows=172 loops=5)

123. 0.344 0.344 ↓ 0.0 0 860 / 5

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

  • Index Cond: (id = nb_1.surplus_id)
  • Filter: (supplier_id = 6167)
  • Rows Removed by Filter: 1
124. 0.008 0.008 ↑ 1.0 1 5 / 5

Index Scan using earlypaymentsettlement_invoice_idx on earlypaymentsettlement fi_eps_2 (cost=0.43..7.25 rows=1 width=40) (actual time=0.008..0.008 rows=1 loops=5)

  • Index Cond: (invoice_id = fi_si_2.id)
  • Filter: (creationdate >= '2019-01-01'::date)
125. 0.008 0.008 ↑ 1.0 1 5 / 5

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

  • Index Cond: (id = fi_eps_2.id)
126. 0.005 0.005 ↑ 5.0 4 5 / 5

Seq Scan on apfdebtoragreement fi_ps_apfeps_t_apfda (cost=0.00..1.20 rows=20 width=8) (actual time=0.004..0.005 rows=4 loops=5)

127. 0.003 0.003 ↑ 7.0 2 5 / 5

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

128. 0.011 0.011 ↑ 1.0 1 5 / 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.011..0.011 rows=1 loops=5)

  • Index Cond: (fi_ps_apfeps_2.financingcontext_id = id)
129. 0.120 0.324 ↑ 1.0 1,650 1 / 5

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
130. 0.204 0.204 ↑ 1.0 1,650 1 / 5

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

131. 0.112 0.254 ↑ 1.0 1,650 1 / 5

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
132. 0.141 0.141 ↑ 1.0 1,650 1 / 5

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

133. 0.001 0.002 ↑ 1.0 6 1 / 5

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
134. 0.001 0.001 ↑ 1.0 6 1 / 5

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

135. 0.019 0.019 ↑ 1.0 1 47 / 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=47)

  • Index Cond: (si_1.importbatch_id = id)
136. 0.061 0.117 ↑ 1.0 945 1 / 5

Hash (cost=20.45..20.45 rows=945 width=30) (actual time=0.583..0.583 rows=945 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 68kB
137. 0.056 0.056 ↑ 1.0 945 1 / 5

Seq Scan on earlypaymentadvice fi_eps_epa_2 (cost=0.00..20.45 rows=945 width=30) (actual time=0.006..0.278 rows=945 loops=1)

138. 0.000 0.001 ↓ 0.0 0 1 / 5

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
139. 0.000 0.000 ↓ 0.0 0 1 / 5

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

140. 0.000 0.001 ↓ 0.0 0 1 / 5

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
141. 0.000 0.000 ↓ 0.0 0 1 / 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=1)

142.          

SubPlan (for Gather)

143. 0.047 0.047 ↑ 1.0 1 47

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

144. 0.000 0.000 ↓ 0.0 0 47

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

  • Index Cond: (mapping_id = fi_eps_2.maturitypaymentmapping_id)
145. 0.011 0.735 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.67..1,518.15 rows=1 width=1,758) (actual time=0.226..0.735 rows=1 loops=1)

  • Join Filter: (fi_bpt_1.mapping_id = fi_eps_3.earlypaymentmapping_id)
146. 0.006 0.707 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.67..1,499.75 rows=1 width=1,655) (actual time=0.199..0.707 rows=1 loops=1)

  • Join Filter: (fi_si_3.paymentadvice_id = fi_ipa_3.id)
147. 0.005 0.700 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.67..1,489.52 rows=1 width=611) (actual time=0.193..0.700 rows=1 loops=1)

148. 0.005 0.688 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.40..1,489.23 rows=1 width=597) (actual time=0.181..0.688 rows=1 loops=1)

149. 0.006 0.678 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.96..1,482.26 rows=1 width=597) (actual time=0.172..0.678 rows=1 loops=1)

  • Join Filter: (fi_si_3.currency_id = c_4.id)
150. 0.005 0.670 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.96..1,481.12 rows=1 width=601) (actual time=0.165..0.670 rows=1 loops=1)

151. 0.005 0.629 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.69..1,480.76 rows=1 width=591) (actual time=0.124..0.629 rows=1 loops=1)

152. 0.006 0.618 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.41..1,474.46 rows=1 width=581) (actual time=0.113..0.618 rows=1 loops=1)

153. 0.007 0.604 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.99..1,473.99 rows=1 width=465) (actual time=0.099..0.604 rows=1 loops=1)

154. 0.006 0.591 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.71..1,468.49 rows=1 width=455) (actual time=0.087..0.591 rows=1 loops=1)

155. 0.006 0.575 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.29..1,468.02 rows=1 width=439) (actual time=0.071..0.575 rows=1 loops=1)

  • Join Filter: (fi_si_3.originatordivision_id = od_db_4.id)
  • Rows Removed by Join Filter: 1
156. 0.005 0.567 ↑ 1.0 1 1

Nested Loop (cost=1.29..1,466.70 rows=1 width=427) (actual time=0.064..0.567 rows=1 loops=1)

  • Join Filter: (fi_ps_apfeps_3.apfda_id = fi_ps_apfeps_t_apfda_1.id)
  • Rows Removed by Join Filter: 3
157. 0.005 0.559 ↑ 1.0 1 1

Nested Loop (cost=1.29..1,465.25 rows=1 width=427) (actual time=0.056..0.559 rows=1 loops=1)

158. 0.013 0.547 ↑ 1.0 1 1

Nested Loop (cost=0.86..1,464.80 rows=1 width=411) (actual time=0.044..0.547 rows=1 loops=1)

159. 0.135 0.526 ↑ 1.0 1 1

Nested Loop (cost=0.43..1,457.55 rows=1 width=215) (actual time=0.024..0.526 rows=1 loops=1)

160. 0.047 0.047 ↑ 1.0 172 1

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

161. 0.344 0.344 ↓ 0.0 0 172

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

  • Index Cond: (id = nb_2.surplus_id)
  • Filter: (supplier_id = 6167)
  • Rows Removed by Filter: 1
162. 0.008 0.008 ↑ 1.0 1 1

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

  • Index Cond: (invoice_id = fi_si_3.id)
  • Filter: (creationdate >= '2019-01-01'::date)
163. 0.007 0.007 ↑ 1.0 1 1

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

  • Index Cond: (id = fi_eps_3.id)
164. 0.003 0.003 ↑ 5.0 4 1

Seq Scan on apfdebtoragreement fi_ps_apfeps_t_apfda_1 (cost=0.00..1.20 rows=20 width=16) (actual time=0.002..0.003 rows=4 loops=1)

165. 0.002 0.002 ↑ 7.0 2 1

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

166. 0.010 0.010 ↑ 1.0 1 1

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

  • Index Cond: (id = fi_ps_apfeps_3.financingcontext_id)
167. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (id = fi_ps_apfeps_t_apfda_1.bank_id)
168. 0.008 0.008 ↑ 1.0 1 1

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.008..0.008 rows=1 loops=1)

  • Index Cond: (fi_ps_apfeps_3.financingcontext_id = id)
169. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (id = od_db_4.buyer_id)
170. 0.036 0.036 ↑ 1.0 1 1

Index Scan using corporatebase_pkey on corporatebase s_cb_4 (cost=0.28..0.35 rows=1 width=26) (actual time=0.035..0.036 rows=1 loops=1)

  • Index Cond: ((id = fi_si_3.supplier_id) AND (id = 6167))
171. 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)

172. 0.005 0.005 ↑ 1.0 1 1

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

  • Index Cond: (fi_si_3.importbatch_id = id)
173. 0.007 0.007 ↑ 1.0 1 1

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

  • Index Cond: (id = fi_eps_3.earlypaymentadvice_id)
174. 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)

175. 0.008 0.008 ↓ 0.0 0 1

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

176.          

SubPlan (for Nested Loop Left Join)

177. 0.003 0.009 ↑ 1.0 1 1

Aggregate (cost=8.15..8.16 rows=1 width=8) (actual time=0.008..0.009 rows=1 loops=1)

178. 0.006 0.006 ↓ 0.0 0 1

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

  • Index Cond: (mapping_id = fi_eps_3.maturitypaymentmapping_id)
Planning time : 40.354 ms
Execution time : 691.272 ms