explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XnR9

Settings
# exclusive inclusive rows x rows loops node
1. 16.436 105.528 ↑ 8.0 2,000 1

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

  • Workers Planned: 4
  • Workers Launched: 4
2. 0.902 79.092 ↑ 10.1 400 5 / 5

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

3. 0.426 77.390 ↑ 10.1 400 5 / 5

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

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

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

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

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

6. 0.415 74.914 ↑ 10.1 400 5 / 5

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

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

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

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

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

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

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

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

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

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

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

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

13. 0.702 65.786 ↑ 10.1 400 5 / 5

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

14. 0.566 52.684 ↑ 10.1 400 5 / 5

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

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

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

17. 1.203 1.203 ↑ 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.003..0.003 rows=1 loops=2,005)

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

Sort (cost=1,242.39..1,242.41 rows=5 width=89) (actual time=46.939..47.062 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. 1.194 44.932 ↓ 408.4 2,042 5 / 5

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

20. 4.409 37.612 ↓ 408.4 2,042 5 / 5

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

21. 2.451 27.077 ↓ 408.4 2,042 5 / 5

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

22. 1.059 22.584 ↓ 408.4 2,042 5 / 5

Nested Loop (cost=1,156.27..1,203.42 rows=5 width=45) (actual time=18.701..22.584 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.009..0.011 rows=1 loops=5)

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

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

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

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

26. 7.154 18.588 ↑ 1.0 14,760 5 / 5

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

  • Buckets: 16384 Batches: 1 Memory Usage: 936kB
27. 11.434 11.434 ↑ 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.016..11.434 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. 6.126 6.126 ↑ 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.003..0.003 rows=1 loops=10,210)

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

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

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

Merge Right Join (cost=1.68..2.04 rows=14 width=26) (actual time=0.006..0.018 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.585 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.015 0.015 ↑ 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.011..0.015 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.851 1.695 ↑ 1.0 2,100 5 / 5

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

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

41. 0.008 0.014 ↑ 1.0 14 5 / 5

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
42. 0.006 0.006 ↑ 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.006 rows=14 loops=5)

43. 0.004 0.014 ↑ 1.0 1 5 / 5

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

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

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

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

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

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

  • Merge Cond: (fi_cba.id = fi_ifca.maturitypaymentsaccount_id)
47. 0.012 0.012 ↑ 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.011..0.012 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.008..0.010 rows=6 loops=5)

50. 2.239 3.127 ↑ 1.0 1,650 5 / 5

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

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

52. 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
53. 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)

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.018 0.036 ↑ 1.0 40 5 / 5

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
56. 0.018 0.018 ↑ 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.018 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. 6.000 10.000 ↑ 1.0 1 2,000

Aggregate (cost=8.31..8.32 rows=1 width=8) (actual time=0.005..0.005 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 : 11.582 ms
Execution time : 106.495 ms