explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yN2a

Settings
# exclusive inclusive rows x rows loops node
1. 22.270 845.735 ↑ 1.6 878 1

Gather (cost=258,593.25..292,755.09 rows=1,430 width=2,333) (actual time=799.926..845.735 rows=878 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 0.478 823.465 ↑ 1.9 439 2 / 2

Hash Left Join (cost=257,593.25..291,612.09 rows=841 width=2,333) (actual time=795.975..823.465 rows=439 loops=2)

  • Hash Cond: (invoice.nettingbundle_id = lineitemnettingbundle.id)
  • Filter: ((invoice.nettingbundle_id IS NULL) OR (invoice.id = lineitemnettingbundle.surplus_id))
3. 0.352 822.681 ↑ 1.9 439 2 / 2

Hash Left Join (cost=257,580.02..291,594.55 rows=841 width=1,529) (actual time=795.652..822.681 rows=439 loops=2)

  • Hash Cond: (financedinvoiceeps.id = financedinvoicebcddeps.id)
4. 0.566 822.322 ↑ 1.9 439 2 / 2

Nested Loop Left Join (cost=257,528.40..291,540.72 rows=841 width=1,529) (actual time=795.629..822.322 rows=439 loops=2)

5. 0.368 819.561 ↑ 1.9 439 2 / 2

Hash Left Join (cost=257,527.98..291,158.58 rows=841 width=1,521) (actual time=794.767..819.561 rows=439 loops=2)

  • Hash Cond: (invoice.currency_id = lineitemcurrency.id)
6. 0.497 819.179 ↑ 1.9 439 2 / 2

Nested Loop Left Join (cost=257,526.84..291,153.68 rows=841 width=1,013) (actual time=794.740..819.179 rows=439 loops=2)

7. 0.364 817.804 ↑ 1.9 439 2 / 2

Hash Left Join (cost=257,526.41..290,735.27 rows=841 width=1,013) (actual time=794.722..817.804 rows=439 loops=2)

  • Hash Cond: (invoice.supplier_id = lineitemsupplier.id)
8. 0.381 815.602 ↑ 1.9 439 2 / 2

Hash Left Join (cost=257,315.29..290,521.93 rows=841 width=1,003) (actual time=792.871..815.602 rows=439 loops=2)

  • Hash Cond: (lineitemdivision.buyer_id = lineitembuyer.id)
9. 1.434 815.164 ↑ 1.9 439 2 / 2

Hash Join (cost=257,306.98..290,502.06 rows=841 width=993) (actual time=792.790..815.164 rows=439 loops=2)

  • Hash Cond: (invoice.originatordivision_id = lineitemdivision.id)
10. 4.191 813.710 ↑ 3.0 3,883 2 / 2

Nested Loop (cost=257,305.79..290,460.60 rows=11,776 width=387) (actual time=696.963..813.710 rows=3,883 loops=2)

11. 70.563 801.753 ↑ 3.0 3,883 2 / 2

Parallel Hash Join (cost=257,305.36..260,601.47 rows=11,776 width=196) (actual time=696.937..801.753 rows=3,883 loops=2)

  • Hash Cond: (financedinvoiceddeps.id = financedinvoiceeps.id)
12. 35.830 35.830 ↑ 1.2 128,400 2 / 2

Parallel Seq Scan on ddearlypaymentsettlement financedinvoiceddeps (cost=0.00..2,899.58 rows=151,058 width=8) (actual time=0.009..35.830 rows=128,400 loops=2)

13. 230.730 695.360 ↓ 2.0 248,777 2 / 2

Parallel Hash (cost=255,754.03..255,754.03 rows=124,106 width=196) (actual time=695.360..695.360 rows=248,777 loops=2)

  • Buckets: 524288 Batches: 1 Memory Usage: 117024kB
14. 436.754 464.630 ↓ 2.0 248,777 2 / 2

Parallel Bitmap Heap Scan on earlypaymentsettlement financedinvoiceeps (cost=9,295.71..255,754.03 rows=124,106 width=196) (actual time=102.291..464.630 rows=248,777 loops=2)

  • Recheck Cond: (creationdate >= '2019-02-01'::date)
  • Heap Blocks: exact=94197
15. 27.876 27.876 ↓ 1.0 497,554 1 / 2

Bitmap Index Scan on earlypaymentsettlement_creationdate_idx (cost=0.00..9,171.61 rows=496,423 width=0) (actual time=55.752..55.752 rows=497,554 loops=1)

  • Index Cond: (creationdate >= '2019-02-01'::date)
16. 7.766 7.766 ↑ 1.0 1 7,766 / 2

Index Scan using supplierinvoice_pkey on supplierinvoice invoice (cost=0.43..2.54 rows=1 width=199) (actual time=0.002..0.002 rows=1 loops=7,766)

  • Index Cond: (id = financedinvoiceeps.invoice_id)
17. 0.005 0.020 ↑ 1.0 1 2 / 2

Hash (cost=1.18..1.18 rows=1 width=622) (actual time=0.020..0.020 rows=1 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
18. 0.015 0.015 ↑ 1.0 1 2 / 2

Seq Scan on divisionbase lineitemdivision (cost=0.00..1.18 rows=1 width=622) (actual time=0.014..0.015 rows=1 loops=2)

  • Filter: (buyer_id = 66895525)
  • Rows Removed by Filter: 13
19. 0.004 0.057 ↑ 1.0 1 2 / 2

Hash (cost=8.29..8.29 rows=1 width=26) (actual time=0.057..0.057 rows=1 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
20. 0.053 0.053 ↑ 1.0 1 2 / 2

Index Scan using corporatebase_pkey on corporatebase lineitembuyer (cost=0.28..8.29 rows=1 width=26) (actual time=0.052..0.053 rows=1 loops=2)

  • Index Cond: (id = 66895525)
21. 0.676 1.838 ↑ 1.0 1,650 2 / 2

Hash (cost=190.50..190.50 rows=1,650 width=26) (actual time=1.838..1.838 rows=1,650 loops=2)

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
22. 1.162 1.162 ↑ 1.0 1,650 2 / 2

Seq Scan on corporatebase lineitemsupplier (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.015..1.162 rows=1,650 loops=2)

23. 0.878 0.878 ↑ 1.0 1 878 / 2

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

  • Index Cond: (invoice.importbatch_id = id)
24. 0.006 0.014 ↑ 1.0 6 2 / 2

Hash (cost=1.06..1.06 rows=6 width=524) (actual time=0.014..0.014 rows=6 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
25. 0.008 0.008 ↑ 1.0 6 2 / 2

Seq Scan on crxcurrency lineitemcurrency (cost=0.00..1.06 rows=6 width=524) (actual time=0.006..0.008 rows=6 loops=2)

26. 2.195 2.195 ↑ 1.0 1 878 / 2

Index Only Scan using ddsuppliercentricearlypaymentsettlement_pkey on ddsuppliercentricearlypaymentsettlement financedinvoicescddeps (cost=0.42..0.45 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=878)

  • Index Cond: (id = financedinvoiceeps.id)
  • Heap Fetches: 878
27. 0.000 0.007 ↓ 0.0 0 2 / 2

Hash (cost=28.50..28.50 rows=1,850 width=8) (actual time=0.007..0.007 rows=0 loops=2)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
28. 0.007 0.007 ↓ 0.0 0 2 / 2

Seq Scan on ddbuyercentricearlypaymentsettlement financedinvoicebcddeps (cost=0.00..28.50 rows=1,850 width=8) (actual time=0.006..0.007 rows=0 loops=2)

29. 0.158 0.306 ↑ 1.0 410 2 / 2

Hash (cost=8.10..8.10 rows=410 width=16) (actual time=0.306..0.306 rows=410 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
30. 0.148 0.148 ↑ 1.0 410 2 / 2

Seq Scan on nettingbundle lineitemnettingbundle (cost=0.00..8.10 rows=410 width=16) (actual time=0.007..0.148 rows=410 loops=2)

Planning time : 4.712 ms
Execution time : 846.198 ms