explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dByj

Settings
# exclusive inclusive rows x rows loops node
1. 800.238 977.042 ↓ 262.5 1,869,058 1

Hash Right Join (cost=6,067.51..6,665.41 rows=7,120 width=137) (actual time=174.139..977.042 rows=1,869,058 loops=1)

  • Hash Cond: (seller_company.serviced_product_id = sp.serviced_product_id)
2. 2.789 3.558 ↑ 1.0 7,055 1

Bitmap Heap Scan on attribute_to_serviced_product seller_company (cost=135.47..635.47 rows=7,120 width=8) (actual time=0.829..3.558 rows=7,055 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 19)
  • Heap Blocks: exact=381
3. 0.769 0.769 ↑ 1.0 7,055 1

Bitmap Index Scan on fki_serviced_product_attribute_serviced_product_attribute_id (cost=0.00..133.69 rows=7,120 width=0) (actual time=0.769..0.769 rows=7,055 loops=1)

  • Index Cond: (serviced_product_attribute_id = 19)
4. 65.091 173.246 ↓ 15.7 111,618 1

Hash (cost=5,843.42..5,843.42 rows=7,089 width=137) (actual time=173.246..173.246 rows=111,618 loops=1)

  • Buckets: 131,072 (originally 8192) Batches: 8,192 (originally 1) Memory Usage: 11,093kB
5. 37.574 108.155 ↓ 15.7 111,618 1

Hash Right Join (cost=5,246.65..5,843.42 rows=7,089 width=137) (actual time=68.635..108.155 rows=111,618 loops=1)

  • Hash Cond: (central_company.serviced_product_id = sp.serviced_product_id)
6. 2.085 2.820 ↓ 1.0 7,101 1

Bitmap Heap Scan on attribute_to_serviced_product central_company (cost=135.14..634.60 rows=7,077 width=8) (actual time=0.796..2.820 rows=7,101 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 18)
  • Heap Blocks: exact=380
7. 0.735 0.735 ↓ 1.0 7,101 1

Bitmap Index Scan on fki_serviced_product_attribute_serviced_product_attribute_id (cost=0.00..133.37 rows=7,077 width=0) (actual time=0.735..0.735 rows=7,101 loops=1)

  • Index Cond: (serviced_product_attribute_id = 18)
8. 5.571 67.761 ↓ 1.9 13,354 1

Hash (cost=5,022.90..5,022.90 rows=7,089 width=133) (actual time=67.761..67.761 rows=13,354 loops=1)

  • Buckets: 16,384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 1,784kB
9. 5.974 62.190 ↓ 1.9 13,354 1

Hash Right Join (cost=4,431.25..5,022.90 rows=7,089 width=133) (actual time=54.420..62.190 rows=13,354 loops=1)

  • Hash Cond: (user_company.serviced_product_id = sp.serviced_product_id)
10. 1.912 2.607 ↓ 1.0 7,023 1

Bitmap Heap Scan on attribute_to_serviced_product user_company (cost=133.63..630.65 rows=6,882 width=8) (actual time=0.752..2.607 rows=7,023 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 62)
  • Heap Blocks: exact=378
11. 0.695 0.695 ↓ 1.0 7,023 1

Bitmap Index Scan on fki_serviced_product_attribute_serviced_product_attribute_id (cost=0.00..131.91 rows=6,882 width=0) (actual time=0.695..0.695 rows=7,023 loops=1)

  • Index Cond: (serviced_product_attribute_id = 62)
12. 2.920 53.609 ↓ 1.1 7,548 1

Hash (cost=4,209.01..4,209.01 rows=7,089 width=129) (actual time=53.609..53.609 rows=7,548 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 943kB
13. 4.768 50.689 ↓ 1.1 7,548 1

Hash Right Join (cost=3,705.74..4,209.01 rows=7,089 width=129) (actual time=45.063..50.689 rows=7,548 loops=1)

  • Hash Cond: (customer_warranty_date.serviced_product_id = sp.serviced_product_id)
14. 0.973 1.334 ↓ 1.0 3,543 1

Bitmap Heap Scan on attribute_to_serviced_product customer_warranty_date (cost=67.53..522.47 rows=3,515 width=12) (actual time=0.395..1.334 rows=3,543 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 26)
  • Heap Blocks: exact=235
15. 0.361 0.361 ↓ 1.0 3,543 1

Bitmap Index Scan on fki_serviced_product_attribute_serviced_product_attribute_id (cost=0.00..66.66 rows=3,515 width=0) (actual time=0.361..0.361 rows=3,543 loops=1)

  • Index Cond: (serviced_product_attribute_id = 26)
16. 2.637 44.587 ↓ 1.1 7,548 1

Hash (cost=3,549.59..3,549.59 rows=7,089 width=121) (actual time=44.587..44.587 rows=7,548 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 912kB
17. 1.992 41.950 ↓ 1.1 7,548 1

Hash Right Join (cost=3,354.26..3,549.59 rows=7,089 width=121) (actual time=40.009..41.950 rows=7,548 loops=1)

  • Hash Cond: (provider_warranty_date.serviced_product_id = sp.serviced_product_id)
18. 0.021 0.055 ↑ 5.1 15 1

Bitmap Heap Scan on attribute_to_serviced_product provider_warranty_date (cost=4.88..199.17 rows=76 width=12) (actual time=0.043..0.055 rows=15 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 21)
  • Heap Blocks: exact=7
19. 0.034 0.034 ↑ 5.1 15 1

Bitmap Index Scan on fki_serviced_product_attribute_serviced_product_attribute_id (cost=0.00..4.86 rows=76 width=0) (actual time=0.034..0.034 rows=15 loops=1)

  • Index Cond: (serviced_product_attribute_id = 21)
20. 3.262 39.903 ↓ 1.1 7,548 1

Hash (cost=3,260.77..3,260.77 rows=7,089 width=113) (actual time=39.903..39.903 rows=7,548 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 912kB
21. 2.745 36.641 ↓ 1.1 7,548 1

Hash Left Join (cost=2,632.57..3,260.77 rows=7,089 width=113) (actual time=28.368..36.641 rows=7,548 loops=1)

  • Hash Cond: (sp.product_id = p.productid)
22. 3.419 31.360 ↓ 1.1 7,548 1

Hash Right Join (cost=2,449.67..2,980.39 rows=7,089 width=81) (actual time=25.784..31.360 rows=7,548 loops=1)

  • Hash Cond: (last_conservation_date.serviced_product_id = sp.serviced_product_id)
23. 2.266 2.753 ↓ 1.0 4,569 1

Bitmap Heap Scan on attribute_to_serviced_product last_conservation_date (cost=87.64..555.65 rows=4,561 width=12) (actual time=0.535..2.753 rows=4,569 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 23)
  • Heap Blocks: exact=281
24. 0.487 0.487 ↓ 1.0 4,569 1

Bitmap Index Scan on fki_serviced_product_attribute_serviced_product_attribute_id (cost=0.00..86.50 rows=4,561 width=0) (actual time=0.487..0.487 rows=4,569 loops=1)

  • Index Cond: (serviced_product_attribute_id = 23)
25. 2.407 25.188 ↓ 1.0 7,409 1

Hash (cost=2,273.41..2,273.41 rows=7,089 width=73) (actual time=25.188..25.188 rows=7,409 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 586kB
26. 3.982 22.781 ↓ 1.0 7,409 1

Hash Right Join (cost=1,758.59..2,273.41 rows=7,089 width=73) (actual time=17.822..22.781 rows=7,409 loops=1)

  • Hash Cond: (installation_date.serviced_product_id = sp.serviced_product_id)
27. 1.503 1.503 ↑ 1.0 3,878 1

Bitmap Heap Scan on attribute_to_serviced_product installation_date (cost=74.94..535.38 rows=3,955 width=12) (actual time=0.462..1.503 rows=3,878 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 7)
  • Heap Blocks: exact=251
  • -> Bitmap Index Scan on fki_serviced_product_attribute_serviced_product_attribute_id (cost=0.00..73.95 rows=3,955 width=0) (actual time=0.427..0.427 rows=3,878 loops=1
  • Index Cond: (serviced_product_attribute_id = 7)
28. 2.138 17.296 ↓ 1.0 7,111 1

Hash (cost=1,595.04..1,595.04 rows=7,089 width=65) (actual time=17.296..17.296 rows=7,111 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 477kB
29. 2.773 15.158 ↓ 1.0 7,111 1

Hash Right Join (cost=1,083.13..1,595.04 rows=7,089 width=65) (actual time=10.209..15.158 rows=7,111 loops=1)

  • Hash Cond: (sell_date.serviced_product_id = sp.serviced_product_id)
30. 2.767 2.767 ↓ 1.0 3,888 1

Bitmap Heap Scan on attribute_to_serviced_product sell_date (cost=74.08..533.13 rows=3,844 width=12) (actual time=0.530..2.767 rows=3,888 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 20)
  • Heap Blocks: exact=253
  • -> Bitmap Index Scan on fki_serviced_product_attribute_serviced_product_attribute_id (cost=0.00..73.12 rows=3,844 width=0) (actual time=0.484..0.484 rows=
  • Index Cond: (serviced_product_attribute_id = 20)
31. 2.084 9.618 ↑ 1.0 7,089 1

Hash (cost=920.44..920.44 rows=7,089 width=57) (actual time=9.618..9.618 rows=7,089 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 438kB
32. 1.438 7.534 ↑ 1.0 7,089 1

Merge Left Join (cost=604.90..920.44 rows=7,089 width=57) (actual time=0.621..7.534 rows=7,089 loops=1)

  • Merge Cond: (sp.serviced_product_id = last_software_update_date.serviced_product_id)
33. 1.043 5.624 ↑ 1.0 7,089 1

Merge Left Join (cost=403.36..700.03 rows=7,089 width=49) (actual time=0.176..5.624 rows=7,089 loops=1)

  • Merge Cond: (sp.serviced_product_id = purchase_price.serviced_product_id)
34. 4.428 4.549 ↑ 1.0 7,089 1

Merge Left Join (cost=201.82..479.63 rows=7,089 width=34) (actual time=0.143..4.549 rows=7,089 loops=1)

  • Merge Cond: (sp.serviced_product_id = currency_version.serviced_product_id)
  • -> Index Scan using pk_serviced_product_id on serviced_product sp (cost=0.28..259.23 rows=7,089 width=19) (actual time=0.019..2.611 rows
35. 0.121 0.121 ↑ 10.9 7 1

Sort (cost=201.54..201.73 rows=76 width=19) (actual time=0.121..0.121 rows=7 loops=1)

  • Sort Key: currency_version.serviced_product_id
  • Sort Method: quicksort Memory: 25kB
  • -> Bitmap Heap Scan on attribute_to_serviced_product currency_version (cost=4.88..199.17 rows=76 width=19) (actual time=0.045..0.
  • Recheck Cond: (serviced_product_attribute_id = 32)
  • Heap Blocks: exact=5
  • -> Bitmap Index Scan on fki_serviced_product_attribute_serviced_product_attribute_id (cost=0.00..4.86 rows=76 width=0) (act
  • Index Cond: (serviced_product_attribute_id = 32)
36. 0.032 0.032 ↓ 0.0 0 1

Sort (cost=201.54..201.73 rows=76 width=19) (actual time=0.032..0.032 rows=0 loops=1)

  • Sort Key: purchase_price.serviced_product_id
  • Sort Method: quicksort Memory: 25kB
  • -> Bitmap Heap Scan on attribute_to_serviced_product purchase_price (cost=4.88..199.17 rows=76 width=19) (actual time=0.017..0.017 rows
  • Recheck Cond: (serviced_product_attribute_id = 55)
  • -> Bitmap Index Scan on fki_serviced_product_attribute_serviced_product_attribute_id (cost=0.00..4.86 rows=76 width=0) (actual ti
  • Index Cond: (serviced_product_attribute_id = 55)
37. 0.472 0.472 ↓ 2.5 188 1

Sort (cost=201.54..201.73 rows=76 width=12) (actual time=0.443..0.472 rows=188 loops=1)

  • Sort Key: last_software_update_date.serviced_product_id
  • Sort Method: quicksort Memory: 33kB
  • -> Bitmap Heap Scan on attribute_to_serviced_product last_software_update_date (cost=4.88..199.17 rows=76 width=12) (actual time=0.107..0.380
  • Recheck Cond: (serviced_product_attribute_id = 24)
  • Heap Blocks: exact=36
  • -> Bitmap Index Scan on fki_serviced_product_attribute_serviced_product_attribute_id (cost=0.00..4.86 rows=76 width=0) (actual time=0.0
  • Index Cond: (serviced_product_attribute_id = 24)
38. 0.727 2.536 ↑ 1.0 2,218 1

Hash (cost=155.18..155.18 rows=2,218 width=40) (actual time=2.536..2.536 rows=2,218 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 193kB
39. 1.809 1.809 ↑ 1.0 2,218 1

Seq Scan on product p (cost=0.00..155.18 rows=2,218 width=40) (actual time=0.018..1.809 rows=2,218 loops=1)

Planning time : 7.873 ms
Execution time : 1,071.365 ms