explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gRDr

Settings
# exclusive inclusive rows x rows loops node
1. 21.157 17,066.163 ↑ 4.9 10,328 1

Gather (cost=31,570.81..840,594.79 rows=50,461 width=1,810) (actual time=16,917.866..17,066.163 rows=10,328 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 2.010 17,034.678 ↑ 6.1 2,066 5 / 5

Hash Left Join (cost=30,570.81..422,156.17 rows=12,615 width=1,655) (actual time=16,909.873..17,034.678 rows=2,066 loops=5)

  • Hash Cond: (ps_eps.earlypaymentmapping_id = bpt.mapping_id)
3. 2.773 17,032.664 ↑ 6.1 2,066 5 / 5

Hash Left Join (cost=30,560.58..422,098.63 rows=12,615 width=1,655) (actual time=16,909.852..17,032.664 rows=2,066 loops=5)

  • Hash Cond: (si.paymentadvice_id = ipa.id)
4. 2.685 17,029.884 ↑ 6.1 2,066 5 / 5

Hash Left Join (cost=30,550.36..422,055.29 rows=12,615 width=611) (actual time=16,909.829..17,029.884 rows=2,066 loops=5)

  • Hash Cond: (ps_eps.earlypaymentadvice_id = eps_epa.id)
5. 1.969 17,025.603 ↑ 6.1 2,066 5 / 5

Hash Left Join (cost=30,518.09..421,989.91 rows=12,615 width=597) (actual time=16,908.217..17,025.603 rows=2,066 loops=5)

  • Hash Cond: (si.currency_id = c.id)
6. 4.368 17,023.609 ↑ 6.1 2,066 5 / 5

Nested Loop Left Join (cost=30,516.96..421,932.28 rows=12,615 width=601) (actual time=16,908.175..17,023.609 rows=2,066 loops=5)

7. 2.781 17,010.979 ↑ 6.1 2,066 5 / 5

Hash Left Join (cost=30,516.53..415,656.22 rows=12,615 width=601) (actual time=16,908.155..17,010.979 rows=2,066 loops=5)

  • Hash Cond: (si.supplier_id = s_cb.id)
8. 1.973 17,006.404 ↑ 6.1 2,066 5 / 5

Hash Left Join (cost=30,305.40..415,411.89 rows=12,615 width=591) (actual time=16,906.345..17,006.404 rows=2,066 loops=5)

  • Hash Cond: (od_db.buyer_id = od_c_cb.id)
9. 9.714 17,004.386 ↑ 6.1 2,066 5 / 5

Hash Join (cost=30,297.09..415,230.13 rows=12,615 width=581) (actual time=16,906.272..17,004.386 rows=2,066 loops=5)

  • Hash Cond: (si.originatordivision_id = od_db.id)
10. 17.518 16,994.652 ↑ 10.3 17,116 5 / 5

Hash Left Join (cost=30,295.91..414,624.99 rows=176,613 width=569) (actual time=13,352.394..16,994.652 rows=17,116 loops=5)

  • Hash Cond: (ps_apfeps_t_apfda.bank_id = ps_eps_t_bc_cb.id)
11. 18.797 16,975.267 ↑ 10.3 17,116 5 / 5

Parallel Hash Left Join (cost=30,084.78..413,949.07 rows=176,613 width=559) (actual time=13,350.510..16,975.267 rows=17,116 loops=5)

  • Hash Cond: (ps_apffc_fc_fcb.id = ps_apffc_fc_afc.id)
12. 18.791 16,891.997 ↑ 10.3 17,116 5 / 5

Parallel Hash Left Join (cost=22,939.69..406,340.37 rows=176,613 width=443) (actual time=13,284.900..16,891.997 rows=17,116 loops=5)

  • Hash Cond: (ps_apfeps.financingcontext_id = ps_apffc_fc_fcb.id)
13. 15.326 16,773.011 ↑ 10.3 17,116 5 / 5

Hash Left Join (cost=13,096.28..396,033.35 rows=176,613 width=427) (actual time=13,184.227..16,773.011 rows=17,116 loops=5)

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
14. 15.249 16,757.656 ↑ 10.3 17,116 5 / 5

Hash Left Join (cost=13,094.83..395,470.05 rows=176,613 width=427) (actual time=13,184.177..16,757.656 rows=17,116 loops=5)

  • Hash Cond: (si.nettingbundle_id = nb.id)
  • Filter: ((si.nettingbundle_id IS NULL) OR (si.id = nb.surplus_id))
15. 30.022 16,742.259 ↑ 10.3 17,116 5 / 5

Nested Loop (cost=13,088.96..395,000.42 rows=176,670 width=435) (actual time=13,184.007..16,742.259 rows=17,116 loops=5)

16. 649.517 16,575.309 ↑ 10.3 17,116 5 / 5

Parallel Hash Join (cost=13,088.53..281,740.40 rows=176,670 width=236) (actual time=13,182.416..16,575.309 rows=17,116 loops=5)

  • Hash Cond: (ps_eps.id = ps_apfeps.id)
17. 15,725.739 15,725.739 ↑ 1.2 1,084,962 5 / 5

Parallel Seq Scan on earlypaymentsettlement ps_eps (cost=0.00..265,095.99 rows=1,354,620 width=220) (actual time=0.917..15,725.739 rows=1,084,962 loops=5)

  • Filter: (creationdate >= '2019-01-01'::date)
  • Rows Removed by Filter: 189854
18. 117.619 200.053 ↑ 2.1 166,262 5 / 5

Parallel Hash (cost=8,758.79..8,758.79 rows=346,379 width=24) (actual time=200.052..200.053 rows=166,262 loops=5)

  • Buckets: 1048576 Batches: 1 Memory Usage: 53792kB
19. 82.434 82.434 ↑ 2.1 166,262 5 / 5

Parallel Seq Scan on apfearlypaymentsettlement ps_apfeps (cost=0.00..8,758.79 rows=346,379 width=24) (actual time=0.007..82.434 rows=166,262 loops=5)

20. 136.928 136.928 ↑ 1.0 1 85,580 / 5

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..0.64 rows=1 width=207) (actual time=0.008..0.008 rows=1 loops=85,580)

  • Index Cond: (id = ps_eps.invoice_id)
21. 0.073 0.148 ↑ 1.0 172 5 / 5

Hash (cost=3.72..3.72 rows=172 width=16) (actual time=0.148..0.148 rows=172 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
22. 0.075 0.075 ↑ 1.0 172 5 / 5

Seq Scan on nettingbundle nb (cost=0.00..3.72 rows=172 width=16) (actual time=0.011..0.075 rows=172 loops=5)

23. 0.012 0.029 ↑ 1.0 20 5 / 5

Hash (cost=1.20..1.20 rows=20 width=16) (actual time=0.028..0.029 rows=20 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.017 0.017 ↑ 1.0 20 5 / 5

Seq Scan on apfdebtoragreement ps_apfeps_t_apfda (cost=0.00..1.20 rows=20 width=16) (actual time=0.010..0.017 rows=20 loops=5)

25. 57.593 100.195 ↑ 2.1 78,899 5 / 5

Parallel Hash (cost=7,788.74..7,788.74 rows=164,374 width=24) (actual time=100.195..100.195 rows=78,899 loops=5)

  • Buckets: 524288 Batches: 1 Memory Usage: 26688kB
26. 42.602 42.602 ↑ 2.1 78,899 5 / 5

Parallel Seq Scan on financingcontextbase ps_apffc_fc_fcb (cost=0.00..7,788.74 rows=164,374 width=24) (actual time=0.006..42.602 rows=78,899 loops=5)

27. 35.492 64.473 ↑ 2.1 47,959 5 / 5

Parallel Hash (cost=5,896.15..5,896.15 rows=99,915 width=132) (actual time=64.473..64.473 rows=47,959 loops=5)

  • Buckets: 262144 Batches: 1 Memory Usage: 20896kB
28. 28.981 28.981 ↑ 2.1 47,959 5 / 5

Parallel Seq Scan on apffinancingcontext ps_apffc_fc_afc (cost=0.00..5,896.15 rows=99,915 width=132) (actual time=0.003..28.981 rows=47,959 loops=5)

29. 0.771 1.867 ↑ 1.0 1,650 5 / 5

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

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

Seq Scan on corporatebase ps_eps_t_bc_cb (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.006..1.096 rows=1,650 loops=5)

31. 0.006 0.020 ↑ 1.0 1 5 / 5

Hash (cost=1.18..1.18 rows=1 width=28) (actual time=0.020..0.020 rows=1 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
32. 0.014 0.014 ↑ 1.0 1 5 / 5

Seq Scan on divisionbase od_db (cost=0.00..1.18 rows=1 width=28) (actual time=0.013..0.014 rows=1 loops=5)

  • Filter: (buyer_id = 67002626)
  • Rows Removed by Filter: 13
33. 0.004 0.045 ↑ 1.0 1 5 / 5

Hash (cost=8.29..8.29 rows=1 width=26) (actual time=0.045..0.045 rows=1 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.041 0.041 ↑ 1.0 1 5 / 5

Index Scan using corporatebase_pkey on corporatebase od_c_cb (cost=0.28..8.29 rows=1 width=26) (actual time=0.039..0.041 rows=1 loops=5)

  • Index Cond: (id = 67002626)
35. 0.772 1.794 ↑ 1.0 1,650 5 / 5

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

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

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

37. 8.262 8.262 ↑ 1.0 1 10,328 / 5

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

  • Index Cond: (si.importbatch_id = id)
38. 0.006 0.025 ↑ 1.0 6 5 / 5

Hash (cost=1.06..1.06 rows=6 width=12) (actual time=0.025..0.025 rows=6 loops=5)

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

Seq Scan on crxcurrency c (cost=0.00..1.06 rows=6 width=12) (actual time=0.016..0.019 rows=6 loops=5)

40. 0.427 1.596 ↑ 1.0 945 5 / 5

Hash (cost=20.45..20.45 rows=945 width=30) (actual time=1.596..1.596 rows=945 loops=5)

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

Seq Scan on earlypaymentadvice eps_epa (cost=0.00..20.45 rows=945 width=30) (actual time=0.009..1.169 rows=945 loops=5)

42. 0.001 0.007 ↓ 0.0 0 5 / 5

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

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

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

44. 0.001 0.004 ↓ 0.0 0 5 / 5

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

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

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

46.          

SubPlan (for Gather)

47. 10.328 10.328 ↑ 1.0 1 10,328

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

48. 0.000 0.000 ↓ 0.0 0 10,328

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

  • Index Cond: (mapping_id = ps_eps.maturitypaymentmapping_id)
Planning time : 7.703 ms
Execution time : 17,069.338 ms