explain.depesz.com

PostgreSQL's explain analyze made readable

Result: avB0

Settings
# exclusive inclusive rows x rows loops node
1. 11.616 213.413 ↑ 8.0 2,000 1

Gather (cost=2,573.56..145,777.40 rows=16,085 width=1,770) (actual time=164.291..213.413 rows=2,000 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 0.948 193.797 ↑ 10.1 400 5 / 5

Nested Loop Left Join (cost=1,573.56..9,180.85 rows=4,021 width=1,793) (actual time=152.326..193.797 rows=400 loops=5)

3. 0.457 183.249 ↑ 10.1 400 5 / 5

Hash Left Join (cost=1,573.27..7,910.57 rows=4,021 width=1,793) (actual time=150.634..183.249 rows=400 loops=5)

  • Hash Cond: (fi_si.paymentadvice_id = fi_ipa.id)
4. 0.418 182.786 ↑ 10.1 400 5 / 5

Hash Left Join (cost=1,563.05..7,889.79 rows=4,021 width=749) (actual time=150.609..182.786 rows=400 loops=5)

  • Hash Cond: (fi_eps.earlypaymentadvice_id = fi_eps_epa.id)
5. 1.693 181.898 ↑ 10.1 400 5 / 5

Nested Loop Left Join (cost=1,561.15..7,877.34 rows=4,021 width=735) (actual time=150.116..181.898 rows=400 loops=5)

6. 0.448 174.605 ↑ 10.1 400 5 / 5

Hash Left Join (cost=1,560.72..5,876.85 rows=4,021 width=735) (actual time=148.474..174.605 rows=400 loops=5)

  • Hash Cond: (si.currency_id = c.id)
7. 0.449 173.717 ↑ 10.1 400 5 / 5

Hash Left Join (cost=1,559.58..5,857.70 rows=4,021 width=739) (actual time=148.012..173.717 rows=400 loops=5)

  • Hash Cond: (si.supplier_id = s_cb.id)
8. 0.497 167.141 ↑ 10.1 400 5 / 5

Hash Left Join (cost=1,348.46..5,636.00 rows=4,021 width=729) (actual time=141.864..167.141 rows=400 loops=5)

  • Hash Cond: ((fi_ps_abseps_t_absda.id = fi_ifca.absda_id) AND (si.currency_id = fi_ifca.currency_id))
9. 0.443 166.029 ↑ 10.1 400 5 / 5

Hash Left Join (cost=1,346.73..5,586.89 rows=4,021 width=613) (actual time=141.230..166.029 rows=400 loops=5)

  • Hash Cond: (od_db.buyer_id = od_c_cb.id)
10. 0.447 165.354 ↑ 10.1 400 5 / 5

Hash Left Join (cost=1,338.43..5,523.29 rows=4,021 width=603) (actual time=140.980..165.354 rows=400 loops=5)

  • Hash Cond: (fi_ps_abseps.absda_id = fi_ps_abseps_t_absda.id)
11. 0.487 164.892 ↑ 10.1 400 5 / 5

Hash Left Join (cost=1,337.11..5,508.23 rows=4,021 width=603) (actual time=140.946..164.892 rows=400 loops=5)

  • Hash Cond: (fi_ps_abseps.financingcontext_id = fi_ps_absfc_fc_afc.id)
12. 1.478 161.269 ↑ 10.1 400 5 / 5

Nested Loop Left Join (cost=1,245.86..5,406.40 rows=4,021 width=486) (actual time=137.777..161.269 rows=400 loops=5)

13. 1.005 157.791 ↑ 10.1 400 5 / 5

Nested Loop Left Join (cost=1,245.44..3,615.16 rows=4,021 width=478) (actual time=136.753..157.791 rows=400 loops=5)

14. 0.586 142.786 ↑ 10.1 400 5 / 5

Merge Join (cost=1,243.26..1,896.25 rows=4,021 width=452) (actual time=136.015..142.786 rows=400 loops=5)

  • Merge Cond: (si.nettingbundle_id = nb.id)
15. 1.124 9.026 ↑ 4,095.6 401 5 / 5

Nested Loop Left Join (cost=0.86..1,900,629.54 rows=1,642,328 width=371) (actual time=2.959..9.026 rows=401 loops=5)

16. 5.095 5.095 ↑ 4,095.6 401 5 / 5

Parallel Index Scan using supplierinvoice_nettingbundle_idx on supplierinvoice si (cost=0.43..899,246.94 rows=1,642,328 width=191) (actual time=1.332..5.095 rows=401 loops=5)

17. 2.807 2.807 ↑ 1.0 1 2,005 / 5

Index Scan using earlypaymentsettlement_invoice_uq on earlypaymentsettlement ps_eps (cost=0.43..0.61 rows=1 width=196) (actual time=0.007..0.007 rows=1 loops=2,005)

  • Index Cond: (si.id = invoice_id)
18. 3.092 133.174 ↓ 84.4 422 5 / 5

Sort (cost=1,242.39..1,242.41 rows=5 width=89) (actual time=133.043..133.174 rows=422 loops=5)

  • Sort Key: nb.id
  • Sort Method: quicksort Memory: 336kB
  • Worker 0: Sort Method: quicksort Memory: 336kB
  • Worker 1: Sort Method: quicksort Memory: 336kB
  • Worker 2: Sort Method: quicksort Memory: 336kB
  • Worker 3: Sort Method: quicksort Memory: 336kB
19. 2.908 130.082 ↓ 408.4 2,042 5 / 5

Nested Loop Left Join (cost=1,157.27..1,242.34 rows=5 width=89) (actual time=86.900..130.082 rows=2,042 loops=5)

20. 1.710 108.796 ↓ 408.4 2,042 5 / 5

Nested Loop Left Join (cost=1,156.84..1,239.92 rows=5 width=81) (actual time=85.641..108.796 rows=2,042 loops=5)

21. 3.762 94.834 ↓ 408.4 2,042 5 / 5

Nested Loop (cost=1,156.41..1,204.20 rows=5 width=57) (actual time=84.998..94.834 rows=2,042 loops=5)

22. 1.111 86.988 ↓ 408.4 2,042 5 / 5

Nested Loop (cost=1,156.27..1,203.42 rows=5 width=45) (actual time=83.624..86.988 rows=2,042 loops=5)

23. 0.114 0.114 ↑ 1.0 1 5 / 5

Seq Scan on capfloorauction cfa (cost=0.00..1.31 rows=1 width=21) (actual time=0.111..0.114 rows=1 loops=5)

  • Filter: (id = 6656)
  • Rows Removed by Filter: 24
24. 1.673 85.763 ↓ 408.4 2,042 5 / 5

Hash Join (cost=1,156.27..1,202.05 rows=5 width=40) (actual time=83.509..85.763 rows=2,042 loops=5)

  • Hash Cond: (nb.surplus_id = fi_si.id)
25. 0.903 0.903 ↑ 1.0 2,042 5 / 5

Seq Scan on nettingbundle nb (cost=0.00..40.42 rows=2,042 width=16) (actual time=0.189..0.903 rows=2,042 loops=5)

26. 6.647 83.187 ↑ 1.0 14,760 5 / 5

Hash (cost=970.92..970.92 rows=14,828 width=32) (actual time=83.186..83.187 rows=14,760 loops=5)

  • Buckets: 16384 Batches: 1 Memory Usage: 936kB
27. 76.540 76.540 ↑ 1.0 14,760 5 / 5

Index Scan using supplierinvoice_lastauction_idx on supplierinvoice fi_si (cost=0.43..970.92 rows=14,828 width=32) (actual time=1.010..76.540 rows=14,760 loops=5)

  • Index Cond: (lastauction_id = 6656)
28. 4.084 4.084 ↑ 1.0 1 10,210 / 5

Index Scan using divisionbase_pkey on divisionbase od_db (cost=0.14..0.16 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=10,210)

  • Index Cond: (id = fi_si.originatordivision_id)
  • Filter: (buyer_id = 64608300)
29. 12.252 12.252 ↑ 1.0 1 10,210 / 5

Index Scan using earlypaymentsettlement_invoice_uq on earlypaymentsettlement fi_eps (cost=0.43..7.14 rows=1 width=40) (actual time=0.006..0.006 rows=1 loops=10,210)

  • Index Cond: (fi_si.id = invoice_id)
30. 18.378 18.378 ↑ 1.0 1 10,210 / 5

Index Scan using absearlypaymentsettlement_pkey on absearlypaymentsettlement fi_ps_abseps (cost=0.43..0.48 rows=1 width=24) (actual time=0.009..0.009 rows=1 loops=10,210)

  • Index Cond: (fi_eps.id = id)
31. 3.600 14.000 ↑ 1.0 1 2,000 / 5

Hash Right Join (cost=2.18..2.60 rows=1 width=34) (actual time=0.023..0.035 rows=1 loops=2,000)

  • Hash Cond: (ps_abseps_t_absda.id = ps_abseps.absda_id)
32. 3.600 8.400 ↑ 1.0 14 2,000 / 5

Merge Right Join (cost=1.68..2.04 rows=14 width=26) (actual time=0.008..0.021 rows=14 loops=2,000)

  • Merge Cond: (ps_eps_t_bc_cb.id = ps_abseps_t_absda.bank_id)
33. 2.800 2.800 ↑ 825.0 2 2,000 / 5

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.006..0.007 rows=2 loops=2,000)

34. 1.736 2.000 ↑ 1.0 14 2,000 / 5

Sort (cost=1.41..1.44 rows=14 width=16) (actual time=0.001..0.005 rows=14 loops=2,000)

  • Sort Key: ps_abseps_t_absda.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
  • Worker 3: Sort Method: quicksort Memory: 25kB
35. 0.264 0.264 ↑ 1.0 14 5 / 5

Seq Scan on absdebtoragreement ps_abseps_t_absda (cost=0.00..1.14 rows=14 width=16) (actual time=0.259..0.264 rows=14 loops=5)

36. 0.800 2.000 ↑ 1.0 1 2,000 / 5

Hash (cost=0.48..0.48 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=2,000)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 1.200 1.200 ↑ 1.0 1 2,000 / 5

Index Scan using absearlypaymentsettlement_pkey on absearlypaymentsettlement ps_abseps (cost=0.43..0.48 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=2,000)

  • Index Cond: (ps_eps.id = id)
38. 2.000 2.000 ↑ 1.0 1 2,000 / 5

Index Scan using financingcontextbase_pkey on financingcontextbase ps_absfc_fc_fcb (cost=0.42..0.45 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=2,000)

  • Index Cond: (id = ps_abseps.financingcontext_id)
39. 0.921 3.136 ↑ 1.0 2,100 5 / 5

Hash (cost=65.00..65.00 rows=2,100 width=133) (actual time=3.136..3.136 rows=2,100 loops=5)

  • Buckets: 4096 Batches: 1 Memory Usage: 197kB
40. 2.215 2.215 ↑ 1.0 2,100 5 / 5

Seq Scan on absfinancingcontext fi_ps_absfc_fc_afc (cost=0.00..65.00 rows=2,100 width=133) (actual time=0.248..2.215 rows=2,100 loops=5)

41. 0.007 0.015 ↑ 1.0 14 5 / 5

Hash (cost=1.14..1.14 rows=14 width=8) (actual time=0.015..0.015 rows=14 loops=5)

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

Seq Scan on absdebtoragreement fi_ps_abseps_t_absda (cost=0.00..1.14 rows=14 width=8) (actual time=0.003..0.008 rows=14 loops=5)

43. 0.005 0.232 ↑ 1.0 1 5 / 5

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
44. 0.227 0.227 ↑ 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.226..0.227 rows=1 loops=5)

  • Index Cond: (id = 64608300)
45. 0.008 0.615 ↑ 1.0 6 5 / 5

Hash (cost=1.63..1.63 rows=6 width=140) (actual time=0.615..0.615 rows=6 loops=5)

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

Merge Right Join (cost=1.42..1.63 rows=6 width=140) (actual time=0.599..0.607 rows=6 loops=5)

  • Merge Cond: (fi_cba.id = fi_ifca.maturitypaymentsaccount_id)
47. 0.292 0.292 ↑ 544.3 3 5 / 5

Index Scan using corporatebankaccount_pkey on corporatebankaccount fi_cba (cost=0.28..99.78 rows=1,633 width=132) (actual time=0.290..0.292 rows=3 loops=5)

48. 0.017 0.306 ↑ 1.0 6 5 / 5

Sort (cost=1.14..1.15 rows=6 width=24) (actual time=0.304..0.306 rows=6 loops=5)

  • Sort Key: fi_ifca.maturitypaymentsaccount_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
49. 0.289 0.289 ↑ 1.0 6 5 / 5

Seq Scan on fiduciarycashaccount fi_ifca (cost=0.00..1.06 rows=6 width=24) (actual time=0.286..0.289 rows=6 loops=5)

50. 0.679 6.127 ↑ 1.0 1,650 5 / 5

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

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

52. 0.008 0.440 ↑ 1.0 6 5 / 5

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

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

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

54. 5.600 5.600 ↑ 1.0 1 2,000 / 5

Index Scan using arpimportbatch_pkey on arpimportbatch ib (cost=0.43..0.50 rows=1 width=16) (actual time=0.014..0.014 rows=1 loops=2,000)

  • Index Cond: (si.importbatch_id = id)
55. 0.022 0.470 ↑ 1.0 40 5 / 5

Hash (cost=1.40..1.40 rows=40 width=30) (actual time=0.470..0.470 rows=40 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
56. 0.448 0.448 ↑ 1.0 40 5 / 5

Seq Scan on earlypaymentadvice fi_eps_epa (cost=0.00..1.40 rows=40 width=30) (actual time=0.435..0.448 rows=40 loops=5)

57. 0.000 0.006 ↓ 0.0 0 5 / 5

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

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

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

59. 9.600 9.600 ↑ 1.0 1 2,000 / 5

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction fi_bpt (cost=0.29..0.31 rows=1 width=16) (actual time=0.024..0.024 rows=1 loops=2,000)

  • Index Cond: (mapping_id = fi_eps.earlypaymentmapping_id)
60.          

SubPlan (for Gather)

61. 2.000 8.000 ↑ 1.0 1 2,000

Aggregate (cost=8.31..8.32 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=2,000)

62. 6.000 6.000 ↑ 1.0 1 2,000

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt (cost=0.29..8.30 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=2,000)

  • Index Cond: (mapping_id = fi_eps.maturitypaymentmapping_id)
Planning time : 142.088 ms
Execution time : 214.797 ms