explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2lUr

Settings
# exclusive inclusive rows x rows loops node
1. 15.957 655.148 ↑ 10.9 1,831 1

Gather (cost=266,569.90..277,391.22 rows=20,020 width=3,113) (actual time=639.698..655.148 rows=1,831 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 1.136 639.191 ↑ 13.7 366 5 / 5

Parallel Hash Join (cost=265,569.90..274,389.22 rows=5,005 width=3,113) (actual time=629.956..639.191 rows=366 loops=5)

  • Hash Cond: (financedinvoiceeps.id = financedinvoiceddeps.id)
3. 1.855 585.071 ↑ 339.1 366 5 / 5

Parallel Hash Join (cost=260,782.10..269,263.12 rows=124,106 width=1,333) (actual time=576.356..585.071 rows=366 loops=5)

  • Hash Cond: (surplusinvoice.id = financedinvoiceeps.invoice_id)
4. 0.531 10.244 ↑ 4,487.4 366 5 / 5

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

  • Merge Cond: (invoice.nettingbundle_id = lineitemnettingbundle.id)
  • Join Filter: (invoice.id <> lineitemnettingbundle.surplus_id)
  • Rows Removed by Join Filter: 82
5. 0.756 7.759 ↑ 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.112..7.759 rows=449 loops=5)

6. 0.568 5.206 ↑ 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.100..5.206 rows=449 loops=5)

7. 0.499 4.189 ↑ 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.087..4.189 rows=449 loops=5)

8. 0.387 2.792 ↑ 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.071..2.792 rows=449 loops=5)

9. 0.809 1.507 ↑ 3,657.9 449 5 / 5

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

10. 0.249 0.249 ↑ 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.029..0.249 rows=449 loops=5)

11. 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)
12. 0.898 0.898 ↑ 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.002..0.002 rows=1 loops=2,246)

  • Index Cond: (id = invoice.supplier_id)
13. 0.898 0.898 ↑ 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.002..0.002 rows=1 loops=2,246)

  • Index Cond: (invoice.importbatch_id = id)
14. 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)
15. 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)
16. 0.403 1.954 ↓ 1.6 661 5 / 5

Sort (cost=3,474.39..3,475.42 rows=410 width=24) (actual time=1.761..1.954 rows=661 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
17. 0.587 1.551 ↑ 1.0 410 5 / 5

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

18. 0.144 0.144 ↑ 1.0 410 5 / 5

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

19. 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: 2,050
20. 54.789 572.972 ↑ 1.2 99,511 5 / 5

Parallel Hash (cost=255,754.03..255,754.03 rows=124,106 width=16) (actual time=572.972..572.972 rows=99,511 loops=5)

  • Buckets: 524,288 Batches: 1 Memory Usage: 27,520kB
21. 507.009 518.183 ↑ 1.2 99,511 5 / 5

Parallel Bitmap Heap Scan on earlypaymentsettlement financedinvoiceeps (cost=9,295.71..255,754.03 rows=124,106 width=16) (actual time=104.759..518.183 rows=99,511 loops=5)

  • Recheck Cond: (creationdate >= '2019-02-01'::date)
  • Heap Blocks: exact=39,256
22. 11.174 11.174 ↓ 1.0 497,554 1 / 5

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

  • Index Cond: (creationdate >= '2019-02-01'::date)
23. 29.031 52.984 ↑ 2.9 51,360 5 / 5

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

  • Buckets: 262,144 Batches: 1 Memory Usage: 12,192kB
24. 23.953 23.953 ↑ 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.953 rows=51,360 loops=5)

Planning time : 4.282 ms
Execution time : 655.848 ms