explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9aoi

Settings
# exclusive inclusive rows x rows loops node
1. 18.039 109.134 ↑ 8.0 2,000 1

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

  • Workers Planned: 4
  • Workers Launched: 4
2. 0.972 83.095 ↑ 10.1 400 5 / 5

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

3. 0.458 81.323 ↑ 10.1 400 5 / 5

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

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

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

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

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

6. 0.454 78.745 ↑ 10.1 400 5 / 5

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

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

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

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

Hash Left Join (cost=1,348.46..5,636.00 rows=4,021 width=729) (actual time=49.763..76.174 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.455 74.807 ↑ 10.1 400 5 / 5

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

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

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

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

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

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

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

13. 2.394 69.053 ↑ 10.1 400 5 / 5

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

14. 0.658 51.459 ↑ 10.1 400 5 / 5

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

  • Merge Cond: (si.nettingbundle_id = nb.id)
15. 1.980 3.023 ↑ 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=0.024..3.023 rows=401 loops=5)

16. 0.241 0.241 ↑ 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=0.007..0.241 rows=401 loops=5)

17. 0.802 0.802 ↑ 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.002..0.002 rows=1 loops=2,005)

  • Index Cond: (si.id = invoice_id)
18. 1.395 47.778 ↓ 85.4 427 5 / 5

Sort (cost=1,242.39..1,242.41 rows=5 width=89) (actual time=47.631..47.778 rows=427 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. 3.662 46.383 ↓ 408.4 2,042 5 / 5

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

20. 3.355 38.637 ↓ 408.4 2,042 5 / 5

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

21. 3.612 29.156 ↓ 408.4 2,042 5 / 5

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

22. 1.205 23.502 ↓ 408.4 2,042 5 / 5

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

23. 0.011 0.011 ↑ 1.0 1 5 / 5

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

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

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

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

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

26. 6.945 19.983 ↑ 1.0 14,760 5 / 5

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

  • Buckets: 16384 Batches: 1 Memory Usage: 936kB
27. 13.038 13.038 ↑ 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=0.020..13.038 rows=14,760 loops=5)

  • Index Cond: (lastauction_id = 6656)
28. 2.042 2.042 ↑ 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.001..0.001 rows=1 loops=10,210)

  • Index Cond: (id = fi_si.originatordivision_id)
  • Filter: (buyer_id = 64608300)
29. 6.126 6.126 ↑ 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.003..0.003 rows=1 loops=10,210)

  • Index Cond: (fi_si.id = invoice_id)
30. 4.084 4.084 ↑ 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.002..0.002 rows=1 loops=10,210)

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

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

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

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

  • Merge Cond: (ps_eps_t_bc_cb.id = ps_abseps_t_absda.bank_id)
33. 2.000 2.000 ↑ 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.005..0.005 rows=2 loops=2,000)

34. 1.587 1.600 ↑ 1.0 14 2,000 / 5

Sort (cost=1.41..1.44 rows=14 width=16) (actual time=0.000..0.004 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.013 0.013 ↑ 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.008..0.013 rows=14 loops=5)

36. 0.400 1.600 ↑ 1.0 1 2,000 / 5

Hash (cost=0.48..0.48 rows=1 width=24) (actual time=0.004..0.004 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. 0.800 0.800 ↑ 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.002..0.002 rows=1 loops=2,000)

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

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

  • Buckets: 4096 Batches: 1 Memory Usage: 197kB
40. 0.906 0.906 ↑ 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.007..0.906 rows=2,100 loops=5)

41. 0.008 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.007 0.007 ↑ 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.002..0.007 rows=14 loops=5)

43. 0.006 0.015 ↑ 1.0 1 5 / 5

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

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

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

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

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

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

  • Merge Cond: (fi_cba.id = fi_ifca.maturitypaymentsaccount_id)
47. 0.011 0.011 ↑ 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.010..0.011 rows=3 loops=5)

48. 0.013 0.023 ↑ 1.0 6 5 / 5

Sort (cost=1.14..1.15 rows=6 width=24) (actual time=0.021..0.023 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.010 0.010 ↑ 1.0 6 5 / 5

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

50. 0.714 1.647 ↑ 1.0 1,650 5 / 5

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

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

52. 0.007 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
53. 0.008 0.008 ↑ 1.0 6 5 / 5

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

54. 0.800 0.800 ↑ 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.002..0.002 rows=1 loops=2,000)

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

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

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

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

57. 0.001 0.004 ↓ 0.0 0 5 / 5

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

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

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

59. 0.800 0.800 ↑ 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.002..0.002 rows=1 loops=2,000)

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

SubPlan (for Gather)

61. 4.000 8.000 ↑ 1.0 1 2,000

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

62. 4.000 4.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.002 rows=1 loops=2,000)

  • Index Cond: (mapping_id = fi_eps.maturitypaymentmapping_id)
Planning time : 13.840 ms
Execution time : 110.487 ms