explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t6dH

Settings
# exclusive inclusive rows x rows loops node
1. 818.779 976.092 ↓ 262.5 1,869,058 1

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

  • Hash Cond: (seller_company.serviced_product_id = sp.serviced_product_id)
2. 1.810 2.547 ↑ 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.801..2.547 rows=7,055 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 19)
  • Heap Blocks: exact=381
3. 0.737 0.737 ↑ 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.737..0.737 rows=7,055 loops=1)

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

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

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

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

  • Hash Cond: (central_company.serviced_product_id = sp.serviced_product_id)
6. 1.950 2.676 ↓ 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.788..2.676 rows=7,101 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 18)
  • Heap Blocks: exact=380
7. 0.726 0.726 ↓ 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.726..0.726 rows=7,101 loops=1)

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

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

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

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

  • Hash Cond: (user_company.serviced_product_id = sp.serviced_product_id)
10. 1.775 2.549 ↓ 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.832..2.549 rows=7,023 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 62)
  • Heap Blocks: exact=378
11. 0.774 0.774 ↓ 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.774..0.774 rows=7,023 loops=1)

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

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

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

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

  • Hash Cond: (customer_warranty_date.serviced_product_id = sp.serviced_product_id)
14. 0.986 1.377 ↓ 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.425..1.377 rows=3,543 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 26)
  • Heap Blocks: exact=235
15. 0.391 0.391 ↓ 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.391..0.391 rows=3,543 loops=1)

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

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

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

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

  • Hash Cond: (provider_warranty_date.serviced_product_id = sp.serviced_product_id)
18. 0.019 0.043 ↑ 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.035..0.043 rows=15 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 21)
  • Heap Blocks: exact=7
19. 0.024 0.024 ↑ 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.024..0.024 rows=15 loops=1)

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

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

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

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

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

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

  • Hash Cond: (last_conservation_date.serviced_product_id = sp.serviced_product_id)
23. 1.997 2.463 ↓ 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.504..2.463 rows=4,569 loops=1)

  • Recheck Cond: (serviced_product_attribute_id = 23)
  • Heap Blocks: exact=281
24. 0.466 0.466 ↓ 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.466..0.466 rows=4,569 loops=1)

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

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

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

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

  • Hash Cond: (installation_date.serviced_product_id = sp.serviced_product_id)
27. 1.333 1.333 ↑ 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.440..1.333 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.405..0.405 rows=3,878 loops=1
  • Index Cond: (serviced_product_attribute_id = 7)
28. 1.910 17.181 ↓ 1.0 7,111 1

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

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

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

  • Hash Cond: (sell_date.serviced_product_id = sp.serviced_product_id)
30. 3.190 3.190 ↓ 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.502..3.190 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.460..0.460 rows=
  • Index Cond: (serviced_product_attribute_id = 20)
31. 1.844 9.286 ↑ 1.0 7,089 1

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

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

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

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

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

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

Merge Left Join (cost=201.82..479.63 rows=7,089 width=34) (actual time=0.126..4.341 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.015..2.480 rows
35. 0.105 0.105 ↑ 10.9 7 1

Sort (cost=201.54..201.73 rows=76 width=19) (actual time=0.104..0.105 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.052..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.027 0.027 ↓ 0.0 0 1

Sort (cost=201.54..201.73 rows=76 width=19) (actual time=0.027..0.027 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.019..0.019 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.463 0.463 ↓ 2.5 188 1

Sort (cost=201.54..201.73 rows=76 width=12) (actual time=0.432..0.463 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.050..0.382
  • 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.590 2.342 ↑ 1.0 2,218 1

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

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

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

Planning time : 10.756 ms
Execution time : 1,068.982 ms