explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ayOF

Settings
# exclusive inclusive rows x rows loops node
1. 0.667 11.472 ↓ 6.0 426 1

Nested Loop (cost=3.26..25,937.75 rows=71 width=3,082) (actual time=0.131..11.472 rows=426 loops=1)

  • Join Filter: (lineitemnettingbundle.surplus_id = surplusinvoice.id)
2. 0.263 9.953 ↓ 5.8 426 1

Nested Loop (cost=2.83..25,889.71 rows=74 width=1,338) (actual time=0.118..9.953 rows=426 loops=1)

3. 0.549 8.838 ↑ 4.3 426 1

Nested Loop (cost=2.41..25,088.08 rows=1,826 width=1,346) (actual time=0.108..8.838 rows=426 loops=1)

4. 0.392 7.437 ↑ 4.9 426 1

Merge Join (cost=1.97..7,453.43 rows=2,096 width=1,330) (actual time=0.098..7.437 rows=426 loops=1)

  • Merge Cond: (creditnote.nettingbundle_id = lineitemnettingbundle.id)
5. 0.489 6.860 ↑ 4.9 427 1

Nested Loop Left Join (cost=1.70..36,489.61 rows=2,096 width=1,322) (actual time=0.087..6.860 rows=427 loops=1)

6. 0.435 6.371 ↑ 4.9 427 1

Nested Loop Left Join (cost=1.27..19,266.63 rows=2,096 width=1,292) (actual time=0.083..6.371 rows=427 loops=1)

  • Join Filter: (creditnote.currency_id = lineitemcurrency.id)
7. 0.422 5.936 ↑ 4.9 427 1

Nested Loop Left Join (cost=1.27..19,099.35 rows=2,096 width=784) (actual time=0.077..5.936 rows=427 loops=1)

8. 0.420 4.660 ↑ 4.9 427 1

Nested Loop Left Join (cost=0.84..1,996.15 rows=2,096 width=784) (actual time=0.067..4.660 rows=427 loops=1)

9. 1.892 3.386 ↑ 4.9 427 1

Nested Loop (cost=0.56..654.19 rows=2,096 width=774) (actual time=0.062..3.386 rows=427 loops=1)

  • Join Filter: (lineitemdivision.id = creditnote.originatordivision_id)
  • Rows Removed by Join Filter: 5539
10. 0.213 0.213 ↑ 4.9 427 1

Index Scan using suppliercreditnote_nettingbundle_idx on suppliercreditnote creditnote (cost=0.28..124.72 rows=2,096 width=158) (actual time=0.012..0.213 rows=427 loops=1)

11. 1.212 1.281 ↑ 1.0 14 427

Materialize (cost=0.28..89.35 rows=14 width=632) (actual time=0.000..0.003 rows=14 loops=427)

12. 0.017 0.069 ↑ 1.0 14 1

Nested Loop Left Join (cost=0.28..89.28 rows=14 width=632) (actual time=0.015..0.069 rows=14 loops=1)

13. 0.010 0.010 ↑ 1.0 14 1

Seq Scan on divisionbase lineitemdivision (cost=0.00..1.14 rows=14 width=622) (actual time=0.005..0.010 rows=14 loops=1)

14. 0.042 0.042 ↑ 1.0 1 14

Index Scan using corporatebase_pkey on corporatebase lineitembuyer (cost=0.28..6.29 rows=1 width=26) (actual time=0.003..0.003 rows=1 loops=14)

  • Index Cond: (id = lineitemdivision.buyer_id)
15. 0.854 0.854 ↑ 1.0 1 427

Index Scan using corporatebase_pkey on corporatebase lineitemsupplier (cost=0.28..0.64 rows=1 width=26) (actual time=0.002..0.002 rows=1 loops=427)

  • Index Cond: (id = creditnote.supplier_id)
16. 0.854 0.854 ↑ 1.0 1 427

Index Scan using arpimportbatch_pkey on arpimportbatch lineitemimportbatch (cost=0.43..8.16 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=427)

  • Index Cond: (creditnote.importbatch_id = id)
17. 0.000 0.000 ↑ 6.0 1 427

Materialize (cost=0.00..1.09 rows=6 width=524) (actual time=0.000..0.000 rows=1 loops=427)

18. 0.003 0.003 ↑ 6.0 1 1

Seq Scan on crxcurrency lineitemcurrency (cost=0.00..1.06 rows=6 width=524) (actual time=0.002..0.003 rows=1 loops=1)

19. 0.000 0.000 ↓ 0.0 0 427

Index Scan using supplierinvoice_pkey on supplierinvoice referencedinvoice (cost=0.43..8.21 rows=1 width=38) (actual time=0.000..0.000 rows=0 loops=427)

  • Index Cond: (id = creditnote.referencedinvoice_id)
20. 0.185 0.185 ↑ 1.0 410 1

Index Scan using nettingbundle_pkey on nettingbundle lineitemnettingbundle (cost=0.27..29.42 rows=410 width=16) (actual time=0.008..0.185 rows=410 loops=1)

21. 0.852 0.852 ↑ 1.0 1 426

Index Scan using earlypaymentsettlement_invoice_idx on earlypaymentsettlement financedinvoiceeps (cost=0.43..8.41 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=426)

  • Index Cond: (invoice_id = lineitemnettingbundle.surplus_id)
  • Filter: (creationdate >= '2018-10-11'::date)
22. 0.852 0.852 ↑ 1.0 1 426

Index Only Scan using ddearlypaymentsettlement_pkey on ddearlypaymentsettlement financedinvoiceddeps (cost=0.42..0.44 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=426)

  • Index Cond: (id = financedinvoiceeps.id)
  • Heap Fetches: 426
23. 0.852 0.852 ↑ 1.0 1 426

Index Only Scan using supplierinvoice_pkey on supplierinvoice surplusinvoice (cost=0.43..0.64 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=426)

  • Index Cond: (id = financedinvoiceeps.invoice_id)
  • Heap Fetches: 426
Planning time : 4.049 ms
Execution time : 11.731 ms