explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Dfj

Settings
# exclusive inclusive rows x rows loops node
1. 29.466 931.780 ↑ 2.6 7,766 1

Gather (cost=263,460.59..304,842.75 rows=20,013 width=2,333) (actual time=754.147..931.780 rows=7,766 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 4.135 902.314 ↑ 3.0 3,883 2 / 2

Hash Left Join (cost=262,460.59..301,841.45 rows=11,772 width=2,333) (actual time=750.090..902.314 rows=3,883 loops=2)

  • Hash Cond: (financedinvoiceeps.id = financedinvoicebcddeps.id)
3. 4.925 898.174 ↑ 3.0 3,883 2 / 2

Parallel Hash Left Join (cost=262,408.97..301,729.50 rows=11,772 width=1,521) (actual time=750.065..898.174 rows=3,883 loops=2)

  • Hash Cond: (financedinvoiceeps.id = financedinvoicescddeps.id)
4. 3.203 782.800 ↑ 3.0 3,883 2 / 2

Hash Left Join (cost=257,621.16..296,910.79 rows=11,772 width=1,513) (actual time=638.743..782.800 rows=3,883 loops=2)

  • Hash Cond: (invoice.nettingbundle_id = lineitemnettingbundle.id)
  • Filter: ((invoice.nettingbundle_id IS NULL) OR (invoice.id = lineitemnettingbundle.surplus_id))
5. 3.213 779.313 ↑ 3.0 3,883 2 / 2

Hash Left Join (cost=257,607.93..296,866.65 rows=11,776 width=1,521) (actual time=638.441..779.313 rows=3,883 loops=2)

  • Hash Cond: (invoice.currency_id = lineitemcurrency.id)
6. 4.626 776.082 ↑ 3.0 3,883 2 / 2

Nested Loop Left Join (cost=257,606.80..296,812.77 rows=11,776 width=1,013) (actual time=638.406..776.082 rows=3,883 loops=2)

7. 3.360 759.807 ↑ 3.0 3,883 2 / 2

Hash Left Join (cost=257,606.37..290,954.09 rows=11,776 width=1,013) (actual time=637.332..759.807 rows=3,883 loops=2)

  • Hash Cond: (invoice.supplier_id = lineitemsupplier.id)
8. 3.544 754.713 ↑ 3.0 3,883 2 / 2

Hash Join (cost=257,395.24..290,711.97 rows=11,776 width=1,003) (actual time=635.577..754.713 rows=3,883 loops=2)

  • Hash Cond: (invoice.originatordivision_id = lineitemdivision.id)
9. 6.225 751.076 ↑ 3.0 3,883 2 / 2

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

10. 65.085 737.085 ↑ 3.0 3,883 2 / 2

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

  • Hash Cond: (financedinvoiceddeps.id = financedinvoiceeps.id)
11. 37.721 37.721 ↑ 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.007..37.721 rows=128,400 loops=2)

12. 216.086 634.279 ↓ 2.0 248,777 2 / 2

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

  • Buckets: 524288 Batches: 1 Memory Usage: 117056kB
13. 391.648 418.193 ↓ 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=98.407..418.193 rows=248,777 loops=2)

  • Recheck Cond: (creationdate >= '2019-02-01'::date)
  • Heap Blocks: exact=93358
14. 26.545 26.545 ↓ 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=53.090..53.090 rows=497,554 loops=1)

  • Index Cond: (creationdate >= '2019-02-01'::date)
15. 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)
16. 0.013 0.093 ↑ 1.0 14 2 / 2

Hash (cost=89.28..89.28 rows=14 width=632) (actual time=0.093..0.093 rows=14 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.025 0.080 ↑ 1.0 14 2 / 2

Nested Loop Left Join (cost=0.28..89.28 rows=14 width=632) (actual time=0.031..0.080 rows=14 loops=2)

18. 0.013 0.013 ↑ 1.0 14 2 / 2

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

19. 0.042 0.042 ↑ 1.0 1 28 / 2

Index Scan using corporatebase_pkey on corporatebase lineitembuyer (cost=0.28..6.29 rows=1 width=26) (actual time=0.003..0.003 rows=1 loops=28)

  • Index Cond: (id = lineitemdivision.buyer_id)
20. 0.678 1.734 ↑ 1.0 1,650 2 / 2

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

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

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

22. 11.649 11.649 ↑ 1.0 1 7,766 / 2

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.018 ↑ 1.0 6 2 / 2

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

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

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

25. 0.139 0.284 ↑ 1.0 410 2 / 2

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

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

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

27. 49.265 110.449 ↑ 1.2 128,399 2 / 2

Parallel Hash (cost=2,899.58..2,899.58 rows=151,058 width=8) (actual time=110.449..110.449 rows=128,399 loops=2)

  • Buckets: 262144 Batches: 1 Memory Usage: 12096kB
28. 61.184 61.184 ↑ 1.2 128,399 2 / 2

Parallel Seq Scan on ddsuppliercentricearlypaymentsettlement financedinvoicescddeps (cost=0.00..2,899.58 rows=151,058 width=8) (actual time=0.161..61.184 rows=128,399 loops=2)

29. 0.001 0.005 ↓ 0.0 0 2 / 2

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

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

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

Planning time : 4.722 ms
Execution time : 934.141 ms