explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fwJS

Settings
# exclusive inclusive rows x rows loops node
1. 303.273 6,187.486 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,162.19..1,258.13 rows=1 width=2,669) (actual time=13.533..6,187.486 rows=100,000 loops=1)

2. 154.031 5,584.213 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,162.06..1,249.62 rows=1 width=516) (actual time=13.507..5,584.213 rows=100,000 loops=1)

3. 138.896 5,230.182 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,161.77..1,249.31 rows=1 width=516) (actual time=13.496..5,230.182 rows=100,000 loops=1)

4. 277.260 5,091.286 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,161.63..1,249.13 rows=1 width=502) (actual time=13.490..5,091.286 rows=100,000 loops=1)

  • Join Filter: ((fi_ifca.absda_id = fi_ps_abseps_t_absda.id) AND (fi_ifca.currency_id = fi_si.currency_id))
  • Rows Removed by Join Filter: 500000
5. 106.187 3,714.026 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,160.21..1,247.41 rows=1 width=394) (actual time=13.447..3,714.026 rows=100,000 loops=1)

6. 101.316 3,507.839 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,160.08..1,247.26 rows=1 width=394) (actual time=13.438..3,507.839 rows=100,000 loops=1)

7. 138.156 3,206.523 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,159.80..1,246.96 rows=1 width=277) (actual time=13.428..3,206.523 rows=100,000 loops=1)

8. 154.762 2,868.367 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,159.36..1,246.48 rows=1 width=269) (actual time=13.417..2,868.367 rows=100,000 loops=1)

9. 141.556 2,513.605 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,158.93..1,239.33 rows=1 width=245) (actual time=13.405..2,513.605 rows=100,000 loops=1)

10. 151.001 2,272.049 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,158.80..1,239.17 rows=1 width=249) (actual time=13.397..2,272.049 rows=100,000 loops=1)

11. 183.347 1,921.048 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,158.37..1,231.01 rows=1 width=249) (actual time=13.386..1,921.048 rows=100,000 loops=1)

12. 181.299 1,637.701 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,158.09..1,230.37 rows=1 width=239) (actual time=13.378..1,637.701 rows=100,000 loops=1)

13. 128.537 1,356.402 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,157.81..1,224.07 rows=1 width=229) (actual time=13.368..1,356.402 rows=100,000 loops=1)

14. 125.953 1,227.865 ↓ 100,000.0 100,000 1

Nested Loop Left Join (cost=1,157.38..1,208.07 rows=1 width=199) (actual time=13.363..1,227.865 rows=100,000 loops=1)

15. 141.776 1,001.912 ↓ 100,000.0 100,000 1

Nested Loop (cost=1,157.24..1,207.92 rows=1 width=187) (actual time=13.357..1,001.912 rows=100,000 loops=1)

16. 154.900 660.036 ↓ 100,050.0 100,050 1

Nested Loop (cost=1,156.96..1,207.43 rows=1 width=40) (actual time=13.350..660.036 rows=100,050 loops=1)

17. 94.489 405.086 ↓ 100,050.0 100,050 1

Nested Loop (cost=1,156.83..1,207.27 rows=1 width=40) (actual time=13.342..405.086 rows=100,050 loops=1)

18. 53.714 110.313 ↓ 100,142.0 100,142 1

Nested Loop (cost=1,156.55..1,206.92 rows=1 width=48) (actual time=13.018..110.313 rows=100,142 loops=1)

19. 2.083 15.759 ↓ 408.4 2,042 1

Hash Join (cost=1,156.27..1,202.05 rows=5 width=48) (actual time=13.005..15.759 rows=2,042 loops=1)

  • Hash Cond: (nb_1.surplus_id = fi_si.id)
20. 0.705 0.705 ↑ 1.0 2,042 1

Seq Scan on nettingbundle nb_1 (cost=0.00..40.42 rows=2,042 width=16) (actual time=0.007..0.705 rows=2,042 loops=1)

21. 4.897 12.971 ↑ 1.0 14,760 1

Hash (cost=970.92..970.92 rows=14,828 width=32) (actual time=12.970..12.971 rows=14,760 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 936kB
22. 8.074 8.074 ↑ 1.0 14,760 1

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

  • Index Cond: (lastauction_id = 6656)
23. 40.840 40.840 ↓ 2.0 49 2,042

Index Scan using nettingbundle_surplus_idx on nettingbundle nb (cost=0.28..0.72 rows=25 width=16) (actual time=0.003..0.020 rows=49 loops=2,042)

  • Index Cond: (surplus_id = fi_si.id)
24. 200.284 200.284 ↑ 1.0 1 100,142

Index Only Scan using suppliercreditnote_nettingbundle_idx on suppliercreditnote scn_1 (cost=0.28..0.34 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=100,142)

  • Index Cond: (nettingbundle_id = nb_1.id)
  • Heap Fetches: 0
25. 100.050 100.050 ↑ 1.0 1 100,050

Index Scan using divisionbase_pkey on divisionbase od_db_1 (cost=0.14..0.16 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=100,050)

  • Index Cond: (id = fi_si.originatordivision_id)
  • Filter: (buyer_id = 64608300)
26. 200.100 200.100 ↑ 1.0 1 100,050

Index Scan using suppliercreditnote_nettingbundle_idx on suppliercreditnote scn (cost=0.28..0.48 rows=1 width=155) (actual time=0.001..0.002 rows=1 loops=100,050)

  • Index Cond: (nettingbundle_id = nb.id)
27. 100.000 100.000 ↑ 1.0 1 100,000

Index Scan using divisionbase_pkey on divisionbase od_db (cost=0.14..0.15 rows=1 width=28) (actual time=0.001..0.001 rows=1 loops=100,000)

  • Index Cond: (fi_si.originatordivision_id = id)
28. 0.000 0.000 ↓ 0.0 0 100,000

Index Scan using supplierinvoice_pkey on supplierinvoice ref_si (cost=0.43..8.21 rows=1 width=38) (actual time=0.000..0.000 rows=0 loops=100,000)

  • Index Cond: (id = scn.referencedinvoice_id)
29. 100.000 100.000 ↑ 1.0 1 100,000

Index Scan using corporatebase_pkey on corporatebase od_c_cb (cost=0.28..6.29 rows=1 width=26) (actual time=0.001..0.001 rows=1 loops=100,000)

  • Index Cond: (id = od_db.buyer_id)
30. 100.000 100.000 ↑ 1.0 1 100,000

Index Scan using corporatebase_pkey on corporatebase s_cb (cost=0.28..0.64 rows=1 width=26) (actual time=0.001..0.001 rows=1 loops=100,000)

  • Index Cond: (id = scn.supplier_id)
31. 200.000 200.000 ↑ 1.0 1 100,000

Index Scan using arpimportbatch_pkey on arpimportbatch ib (cost=0.43..8.16 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=100,000)

  • Index Cond: (scn.importbatch_id = id)
32. 100.000 100.000 ↑ 1.0 1 100,000

Index Scan using crxcurrency_pkey on crxcurrency c (cost=0.13..0.16 rows=1 width=12) (actual time=0.001..0.001 rows=1 loops=100,000)

  • Index Cond: (scn.currency_id = id)
33. 200.000 200.000 ↑ 1.0 1 100,000

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=100,000)

  • Index Cond: (fi_si.id = invoice_id)
34. 200.000 200.000 ↑ 1.0 1 100,000

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=100,000)

  • Index Cond: (id = fi_eps.id)
35. 200.000 200.000 ↑ 1.0 1 100,000

Index Scan using absfinancingcontext_pkey on absfinancingcontext fi_ps_absfc_fc_afc (cost=0.28..0.30 rows=1 width=133) (actual time=0.002..0.002 rows=1 loops=100,000)

  • Index Cond: (id = fi_ps_abseps.financingcontext_id)
36. 100.000 100.000 ↑ 1.0 1 100,000

Index Only Scan using absdebtoragreement_pkey on absdebtoragreement fi_ps_abseps_t_absda (cost=0.14..0.15 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=100,000)

  • Index Cond: (id = fi_ps_abseps.absda_id)
  • Heap Fetches: 0
37. 400.000 1,100.000 ↑ 1.0 6 100,000

Merge Right Join (cost=1.42..1.63 rows=6 width=140) (actual time=0.006..0.011 rows=6 loops=100,000)

  • Merge Cond: (fi_cba.id = fi_ifca.maturitypaymentsaccount_id)
38. 500.000 500.000 ↑ 544.3 3 100,000

Index Scan using corporatebankaccount_pkey on corporatebankaccount fi_cba (cost=0.28..99.78 rows=1,633 width=132) (actual time=0.004..0.005 rows=3 loops=100,000)

39. 199.992 200.000 ↑ 1.0 6 100,000

Sort (cost=1.14..1.15 rows=6 width=24) (actual time=0.000..0.002 rows=6 loops=100,000)

  • Sort Key: fi_ifca.maturitypaymentsaccount_id
  • Sort Method: quicksort Memory: 25kB
40. 0.008 0.008 ↑ 1.0 6 1

Seq Scan on fiduciarycashaccount fi_ifca (cost=0.00..1.06 rows=6 width=24) (actual time=0.006..0.008 rows=6 loops=1)

41. 0.000 0.000 ↓ 0.0 0 100,000

Index Scan using earlypaymentadvice_pkey on earlypaymentadvice fi_eps_epa (cost=0.14..0.16 rows=1 width=30) (actual time=0.000..0.000 rows=0 loops=100,000)

  • Index Cond: (id = fi_eps.earlypaymentadvice_id)
42. 200.000 200.000 ↑ 1.0 1 100,000

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt (cost=0.29..0.31 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=100,000)

  • Index Cond: (mapping_id = fi_eps.earlypaymentmapping_id)
43. 0.000 0.000 ↓ 0.0 0 100,000

Index Scan using invoicepaymentadvice_pkey on invoicepaymentadvice fi_ipa (cost=0.14..0.16 rows=1 width=1,052) (actual time=0.000..0.000 rows=0 loops=100,000)

  • Index Cond: (fi_si.paymentadvice_id = id)
44.          

SubPlan (for Nested Loop Left Join)

45. 100.000 300.000 ↑ 1.0 1 100,000

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

46. 200.000 200.000 ↑ 1.0 1 100,000

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt_1 (cost=0.29..8.30 rows=1 width=8) (actual time=0.001..0.002 rows=1 loops=100,000)

  • Index Cond: (mapping_id = fi_eps.maturitypaymentmapping_id)
Planning time : 8.749 ms
Execution time : 6,210.968 ms