explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D9Fc

Settings
# exclusive inclusive rows x rows loops node
1. 14.836 1,095.915 ↑ 20.0 7,766 1

Gather (cost=11,066.03..342,215.78 rows=155,676 width=2,333) (actual time=1,037.649..1,095.915 rows=7,766 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 1.774 1,081.079 ↑ 25.1 1,553 5 / 5

Hash Left Join (cost=10,066.03..325,648.18 rows=38,919 width=2,333) (actual time=1,031.803..1,081.079 rows=1,553 loops=5)

  • Hash Cond: (financedinvoiceeps.id = financedinvoicebcddeps.id)
3. 2.909 1,079.299 ↑ 25.1 1,553 5 / 5

Parallel Hash Left Join (cost=10,014.40..325,397.09 rows=38,919 width=1,521) (actual time=1,031.775..1,079.299 rows=1,553 loops=5)

  • Hash Cond: (financedinvoiceeps.id = financedinvoicescddeps.id)
4. 1.425 1,026.867 ↑ 25.1 1,553 5 / 5

Hash Left Join (cost=5,226.60..320,507.12 rows=38,919 width=1,513) (actual time=981.378..1,026.867 rows=1,553 loops=5)

  • Hash Cond: (invoice.nettingbundle_id = lineitemnettingbundle.id)
  • Filter: ((invoice.nettingbundle_id IS NULL) OR (invoice.id = lineitemnettingbundle.surplus_id))
5. 1.425 1,025.142 ↑ 25.1 1,553 5 / 5

Hash Left Join (cost=5,213.37..320,391.70 rows=38,932 width=1,521) (actual time=981.060..1,025.142 rows=1,553 loops=5)

  • Hash Cond: (invoice.currency_id = lineitemcurrency.id)
6. 1.566 1,023.698 ↑ 25.1 1,553 5 / 5

Nested Loop Left Join (cost=5,212.24..320,216.18 rows=38,932 width=1,013) (actual time=981.021..1,023.698 rows=1,553 loops=5)

7. 3.098 1,017.472 ↑ 25.1 1,553 5 / 5

Hash Left Join (cost=5,211.80..300,847.12 rows=38,932 width=1,013) (actual time=980.998..1,017.472 rows=1,553 loops=5)

  • Hash Cond: (invoice.supplier_id = lineitemsupplier.id)
8. 1.437 1,012.890 ↑ 25.1 1,553 5 / 5

Hash Left Join (cost=5,000.68..300,533.54 rows=38,932 width=1,003) (actual time=979.493..1,012.890 rows=1,553 loops=5)

  • Hash Cond: (lineitemdivision.buyer_id = lineitembuyer.id)
9. 2.254 1,008.166 ↑ 25.1 1,553 5 / 5

Hash Join (cost=4,789.55..300,219.95 rows=38,932 width=993) (actual time=976.179..1,008.166 rows=1,553 loops=5)

  • Hash Cond: (invoice.originatordivision_id = lineitemdivision.id)
10. 2.033 1,005.880 ↑ 25.1 1,553 5 / 5

Nested Loop (cost=4,788.24..300,085.50 rows=38,932 width=387) (actual time=976.124..1,005.880 rows=1,553 loops=5)

11. 406.667 999.187 ↑ 25.1 1,553 5 / 5

Parallel Hash Join (cost=4,787.81..272,127.48 rows=38,932 width=196) (actual time=976.087..999.187 rows=1,553 loops=5)

  • Hash Cond: (financedinvoiceeps.id = financedinvoiceddeps.id)
12. 537.538 537.538 ↑ 1.2 773,059 5 / 5

Parallel Seq Scan on earlypaymentsettlement financedinvoiceeps (cost=0.00..264,805.63 rows=965,351 width=196) (actual time=0.006..537.538 rows=773,059 loops=5)

  • Filter: (creationdate >= '2019-01-25'::date)
  • Rows Removed by Filter: 500454
13. 35.578 54.982 ↑ 2.9 51,360 5 / 5

Parallel Hash (cost=2,899.58..2,899.58 rows=151,058 width=8) (actual time=54.982..54.982 rows=51,360 loops=5)

  • Buckets: 262144 Batches: 1 Memory Usage: 12192kB
14. 19.404 19.404 ↑ 2.9 51,360 5 / 5

Parallel Seq Scan on ddearlypaymentsettlement financedinvoiceddeps (cost=0.00..2,899.58 rows=151,058 width=8) (actual time=0.008..19.404 rows=51,360 loops=5)

15. 4.660 4.660 ↑ 1.0 1 7,766 / 5

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

  • Index Cond: (id = financedinvoiceeps.invoice_id)
16. 0.012 0.032 ↑ 1.0 14 5 / 5

Hash (cost=1.14..1.14 rows=14 width=622) (actual time=0.032..0.032 rows=14 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.020 0.020 ↑ 1.0 14 5 / 5

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

18. 0.698 3.287 ↑ 1.0 1,650 5 / 5

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
19. 2.589 2.589 ↑ 1.0 1,650 5 / 5

Seq Scan on corporatebase lineitembuyer (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.021..2.589 rows=1,650 loops=5)

20. 0.670 1.484 ↑ 1.0 1,650 5 / 5

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

  • Buckets: 2048 Batches: 1 Memory Usage: 119kB
21. 0.814 0.814 ↑ 1.0 1,650 5 / 5

Seq Scan on corporatebase lineitemsupplier (cost=0.00..190.50 rows=1,650 width=26) (actual time=0.003..0.814 rows=1,650 loops=5)

22. 4.660 4.660 ↑ 1.0 1 7,766 / 5

Index Scan using arpimportbatch_pkey on arpimportbatch lineitemimportbatch (cost=0.43..0.50 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=7,766)

  • Index Cond: (invoice.importbatch_id = id)
23. 0.007 0.019 ↑ 1.0 6 5 / 5

Hash (cost=1.06..1.06 rows=6 width=524) (actual time=0.019..0.019 rows=6 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.012 0.012 ↑ 1.0 6 5 / 5

Seq Scan on crxcurrency lineitemcurrency (cost=0.00..1.06 rows=6 width=524) (actual time=0.010..0.012 rows=6 loops=5)

25. 0.151 0.300 ↑ 1.0 410 5 / 5

Hash (cost=8.10..8.10 rows=410 width=16) (actual time=0.300..0.300 rows=410 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
26. 0.149 0.149 ↑ 1.0 410 5 / 5

Seq Scan on nettingbundle lineitemnettingbundle (cost=0.00..8.10 rows=410 width=16) (actual time=0.006..0.149 rows=410 loops=5)

27. 29.365 49.523 ↑ 2.9 51,360 5 / 5

Parallel Hash (cost=2,899.58..2,899.58 rows=151,058 width=8) (actual time=49.523..49.523 rows=51,360 loops=5)

  • Buckets: 262144 Batches: 1 Memory Usage: 12192kB
28. 20.158 20.158 ↑ 2.9 51,360 5 / 5

Parallel Seq Scan on ddsuppliercentricearlypaymentsettlement financedinvoicescddeps (cost=0.00..2,899.58 rows=151,058 width=8) (actual time=0.008..20.158 rows=51,360 loops=5)

29. 0.001 0.006 ↓ 0.0 0 5 / 5

Hash (cost=28.50..28.50 rows=1,850 width=8) (actual time=0.005..0.006 rows=0 loops=5)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
30. 0.005 0.005 ↓ 0.0 0 5 / 5

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

Planning time : 6.941 ms
Execution time : 1,098.594 ms