explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jwuj

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

Nested Loop Left Join (cost=4.50..66.82 rows=1 width=3,059) (actual time=0.013..0.013 rows=0 loops=1)

2. 0.000 0.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.37..50.49 rows=1 width=2,694) (actual time=0.012..0.012 rows=0 loops=1)

3. 0.001 0.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.23..50.32 rows=1 width=1,650) (actual time=0.012..0.012 rows=0 loops=1)

4. 0.000 0.011 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.08..34.14 rows=1 width=1,562) (actual time=0.011..0.011 rows=0 loops=1)

5. 0.001 0.011 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.95..33.98 rows=1 width=1,054) (actual time=0.011..0.011 rows=0 loops=1)

6. 0.000 0.010 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.51..33.48 rows=1 width=1,054) (actual time=0.010..0.010 rows=0 loops=1)

7. 0.000 0.010 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.24..33.19 rows=1 width=1,044) (actual time=0.010..0.010 rows=0 loops=1)

8. 0.001 0.010 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.96..26.89 rows=1 width=1,034) (actual time=0.009..0.010 rows=0 loops=1)

9. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=2.82..26.73 rows=1 width=428) (actual time=0.009..0.009 rows=0 loops=1)

10. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=2.55..26.43 rows=1 width=436) (actual time=0.009..0.009 rows=0 loops=1)

11. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=2.13..25.98 rows=1 width=444) (actual time=0.008..0.008 rows=0 loops=1)

12. 0.000 0.008 ↓ 0.0 0 1

Nested Loop (cost=1.70..25.43 rows=1 width=420) (actual time=0.008..0.008 rows=0 loops=1)

  • Join Filter: (ps_eps.id = ddsceps.id)
13. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=1.28..24.94 rows=1 width=420) (actual time=0.007..0.008 rows=0 loops=1)

14. 0.000 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.86..16.51 rows=1 width=412) (actual time=0.007..0.007 rows=0 loops=1)

15. 0.007 0.007 ↓ 0.0 0 1

Index Scan using earlypaymentsettlement_creationdate_idx on earlypaymentsettlement ps_eps (cost=0.43..8.06 rows=1 width=220) (actual time=0.006..0.007 rows=0 loops=1)

  • Index Cond: (creationdate >= '2019-03-01'::date)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using supplierinvoice_pkey on supplierinvoice si (cost=0.43..8.45 rows=1 width=208) (never executed)

  • Index Cond: (id = ps_eps.invoice_id)
  • Filter: (nettingbundle_id IS NULL)
17. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ddearlypaymentsettlement_pkey on ddearlypaymentsettlement ps_ddeps (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Index Cond: (id = ps_eps.id)
  • Heap Fetches: 0
18. 0.000 0.000 ↓ 0.0 0

Index Scan using ddsuppliercentricearlypaymentsettlement_pkey on ddsuppliercentricearlypaymentsettlement ddsceps (cost=0.42..0.47 rows=1 width=16) (never executed)

  • Index Cond: (id = ps_ddeps.id)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using financingcontextbase_pkey on financingcontextbase ps_ddps_fc_fcb (cost=0.42..0.55 rows=1 width=24) (never executed)

  • Index Cond: (id = ddsceps.financingcontext_id)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using ddsuppliercentricfinancingcontext_pkey on ddsuppliercentricfinancingcontext ddscfc (cost=0.42..0.45 rows=1 width=16) (never executed)

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

Index Scan using payablesapprovalagreement_pkey on payablesapprovalagreement paa (cost=0.28..0.30 rows=1 width=8) (never executed)

  • Index Cond: (id = ddscfc.paa_id)
  • Filter: (buyer_id = 66,895,525)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using divisionbase_pkey on divisionbase od_db (cost=0.14..0.15 rows=1 width=622) (never executed)

  • Index Cond: (si.originatordivision_id = id)
23. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = od_db.buyer_id)
24. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (si.importbatch_id = id)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using crxcurrency_pkey on crxcurrency c (cost=0.13..0.15 rows=1 width=524) (never executed)

  • Index Cond: (si.currency_id = id)
27. 0.000 0.000 ↓ 0.0 0

Index Scan using earlypaymentadvice_pkey on earlypaymentadvice eps_epa (cost=0.15..8.17 rows=1 width=104) (never executed)

  • Index Cond: (id = ps_eps.earlypaymentadvice_id)
28. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (si.paymentadvice_id = id)
29. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (mapping_id = ps_eps.earlypaymentmapping_id)
30.          

SubPlan (for Nested Loop Left Join)

31. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=8.15..8.16 rows=1 width=8) (never executed)

32. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (mapping_id = ps_eps.maturitypaymentmapping_id)
Planning time : 8.704 ms
Execution time : 0.243 ms