explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mr1

Settings
# exclusive inclusive rows x rows loops node
1. 6.262 99.313 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,161.80..1,394.24 rows=5 width=2,669) (actual time=13.989..99.313 rows=2,000 loops=1)

2. 1.921 87.051 ↓ 400.0 2,000 1

Hash Left Join (cost=1,161.67..1,351.81 rows=5 width=516) (actual time=13.965..87.051 rows=2,000 loops=1)

  • Hash Cond: ((fi_ps_abseps_t_absda.id = fi_ifca.absda_id) AND (fi_si.currency_id = fi_ifca.currency_id))
3. 2.855 85.088 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,159.95..1,350.03 rows=5 width=408) (actual time=13.913..85.088 rows=2,000 loops=1)

4. 2.645 78.233 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,159.66..1,348.45 rows=5 width=408) (actual time=13.903..78.233 rows=2,000 loops=1)

5. 2.302 75.588 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,159.52..1,347.64 rows=5 width=394) (actual time=13.898..75.588 rows=2,000 loops=1)

6. 1.831 71.286 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,159.38..1,346.88 rows=5 width=394) (actual time=13.889..71.286 rows=2,000 loops=1)

7. 2.819 65.455 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,159.10..1,345.39 rows=5 width=277) (actual time=13.880..65.455 rows=2,000 loops=1)

8. 3.154 58.636 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,158.67..1,342.97 rows=5 width=269) (actual time=13.869..58.636 rows=2,000 loops=1)

9. 2.627 51.482 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,158.24..1,307.25 rows=5 width=245) (actual time=13.858..51.482 rows=2,000 loops=1)

10. 3.060 46.855 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,158.11..1,306.49 rows=5 width=249) (actual time=13.852..46.855 rows=2,000 loops=1)

11. 2.313 39.795 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,157.67..1,265.69 rows=5 width=249) (actual time=13.842..39.795 rows=2,000 loops=1)

12. 2.315 33.482 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,157.40..1,262.48 rows=5 width=239) (actual time=13.835..33.482 rows=2,000 loops=1)

  • Join Filter: (od_c_cb.id = od_db.buyer_id)
13. 2.499 31.167 ↓ 400.0 2,000 1

Nested Loop Left Join (cost=1,157.12..1,254.11 rows=5 width=229) (actual time=13.822..31.167 rows=2,000 loops=1)

14. 3.146 28.668 ↓ 400.0 2,000 1

Nested Loop (cost=1,156.69..1,205.26 rows=5 width=199) (actual time=13.817..28.668 rows=2,000 loops=1)

15. 3.450 23.522 ↓ 400.0 2,000 1

Nested Loop (cost=1,156.55..1,204.48 rows=5 width=187) (actual time=13.809..23.522 rows=2,000 loops=1)

16. 1.665 15.988 ↓ 408.4 2,042 1

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

  • Hash Cond: (nb.surplus_id = fi_si.id)
17. 0.653 0.653 ↑ 1.0 2,042 1

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

18. 4.809 13.670 ↑ 1.0 14,760 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 936kB
19. 8.861 8.861 ↑ 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.861 rows=14,760 loops=1)

  • Index Cond: (lastauction_id = 6656)
20. 4.084 4.084 ↑ 1.0 1 2,042

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

  • Index Cond: (nettingbundle_id = nb.id)
21. 2.000 2.000 ↑ 1.0 1 2,000

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

  • Index Cond: (id = fi_si.originatordivision_id)
  • Filter: (buyer_id = 64608300)
22. 0.000 0.000 ↓ 0.0 0 2,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=2,000)

  • Index Cond: (id = scn.referencedinvoice_id)
23. 0.000 0.000 ↑ 1.0 1 2,000

Materialize (cost=0.28..8.30 rows=1 width=26) (actual time=0.000..0.000 rows=1 loops=2,000)

24. 0.007 0.007 ↑ 1.0 1 1

Index Scan using corporatebase_pkey on corporatebase od_c_cb (cost=0.28..8.29 rows=1 width=26) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (id = 64608300)
25. 4.000 4.000 ↑ 1.0 1 2,000

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

  • Index Cond: (id = scn.supplier_id)
26. 4.000 4.000 ↑ 1.0 1 2,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=2,000)

  • Index Cond: (scn.importbatch_id = id)
27. 2.000 2.000 ↑ 1.0 1 2,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=2,000)

  • Index Cond: (scn.currency_id = id)
28. 4.000 4.000 ↑ 1.0 1 2,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=2,000)

  • Index Cond: (fi_si.id = invoice_id)
29. 4.000 4.000 ↑ 1.0 1 2,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=2,000)

  • Index Cond: (id = fi_eps.id)
30. 4.000 4.000 ↑ 1.0 1 2,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=2,000)

  • Index Cond: (id = fi_ps_abseps.financingcontext_id)
31. 2.000 2.000 ↑ 1.0 1 2,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=2,000)

  • Index Cond: (id = fi_ps_abseps.absda_id)
  • Heap Fetches: 0
32. 0.000 0.000 ↓ 0.0 0 2,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=2,000)

  • Index Cond: (id = fi_eps.earlypaymentadvice_id)
33. 4.000 4.000 ↑ 1.0 1 2,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=2,000)

  • Index Cond: (mapping_id = fi_eps.earlypaymentmapping_id)
34. 0.005 0.042 ↑ 1.0 6 1

Hash (cost=1.63..1.63 rows=6 width=140) (actual time=0.042..0.042 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
35. 0.008 0.037 ↑ 1.0 6 1

Merge Right Join (cost=1.42..1.63 rows=6 width=140) (actual time=0.030..0.037 rows=6 loops=1)

  • Merge Cond: (fi_cba.id = fi_ifca.maturitypaymentsaccount_id)
36. 0.011 0.011 ↑ 544.3 3 1

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=1)

37. 0.010 0.018 ↑ 1.0 6 1

Sort (cost=1.14..1.15 rows=6 width=24) (actual time=0.016..0.018 rows=6 loops=1)

  • Sort Key: fi_ifca.maturitypaymentsaccount_id
  • Sort Method: quicksort Memory: 25kB
38. 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.005..0.008 rows=6 loops=1)

39. 0.000 0.000 ↓ 0.0 0 2,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=2,000)

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

SubPlan (for Nested Loop Left Join)

41. 2.000 6.000 ↑ 1.0 1 2,000

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

42. 4.000 4.000 ↑ 1.0 1 2,000

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt_1 (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 : 6.385 ms
Execution time : 100.036 ms