explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yyS0

Settings
# exclusive inclusive rows x rows loops node
1. 12.568 1,454.604 ↑ 122.2 1,831 1

Gather (cost=278,408.88..311,384.67 rows=223,675 width=3,113) (actual time=1,437.048..1,454.604 rows=1,831 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 1.152 1,442.036 ↑ 152.8 366 5 / 5

Parallel Hash Join (cost=277,408.88..288,017.17 rows=55,919 width=3,113) (actual time=1,431.356..1,442.036 rows=366 loops=5)

  • Hash Cond: (surplusinvoice.id = financedinvoiceeps.invoice_id)
3. 1.240 12.562 ↑ 4,487.4 366 5 / 5

Merge Join (cost=3,476.74..7,646.52 rows=1,642,376 width=1,341) (actual time=2.400..12.562 rows=366 loops=5)

  • Merge Cond: (invoice.nettingbundle_id = lineitemnettingbundle.id)
  • Join Filter: (invoice.id <> lineitemnettingbundle.surplus_id)
  • Rows Removed by Join Filter: 82
4. 0.621 9.377 ↑ 3,657.9 449 5 / 5

Nested Loop Left Join (cost=1.69..12,489,257.95 rows=1,642,376 width=1,333) (actual time=0.567..9.377 rows=449 loops=5)

5. 0.575 6.959 ↑ 3,657.9 449 5 / 5

Nested Loop Left Join (cost=1.41..2,156,481.18 rows=1,642,376 width=1,323) (actual time=0.555..6.959 rows=449 loops=5)

6. 0.856 5.935 ↑ 3,657.9 449 5 / 5

Nested Loop Left Join (cost=1.28..1,912,761.67 rows=1,642,376 width=815) (actual time=0.542..5.935 rows=449 loops=5)

7. 0.824 3.731 ↑ 3,657.9 449 5 / 5

Nested Loop Left Join (cost=0.84..1,095,663.47 rows=1,642,376 width=815) (actual time=0.523..3.731 rows=449 loops=5)

8. 0.845 2.458 ↑ 3,657.9 449 5 / 5

Nested Loop (cost=0.57..610,999.04 rows=1,642,376 width=805) (actual time=0.506..2.458 rows=449 loops=5)

9. 1.164 1.164 ↑ 3,657.9 449 5 / 5

Parallel Index Scan using supplierinvoice_nettingbundle_idx on supplierinvoice invoice (cost=0.43..362,156.71 rows=1,642,376 width=199) (actual time=0.481..1.164 rows=449 loops=5)

10. 0.449 0.449 ↑ 1.0 1 2,246 / 5

Index Scan using divisionbase_pkey on divisionbase lineitemdivision (cost=0.14..0.15 rows=1 width=622) (actual time=0.001..0.001 rows=1 loops=2,246)

  • Index Cond: (id = invoice.originatordivision_id)
11. 0.449 0.449 ↑ 1.0 1 2,246 / 5

Index Scan using corporatebase_pkey on corporatebase lineitemsupplier (cost=0.28..0.30 rows=1 width=26) (actual time=0.001..0.001 rows=1 loops=2,246)

  • Index Cond: (id = invoice.supplier_id)
12. 1.348 1.348 ↑ 1.0 1 2,246 / 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=2,246)

  • Index Cond: (invoice.importbatch_id = id)
13. 0.449 0.449 ↑ 1.0 1 2,246 / 5

Index Scan using crxcurrency_pkey on crxcurrency lineitemcurrency (cost=0.13..0.15 rows=1 width=524) (actual time=0.001..0.001 rows=1 loops=2,246)

  • Index Cond: (invoice.currency_id = id)
14. 1.797 1.797 ↑ 1.0 1 2,246 / 5

Index Scan using corporatebase_pkey on corporatebase lineitembuyer (cost=0.28..6.29 rows=1 width=26) (actual time=0.004..0.004 rows=1 loops=2,246)

  • Index Cond: (id = lineitemdivision.buyer_id)
15. 0.404 1.945 ↓ 1.6 649 5 / 5

Sort (cost=3,474.39..3,475.42 rows=410 width=24) (actual time=1.747..1.945 rows=649 loops=5)

  • Sort Key: lineitemnettingbundle.id
  • Sort Method: quicksort Memory: 57kB
  • Worker 0: Sort Method: quicksort Memory: 57kB
  • Worker 1: Sort Method: quicksort Memory: 57kB
  • Worker 2: Sort Method: quicksort Memory: 57kB
  • Worker 3: Sort Method: quicksort Memory: 57kB
16. 0.582 1.541 ↑ 1.0 410 5 / 5

Nested Loop (cost=0.43..3,456.60 rows=410 width=24) (actual time=0.029..1.541 rows=410 loops=5)

17. 0.139 0.139 ↑ 1.0 410 5 / 5

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

18. 0.820 0.820 ↑ 1.0 1 2,050 / 5

Index Only Scan using supplierinvoice_pkey on supplierinvoice surplusinvoice (cost=0.43..8.41 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=2,050)

  • Index Cond: (id = lineitemnettingbundle.surplus_id)
  • Heap Fetches: 2050
19. 14.216 1,428.322 ↑ 2.8 19,832 5 / 5

Parallel Hash (cost=273,233.15..273,233.15 rows=55,919 width=8) (actual time=1,428.322..1,428.322 rows=19,832 loops=5)

  • Buckets: 262144 Batches: 1 Memory Usage: 5984kB
20. 640.332 1,414.106 ↑ 2.8 19,832 5 / 5

Parallel Hash Join (cost=4,787.81..273,233.15 rows=55,919 width=8) (actual time=1,357.452..1,414.106 rows=19,832 loops=5)

  • Hash Cond: (financedinvoiceeps.id = financedinvoiceddeps.id)
21. 721.327 721.327 ↑ 1.2 1,111,693 5 / 5

Parallel Seq Scan on earlypaymentsettlement financedinvoiceeps (cost=0.00..264,805.63 rows=1,386,556 width=16) (actual time=0.007..721.327 rows=1,111,693 loops=5)

  • Filter: (creationdate >= '2018-10-11'::date)
  • Rows Removed by Filter: 161820
22. 28.989 52.447 ↑ 2.9 51,360 5 / 5

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

  • Buckets: 262144 Batches: 1 Memory Usage: 12192kB
23. 23.458 23.458 ↑ 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.007..23.458 rows=51,360 loops=5)

Planning time : 4.414 ms
Execution time : 1,455.654 ms