explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3MMA

Settings
# exclusive inclusive rows x rows loops node
1. 11.705 2,249.206 ↑ 8.3 85,408 1

Gather (cost=31,096.66..6,350,860.60 rows=706,451 width=1,826) (actual time=1,544.786..2,249.206 rows=85,408 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 21.140 2,152.093 ↑ 10.3 17,082 5 / 5

Hash Left Join (cost=30,096.66..505,744.70 rows=176,613 width=1,639) (actual time=1,537.939..2,152.093 rows=17,082 loops=5)

  • Hash Cond: (ps_eps.earlypaymentmapping_id = bpt.mapping_id)
3. 21.257 2,130.946 ↑ 10.3 17,082 5 / 5

Hash Left Join (cost=30,086.44..505,072.17 rows=176,613 width=1,639) (actual time=1,537.916..2,130.946 rows=17,082 loops=5)

  • Hash Cond: (si.paymentadvice_id = ipa.id)
4. 18.908 2,109.684 ↑ 10.3 17,082 5 / 5

Hash Left Join (cost=30,076.21..504,598.34 rows=176,613 width=595) (actual time=1,537.896..2,109.684 rows=17,082 loops=5)

  • Hash Cond: (ps_eps.earlypaymentadvice_id = eps_epa.id)
5. 21.878 2,090.039 ↑ 10.3 17,082 5 / 5

Hash Left Join (cost=30,043.95..504,102.46 rows=176,613 width=581) (actual time=1,537.145..2,090.039 rows=17,082 loops=5)

  • Hash Cond: (si.currency_id = c.id)
6. 39.796 2,068.146 ↑ 10.3 17,082 5 / 5

Nested Loop Left Join (cost=30,042.81..503,310.24 rows=176,613 width=585) (actual time=1,537.114..2,068.146 rows=17,082 loops=5)

7. 19.279 1,977.105 ↑ 10.3 17,082 5 / 5

Hash Left Join (cost=30,042.38..415,441.24 rows=176,613 width=585) (actual time=1,537.096..1,977.105 rows=17,082 loops=5)

  • Hash Cond: (si.supplier_id = s_cb.id)
8. 21.288 1,954.707 ↑ 10.3 17,082 5 / 5

Hash Left Join (cost=29,831.26..414,765.31 rows=176,613 width=575) (actual time=1,533.961..1,954.707 rows=17,082 loops=5)

  • Hash Cond: (od_db.buyer_id = od_c_cb.id)
9. 22.490 1,931.915 ↑ 10.3 17,082 5 / 5

Hash Left Join (cost=29,620.13..414,089.39 rows=176,613 width=565) (actual time=1,532.443..1,931.915 rows=17,082 loops=5)

  • Hash Cond: (si.originatordivision_id = od_db.id)
10. 20.733 1,909.400 ↑ 10.3 17,082 5 / 5

Hash Left Join (cost=29,618.82..413,484.12 rows=176,613 width=553) (actual time=1,532.400..1,909.400 rows=17,082 loops=5)

  • Hash Cond: (ps_apfeps_t_apfda.bank_id = ps_eps_t_bc_cb.id)
11. 27.861 1,886.167 ↑ 10.3 17,082 5 / 5

Parallel Hash Left Join (cost=29,407.69..412,808.20 rows=176,613 width=543) (actual time=1,529.880..1,886.167 rows=17,082 loops=5)

  • Hash Cond: (ps_apffc_fc_fcb.id = ps_apffc_fc_afc.id)
12. 28.151 1,797.168 ↑ 10.3 17,082 5 / 5

Parallel Hash Left Join (cost=22,262.60..405,199.50 rows=176,613 width=427) (actual time=1,468.218..1,797.168 rows=17,082 loops=5)

  • Hash Cond: (ps_apfeps.financingcontext_id = ps_apffc_fc_fcb.id)
13. 24.411 1,691.426 ↑ 10.3 17,082 5 / 5

Hash Join (cost=13,090.41..395,563.70 rows=176,613 width=427) (actual time=1,390.090..1,691.426 rows=17,082 loops=5)

  • Hash Cond: (ps_apfeps.apfda_id = ps_apfeps_t_apfda.id)
14. 39.406 1,666.982 ↑ 10.3 17,082 5 / 5

Nested Loop (cost=13,088.96..395,000.40 rows=176,613 width=427) (actual time=1,390.028..1,666.982 rows=17,082 loops=5)

15. 727.351 1,576.228 ↑ 10.3 17,116 5 / 5

Parallel Hash Join (cost=13,088.53..281,740.46 rows=176,670 width=236) (actual time=1,389.996..1,576.228 rows=17,116 loops=5)

  • Hash Cond: (ps_eps.id = ps_apfeps.id)
16. 668.642 668.642 ↑ 1.2 1,084,962 5 / 5

Parallel Seq Scan on earlypaymentsettlement ps_eps (cost=0.00..265,096.04 rows=1,354,624 width=220) (actual time=0.006..668.642 rows=1,084,962 loops=5)

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

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

  • Buckets: 1048576 Batches: 1 Memory Usage: 53856kB
18. 66.782 66.782 ↑ 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.006..66.782 rows=166,262 loops=5)

19. 51.348 51.348 ↑ 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.003..0.003 rows=1 loops=85,580)

  • Index Cond: (id = ps_eps.invoice_id)
  • Filter: (nettingbundle_id IS NULL)
  • Rows Removed by Filter: 0
20. 0.010 0.033 ↑ 1.0 20 5 / 5

Hash (cost=1.20..1.20 rows=20 width=16) (actual time=0.032..0.033 rows=20 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
21. 0.023 0.023 ↑ 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.016..0.023 rows=20 loops=5)

22. 49.358 77.591 ↑ 1.6 78,899 5 / 5

Parallel Hash (cost=7,581.48..7,581.48 rows=127,257 width=8) (actual time=77.590..77.591 rows=78,899 loops=5)

  • Buckets: 524288 Batches: 1 Memory Usage: 19616kB
23. 28.233 28.233 ↑ 1.6 78,899 5 / 5

Parallel Index Only Scan using financingcontextbase_pkey on financingcontextbase ps_apffc_fc_fcb (cost=0.42..7,581.48 rows=127,257 width=8) (actual time=0.025..28.233 rows=78,899 loops=5)

  • Heap Fetches: 0
24. 32.662 61.138 ↑ 2.1 47,959 5 / 5

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

  • Buckets: 262144 Batches: 1 Memory Usage: 20896kB
25. 28.476 28.476 ↑ 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.005..28.476 rows=47,959 loops=5)

26. 0.697 2.500 ↑ 1.0 1,650 5 / 5

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

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

28. 0.011 0.025 ↑ 1.0 14 5 / 5

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

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

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

30. 0.673 1.504 ↑ 1.0 1,650 5 / 5

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

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

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

32. 0.680 3.119 ↑ 1.0 1,650 5 / 5

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
33. 2.439 2.439 ↑ 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.003..2.439 rows=1,650 loops=5)

34. 51.245 51.245 ↑ 1.0 1 85,408 / 5

Index Scan using arpimportbatch_pkey on arpimportbatch ib (cost=0.43..0.50 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=85,408)

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

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

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

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

37. 0.385 0.737 ↑ 1.0 945 5 / 5

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

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

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

39. 0.001 0.005 ↓ 0.0 0 5 / 5

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

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

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

41. 0.001 0.007 ↓ 0.0 0 5 / 5

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

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

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

43.          

SubPlan (for Gather)

44. 85.408 85.408 ↑ 1.0 1 85,408

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

45. 0.000 0.000 ↓ 0.0 0 85,408

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=85,408)

  • Index Cond: (mapping_id = ps_eps.maturitypaymentmapping_id)
Planning time : 8.281 ms
Execution time : 2,275.879 ms