explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C8Di : HostFilter_ON

Settings
# exclusive inclusive rows x rows loops node
1. 401.165 1,869.938 ↓ 4.8 1,535 1

Nested Loop (cost=3,908.91..4,379.98 rows=318 width=2,495) (actual time=137.103..1,869.938 rows=1,535 loops=1)

  • Buffers: shared hit=20237
2. 1.398 18.198 ↓ 4.8 1,535 1

Hash Join (cost=633.17..700.54 rows=318 width=1,280) (actual time=16.536..18.198 rows=1,535 loops=1)

  • Buffers: shared hit=389
3. 0.287 0.287 ↑ 1.0 1,602 1

Seq Scan on systeminfo_chassis c (cost=0..61.02 rows=1,602 width=1,060) (actual time=0.013..0.287 rows=1,602 loops=1)

  • Buffers: shared hit=45
4. 1.506 16.513 ↓ 4.8 1,535 1

Hash (cost=629.2..629.2 rows=318 width=224) (actual time=16.513..16.513 rows=1,535 loops=1)

  • Buffers: shared hit=344
5. 1.603 15.007 ↓ 4.8 1,535 1

Hash Join (cost=566.83..629.2 rows=318 width=224) (actual time=13.125..15.007 rows=1,535 loops=1)

  • Buffers: shared hit=344
6. 0.300 0.300 ↑ 1.0 1,602 1

Seq Scan on systeminfo_ipmi f (cost=0..56.02 rows=1,602 width=123) (actual time=0.014..0.3 rows=1,602 loops=1)

  • Buffers: shared hit=40
7. 1.215 13.104 ↓ 4.8 1,535 1

Hash (cost=562.85..562.85 rows=318 width=105) (actual time=13.104..13.104 rows=1,535 loops=1)

  • Buffers: shared hit=304
8. 1.345 11.889 ↓ 4.8 1,535 1

Hash Join (cost=502.49..562.85 rows=318 width=105) (actual time=10.278..11.889 rows=1,535 loops=1)

  • Buffers: shared hit=304
9. 0.287 0.287 ↑ 1.0 1,602 1

Seq Scan on systeminfo_bios e (cost=0..54.02 rows=1,602 width=9) (actual time=0.015..0.287 rows=1,602 loops=1)

  • Buffers: shared hit=38
10. 1.172 10.257 ↓ 4.8 1,535 1

Hash (cost=498.51..498.51 rows=318 width=100) (actual time=10.257..10.257 rows=1,535 loops=1)

  • Buffers: shared hit=266
11. 1.350 9.085 ↓ 4.8 1,535 1

Hash Join (cost=442.14..498.51 rows=318 width=100) (actual time=7.483..9.085 rows=1,535 loops=1)

  • Buffers: shared hit=266
12. 0.276 0.276 ↑ 1.0 1,602 1

Seq Scan on systeminfo_baseboard b (cost=0..50.02 rows=1,602 width=42) (actual time=0.017..0.276 rows=1,602 loops=1)

  • Buffers: shared hit=34
13. 0.915 7.459 ↓ 4.8 1,535 1

Hash (cost=438.17..438.17 rows=318 width=62) (actual time=7.459..7.459 rows=1,535 loops=1)

  • Buffers: shared hit=232
14. 1.241 6.544 ↓ 4.8 1,535 1

Hash Join (cost=225.72..438.17 rows=318 width=62) (actual time=4.07..6.544 rows=1,535 loops=1)

  • Buffers: shared hit=232
15. 1.290 1.684 ↑ 1.0 3,000 1

Bitmap Heap Scan on ssm_objects a (cost=123.67..321.68 rows=3,000 width=8) (actual time=0.434..1.684 rows=3,000 loops=1)

  • Filter: (a.is_active = 1)
  • Buffers: shared hit=174
16. 0.394 0.394 ↑ 1.0 3,001 1

Bitmap Index Scan on u_objects (cost=0..122.92 rows=3,001 width=0) (actual time=0.394..0.394 rows=3,001 loops=1)

  • Index Cond: (a.objecttype_id = 1)
  • Buffers: shared hit=21
17. 0.858 3.619 ↑ 1.0 1,536 1

Hash (cost=82.03..82.03 rows=1,602 width=58) (actual time=3.619..3.619 rows=1,536 loops=1)

  • Buffers: shared hit=58
18. 2.761 2.761 ↑ 1.0 1,536 1

Seq Scan on systeminfo_computer d (cost=0..82.03 rows=1,602 width=58) (actual time=0.028..2.761 rows=1,536 loops=1)

  • Filter: (lower((d.manufacturer)::text) ~~ '%s%'::text)
  • Buffers: shared hit=58
19. 166.005 1,450.575 ↓ 3,000.0 3,000 1,535

Materialize (cost=3,275.74..3,674.67 rows=1 width=1,215) (actual time=0.056..0.945 rows=3,000 loops=1,535)

  • Buffers: shared hit=19848
20. 330.064 1,284.570 ↓ 3,000.0 3,000 1

Nested Loop (cost=3,275.74..3,674.67 rows=1 width=1,215) (actual time=85.212..1,284.57 rows=3,000 loops=1)

  • Buffers: shared hit=19848
21. 16.112 90.506 ↓ 3,000.0 3,000 1

Nested Loop (cost=1,054.25..1,355.65 rows=1 width=1,211) (actual time=44.934..90.506 rows=3,000 loops=1)

  • Buffers: shared hit=18647
22. 3.604 71.394 ↓ 3,000.0 3,000 1

Nested Loop (cost=1,054.25..1,354.6 rows=1 width=1,177) (actual time=44.913..71.394 rows=3,000 loops=1)

  • Buffers: shared hit=15647
23. 3.546 64.790 ↓ 3,000.0 3,000 1

Nested Loop (cost=1,054.12..1,354.44 rows=1 width=1,035) (actual time=44.904..64.79 rows=3,000 loops=1)

  • Buffers: shared hit=9647
24. 2.770 52.244 ↓ 42.3 3,000 1

Hash Join (cost=1,053.84..1,313.97 rows=71 width=1,035) (actual time=44.885..52.244 rows=3,000 loops=1)

  • Buffers: shared hit=639
25. 3.929 4.646 ↓ 8.0 3,001 1

Hash Join (cost=1.11..259.13 rows=375 width=343) (actual time=0.046..4.646 rows=3,001 loops=1)

  • Buffers: shared hit=214
26. 0.691 0.691 ↑ 1.0 3,001 1

Seq Scan on ssm_hoststatus c_1 (cost=0..243.01 rows=3,001 width=293) (actual time=0.009..0.691 rows=3,001 loops=1)

  • Buffers: shared hit=213
27. 0.012 0.026 ↓ 4.0 4 1

Hash (cost=1.1..1.1 rows=1 width=54) (actual time=0.026..0.026 rows=4 loops=1)

  • Buffers: shared hit=1
28. 0.014 0.014 ↓ 4.0 4 1

Seq Scan on ssm_tl_status e_1 (cost=0..1.1 rows=1 width=54) (actual time=0.012..0.014 rows=4 loops=1)

  • Filter: (e_1.status_type = 1)
  • Buffers: shared hit=1
29. 2.998 44.828 ↓ 5.3 3,000 1

Hash (cost=1,045.61..1,045.61 rows=569 width=692) (actual time=44.828..44.828 rows=3,000 loops=1)

  • Buffers: shared hit=425
30. 5.095 41.830 ↓ 5.3 3,000 1

Hash Join (cost=840.71..1,045.61 rows=569 width=692) (actual time=36.095..41.83 rows=3,000 loops=1)

  • Buffers: shared hit=425
31. 0.659 0.659 ↑ 1.0 3,001 1

Seq Scan on ssm_hosts b_1 (cost=0..197.01 rows=3,001 width=656) (actual time=0.009..0.659 rows=3,001 loops=1)

  • Buffers: shared hit=167
32. 1.008 36.076 ↓ 5.3 3,000 1

Hash (cost=833.6..833.6 rows=569 width=36) (actual time=36.076..36.076 rows=3,000 loops=1)

  • Buffers: shared hit=258
33. 18.034 35.068 ↓ 5.3 3,000 1

Aggregate (cost=822.22..827.91 rows=569 width=36) (actual time=33.977..35.068 rows=3,000 loops=1)

  • Buffers: shared hit=258
34. 7.474 17.034 ↓ 5.3 3,000 1

Sort (cost=670.91..672.33 rows=571 width=86) (actual time=16.819..17.034 rows=3,000 loops=1)

  • Sort Key: c_2.type_value, b_2.object_id
  • Sort Method: quicksort Memory: 237kB
  • Buffers: shared hit=258
35. 1.228 9.560 ↓ 5.3 3,000 1

Hash Join (cost=355.1..644.76 rows=571 width=86) (actual time=2.236..9.56 rows=3,000 loops=1)

  • Buffers: shared hit=258
36. 4.186 8.243 ↓ 1.0 3,000 1

Hash Join (cost=351.69..624.4 rows=2,998 width=8) (actual time=2.142..8.243 rows=3,000 loops=1)

  • Buffers: shared hit=256
37. 1.961 1.961 ↑ 1.0 15,105 1

Seq Scan on ssm_classification_object b_2 (cost=0..233.05 rows=15,105 width=8) (actual time=0.014..1.961 rows=15,105 loops=1)

  • Buffers: shared hit=82
38. 0.802 2.096 ↑ 1.0 3,001 1

Hash (cost=314.18..314.18 rows=3,001 width=4) (actual time=2.096..2.096 rows=3,001 loops=1)

  • Buffers: shared hit=174
39. 0.920 1.294 ↑ 1.0 3,001 1

Bitmap Heap Scan on ssm_objects d_2 (cost=123.67..314.18 rows=3,001 width=4) (actual time=0.412..1.294 rows=3,001 loops=1)

  • Buffers: shared hit=174
40. 0.374 0.374 ↑ 1.0 3,001 1

Bitmap Index Scan on u_objects (cost=0..122.92 rows=3,001 width=0) (actual time=0.373..0.374 rows=3,001 loops=1)

  • Index Cond: (d_2.objecttype_id = 1)
  • Buffers: shared hit=21
41. 0.012 0.089 ↑ 1.1 11 1

Hash (cost=3.26..3.26 rows=12 width=86) (actual time=0.089..0.089 rows=11 loops=1)

  • Buffers: shared hit=2
42. 0.032 0.077 ↑ 1.1 11 1

Hash Join (cost=1.27..3.26 rows=12 width=86) (actual time=0.053..0.077 rows=11 loops=1)

  • Buffers: shared hit=2
43. 0.018 0.018 ↑ 1.0 63 1

Seq Scan on ssm_classifications a_2 (cost=0..1.63 rows=63 width=19) (actual time=0.011..0.018 rows=63 loops=1)

  • Buffers: shared hit=1
44. 0.014 0.027 ↑ 1.0 12 1

Hash (cost=1.12..1.12 rows=12 width=164) (actual time=0.027..0.027 rows=12 loops=1)

  • Buffers: shared hit=1
45. 0.013 0.013 ↑ 1.0 12 1

Seq Scan on ssm_tl_hosttype c_2 (cost=0..1.12 rows=12 width=164) (actual time=0.009..0.013 rows=12 loops=1)

  • Buffers: shared hit=1
46. 9.000 9.000 ↑ 1.0 1 3,000

Index Scan using ssm_objects_pkey on ssm_objects a_1 (cost=0.29..0.57 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=3,000)

  • Index Cond: (a_1.object_id = b_1.host_object_id)
  • Filter: ((a_1.is_active = 1) AND (a_1.objecttype_id = 1))
  • Buffers: shared hit=9008
47. 3.000 3.000 ↑ 1.0 1 3,000

Index Scan using ssm_instances_pkey on ssm_instances d_1 (cost=0.13..0.15 rows=1 width=150) (actual time=0.001..0.001 rows=1 loops=3,000)

  • Index Cond: (d_1.instance_id = a_1.instance_id)
  • Buffers: shared hit=6000
48. 3.000 3.000 ↑ 1.0 2 3,000

Seq Scan on ssm_tl_type f_1 (cost=0..1.02 rows=2 width=38) (actual time=0.001..0.001 rows=2 loops=3,000)

  • Buffers: shared hit=3000
49. 829.583 864.000 ↑ 2.0 1,501 3,000

Aggregate (cost=2,221.49..2,251.5 rows=3,001 width=8) (actual time=0.014..0.288 rows=1,501 loops=3,000)

  • Buffers: shared hit=1201
50. 2.267 34.417 ↓ 1.6 12,000 1

Nested Loop (cost=1,280.47..2,183.68 rows=7,562 width=8) (actual time=21.868..34.417 rows=12,000 loops=1)

  • Buffers: shared hit=1201
51. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on ssm_instances d_3 (cost=0..1.01 rows=1 width=4) (actual time=0.01..0.011 rows=1 loops=1)

  • Buffers: shared hit=1
52. 7.835 32.139 ↓ 1.6 12,000 1

Hash Join (cost=1,280.47..2,088.14 rows=7,562 width=12) (actual time=21.856..32.139 rows=12,000 loops=1)

  • Buffers: shared hit=1200
53. 2.563 2.563 ↑ 1.0 12,004 1

Seq Scan on ssm_servicestatus f_2 (cost=0..687.04 rows=12,004 width=8) (actual time=0.009..2.563 rows=12,004 loops=1)

  • Buffers: shared hit=567
54. 4.177 21.741 ↓ 1.3 12,000 1

Hash (cost=1,161.39..1,161.39 rows=9,526 width=16) (actual time=21.741..21.741 rows=12,000 loops=1)

  • Buffers: shared hit=633
55. 6.306 17.564 ↓ 1.3 12,000 1

Hash Join (cost=529.83..1,161.39 rows=9,526 width=16) (actual time=8.977..17.564 rows=12,000 loops=1)

  • Buffers: shared hit=633
56. 2.394 2.394 ↑ 1.0 12,004 1

Seq Scan on ssm_services e_2 (cost=0..600.04 rows=12,004 width=8) (actual time=0.011..2.394 rows=12,004 loops=1)

  • Buffers: shared hit=480
57. 3.551 8.864 ↑ 1.0 12,000 1

Hash (cost=379.83..379.83 rows=12,000 width=8) (actual time=8.864..8.864 rows=12,000 loops=1)

  • Buffers: shared hit=153
58. 5.313 5.313 ↑ 1.0 12,000 1

Seq Scan on ssm_objects a_3 (cost=0..379.83 rows=12,000 width=8) (actual time=0.026..5.313 rows=12,000 loops=1)

  • Filter: ((a_3.is_active = 1) AND (a_3.objecttype_id = 2))
  • Buffers: shared hit=153