explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qyni

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 5.828 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.55..900.94 rows=1 width=2,669) (actual time=5.828..5.828 rows=0 loops=1)

2. 0.001 5.827 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.27..884.98 rows=1 width=1,444) (actual time=5.827..5.827 rows=0 loops=1)

  • Join Filter: ((fi_ifca.absda_id = fi_ps_abseps_t_absda.id) AND (fi_ifca.currency_id = fi_si.currency_id))
3. 0.000 5.826 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.27..883.83 rows=1 width=1,452) (actual time=5.826..5.826 rows=0 loops=1)

4. 0.001 5.826 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.13..883.65 rows=1 width=408) (actual time=5.826..5.826 rows=0 loops=1)

5. 0.000 5.825 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.85..883.33 rows=1 width=408) (actual time=5.825..5.825 rows=0 loops=1)

  • Join Filter: (fi_eps_epa.id = fi_eps.earlypaymentadvice_id)
6. 0.001 5.825 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.85..881.43 rows=1 width=394) (actual time=5.825..5.825 rows=0 loops=1)

  • Join Filter: (fi_ps_abseps.absda_id = fi_ps_abseps_t_absda.id)
7. 0.000 5.824 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.85..880.12 rows=1 width=394) (actual time=5.824..5.824 rows=0 loops=1)

8. 0.001 5.824 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.57..879.82 rows=1 width=277) (actual time=5.824..5.824 rows=0 loops=1)

9. 0.000 5.823 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.13..879.34 rows=1 width=269) (actual time=5.823..5.823 rows=0 loops=1)

10. 0.001 5.823 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.70..872.19 rows=1 width=245) (actual time=5.823..5.823 rows=0 loops=1)

  • Join Filter: (scn.currency_id = c.id)
11. 0.000 5.822 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.70..871.06 rows=1 width=249) (actual time=5.822..5.822 rows=0 loops=1)

12. 0.001 5.822 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.27..862.61 rows=1 width=249) (actual time=5.822..5.822 rows=0 loops=1)

13. 0.000 5.821 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.99..858.85 rows=1 width=239) (actual time=5.821..5.821 rows=0 loops=1)

14. 0.001 5.821 ↓ 0.0 0 1

Nested Loop (cost=0.71..852.54 rows=1 width=229) (actual time=5.820..5.821 rows=0 loops=1)

  • Join Filter: (fi_si.originatordivision_id = od_db.id)
15. 0.087 5.820 ↓ 0.0 0 1

Nested Loop (cost=0.71..850.19 rows=1 width=217) (actual time=5.820..5.820 rows=0 loops=1)

16. 5.733 5.733 ↑ 1.0 96 1

Index Scan using suppliercreditnote_nettingbundle_idx on suppliercreditnote scn (cost=0.28..30.73 rows=96 width=155) (actual time=1.821..5.733 rows=96 loops=1)

  • Index Cond: (nettingbundle_id IS NULL)
17. 0.000 0.000 ↓ 0.0 0 96

Index Scan using supplierinvoice_pkey on supplierinvoice fi_si (cost=0.43..8.45 rows=1 width=62) (actual time=0.000..0.000 rows=0 loops=96)

  • Index Cond: (id = scn.referencedinvoice_id)
  • Filter: (lastauction_id = 6656)
18. 0.000 0.000 ↓ 0.0 0

Seq Scan on divisionbase od_db (cost=0.00..2.17 rows=14 width=28) (never executed)

  • Filter: (buyer_id = 64608300)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using corporatebase_pkey on corporatebase od_c_cb (cost=0.28..6.30 rows=1 width=26) (never executed)

  • Index Cond: ((id = od_db.buyer_id) AND (id = 64608300))
20. 0.000 0.000 ↓ 0.0 0

Index Scan using corporatebase_pkey on corporatebase s_cb (cost=0.28..3.75 rows=1 width=26) (never executed)

  • Index Cond: (id = scn.supplier_id)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using arpimportbatch_pkey on arpimportbatch ib (cost=0.43..8.45 rows=1 width=16) (never executed)

  • Index Cond: (scn.importbatch_id = id)
22. 0.000 0.000 ↓ 0.0 0

Seq Scan on crxcurrency c (cost=0.00..1.06 rows=6 width=12) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Index Scan using earlypaymentsettlement_invoice_uq on earlypaymentsettlement fi_eps (cost=0.43..7.14 rows=1 width=40) (never executed)

  • Index Cond: (fi_si.id = invoice_id)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using absearlypaymentsettlement_pkey on absearlypaymentsettlement fi_ps_abseps (cost=0.43..0.48 rows=1 width=24) (never executed)

  • Index Cond: (id = fi_eps.id)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using absfinancingcontext_pkey on absfinancingcontext fi_ps_absfc_fc_afc (cost=0.28..0.30 rows=1 width=133) (never executed)

  • Index Cond: (id = fi_ps_abseps.financingcontext_id)
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on absdebtoragreement fi_ps_abseps_t_absda (cost=0.00..1.14 rows=14 width=8) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Seq Scan on earlypaymentadvice fi_eps_epa (cost=0.00..1.40 rows=40 width=30) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt (cost=0.29..0.31 rows=1 width=16) (never executed)

  • Index Cond: (mapping_id = fi_eps.earlypaymentmapping_id)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using invoicepaymentadvice_pkey on invoicepaymentadvice fi_ipa (cost=0.14..0.16 rows=1 width=1,052) (never executed)

  • Index Cond: (fi_si.paymentadvice_id = id)
30. 0.000 0.000 ↓ 0.0 0

Seq Scan on fiduciarycashaccount fi_ifca (cost=0.00..1.06 rows=6 width=24) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Index Scan using corporatebankaccount_pkey on corporatebankaccount fi_cba (cost=0.28..7.63 rows=1 width=132) (never executed)

  • Index Cond: (id = fi_ifca.maturitypaymentsaccount_id)
32.          

SubPlan (for Nested Loop Left Join)

33. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.31..8.32 rows=1 width=8) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Index Scan using bankpaymenttransaction_mapping_idx on bankpaymenttransaction bpt_1 (cost=0.29..8.30 rows=1 width=8) (never executed)

  • Index Cond: (mapping_id = fi_eps.maturitypaymentmapping_id)
Planning time : 35.156 ms
Execution time : 6.322 ms