explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bgxG

Settings
# exclusive inclusive rows x rows loops node
1. 23.972 115.567 ↑ 8.0 2,000 1

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

  • Workers Planned: 4
  • Workers Launched: 4
2. 1.750 83.595 ↑ 10.1 400 5 / 5

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

3. 0.426 81.045 ↑ 10.1 400 5 / 5

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

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

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

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

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

6. 0.441 78.483 ↑ 10.1 400 5 / 5

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

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

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

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

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

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

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

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

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

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

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

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

13. 1.027 67.225 ↑ 10.1 400 5 / 5

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

14. 0.686 51.798 ↑ 10.1 400 5 / 5

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

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

16. 0.254 0.254 ↑ 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.008..0.254 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.228 48.030 ↓ 85.0 425 5 / 5

Sort (cost=1,242.39..1,242.41 rows=5 width=89) (actual time=47.891..48.030 rows=425 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.722 45.802 ↓ 408.4 2,042 5 / 5

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

20. 3.816 37.996 ↓ 408.4 2,042 5 / 5

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

21. 2.838 30.096 ↓ 408.4 2,042 5 / 5

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

22. 1.957 25.216 ↓ 408.4 2,042 5 / 5

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

23. 0.015 0.015 ↑ 1.0 1 5 / 5

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

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

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

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

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

26. 8.551 20.074 ↑ 1.0 14,760 5 / 5

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

  • Buckets: 16384 Batches: 1 Memory Usage: 936kB
27. 11.523 11.523 ↑ 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.028..11.523 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. 4.084 4.084 ↑ 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.002..0.002 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. 3.600 14.400 ↑ 1.0 1 2,000 / 5

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

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

Merge Right Join (cost=1.68..2.04 rows=14 width=26) (actual time=0.007..0.022 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.577 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.023 0.023 ↑ 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.017..0.023 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. 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. 1.730 2.656 ↑ 1.0 2,100 5 / 5

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

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

41. 0.008 0.016 ↑ 1.0 14 5 / 5

Hash (cost=1.14..1.14 rows=14 width=8) (actual time=0.016..0.016 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.016 ↑ 1.0 1 5 / 5

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

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

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

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

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

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

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

48. 0.013 0.026 ↑ 1.0 6 5 / 5

Sort (cost=1.14..1.15 rows=6 width=24) (actual time=0.024..0.026 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.013 0.013 ↑ 1.0 6 5 / 5

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

50. 0.697 1.771 ↑ 1.0 1,650 5 / 5

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

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

52. 0.007 0.019 ↑ 1.0 6 5 / 5

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

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

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

54. 1.200 1.200 ↑ 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.003..0.003 rows=1 loops=2,000)

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

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

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

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

57. 0.000 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.004 0.004 ↓ 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.004 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 : 14.796 ms
Execution time : 116.963 ms