explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vERl

Settings
# exclusive inclusive rows x rows loops node
1. 0.613 11.204 ↓ 6.0 426 1

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

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

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

3. 0.474 8.609 ↑ 4.3 426 1

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

4. 0.401 7.283 ↑ 4.9 426 1

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

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

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

6. 0.440 6.229 ↑ 4.9 427 1

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

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

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

8. 0.335 4.528 ↑ 4.9 427 1

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

9. 1.863 3.339 ↑ 4.9 427 1

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

  • Join Filter: (lineitemdivision.id = creditnote.originatordivision_id)
  • Rows Removed by Join Filter: 5539
10. 0.195 0.195 ↑ 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.009..0.195 rows=427 loops=1)

11. 1.215 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.025 0.066 ↑ 1.0 14 1

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

13. 0.013 0.013 ↑ 1.0 14 1

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

14. 0.028 0.028 ↑ 1.0 1 14

Index Scan using corporatebase_pkey on corporatebase lineitembuyer (cost=0.28..6.29 rows=1 width=26) (actual time=0.002..0.002 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.002 0.002 ↑ 6.0 1 1

Seq Scan on crxcurrency lineitemcurrency (cost=0.00..1.06 rows=6 width=524) (actual time=0.002..0.002 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.171 0.171 ↑ 1.0 410 1

Index Scan using nettingbundle_pkey on nettingbundle lineitemnettingbundle (cost=0.27..29.42 rows=410 width=16) (actual time=0.007..0.171 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 : 3.775 ms
Execution time : 11.431 ms