explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IctD

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

Nested Loop (cost=2.27..12,322.29 rows=47 width=1,976) (actual time=1.717..1.717 rows=0 loops=1)

2. 0.000 1.716 ↓ 0.0 0 1

Nested Loop (cost=1.85..11,799.75 rows=1,193 width=224) (actual time=1.716..1.716 rows=0 loops=1)

  • Join Filter: (creditnote.referencedinvoice_id = referencedinvoice.id)
3. 0.001 1.716 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.42..11,799.11 rows=1 width=202) (actual time=1.716..1.716 rows=0 loops=1)

  • Join Filter: (creditnote.currency_id = lineitemcurrency.id)
4. 0.000 1.715 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.42..11,797.97 rows=1 width=206) (actual time=1.715..1.715 rows=0 loops=1)

5. 0.001 1.715 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.99..11,789.72 rows=1 width=206) (actual time=1.715..1.715 rows=0 loops=1)

6. 0.000 1.714 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.71..11,788.91 rows=1 width=196) (actual time=1.714..1.714 rows=0 loops=1)

7. 0.000 1.714 ↓ 0.0 0 1

Nested Loop (cost=0.43..11,782.61 rows=1 width=186) (actual time=1.714..1.714 rows=0 loops=1)

  • Join Filter: (creditnote.originatordivision_id = lineitemdivision.id)
8. 1.007 1.714 ↓ 0.0 0 1

Nested Loop (cost=0.43..11,781.29 rows=1 width=174) (actual time=1.713..1.714 rows=0 loops=1)

9. 0.707 0.707 ↑ 1.0 1,411 1

Seq Scan on suppliercreditnote creditnote (cost=0.00..78.96 rows=1,411 width=158) (actual time=0.007..0.707 rows=1,411 loops=1)

  • Filter: (nettingbundle_id IS NULL)
  • Rows Removed by Filter: 685
10. 0.000 0.000 ↓ 0.0 0 1,411

Index Scan using earlypaymentsettlement_invoice_idx on earlypaymentsettlement financedinvoiceeps (cost=0.43..8.29 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=1,411)

  • Index Cond: (invoice_id = creditnote.referencedinvoice_id)
  • Filter: (creationdate >= '2018-10-11'::date)
11. 0.000 0.000 ↓ 0.0 0

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

12. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = lineitemdivision.buyer_id)
13. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = creditnote.supplier_id)
14. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (creditnote.importbatch_id = id)
15. 0.000 0.000 ↓ 0.0 0

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

16. 0.000 0.000 ↓ 0.0 0

Index Scan using supplierinvoice_pkey on supplierinvoice referencedinvoice (cost=0.43..0.64 rows=1 width=38) (never executed)

  • Index Cond: (id = financedinvoiceeps.invoice_id)
17. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (id = financedinvoiceeps.id)
  • Heap Fetches: 0
Planning time : 4.331 ms
Execution time : 1.845 ms