explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 29ff : HostFilter

Settings
# exclusive inclusive rows x rows loops node
1. 2.808 137.915 ↓ 4.8 1,535 1

Hash Join (cost=4,522.46..4,731.37 rows=318 width=2,495) (actual time=116.725..137.915 rows=1,535 loops=1)

  • Buffers: shared hit=2405
2. 2.555 113.840 ↓ 3,000.0 3,000 1

Hash Join (cost=3,769.68..3,978.58 rows=1 width=1,215) (actual time=95.428..113.84 rows=3,000 loops=1)

  • Buffers: shared hit=2016
3. 2.363 74.894 ↓ 200.0 3,000 1

Hash Join (cost=2,928.96..3,137.83 rows=15 width=1,187) (actual time=59.027..74.894 rows=3,000 loops=1)

  • Buffers: shared hit=1758
4. 2.174 28.522 ↓ 200.0 3,000 1

Hash Join (cost=600.48..809.3 rows=15 width=1,183) (actual time=14.979..28.522 rows=3,000 loops=1)

  • Buffers: shared hit=557
5. 2.001 26.313 ↓ 200.0 3,000 1

Hash Join (cost=599.43..808.05 rows=15 width=1,149) (actual time=14.934..26.313 rows=3,000 loops=1)

  • Buffers: shared hit=556
6. 8.668 24.293 ↓ 200.0 3,000 1

Hash Join (cost=598.41..806.82 rows=15 width=1,007) (actual time=14.909..24.293 rows=3,000 loops=1)

  • Buffers: shared hit=555
7. 0.736 0.736 ↑ 1.0 3,001 1

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

  • Buffers: shared hit=167
8. 3.055 14.889 ↓ 40.5 3,000 1

Hash (cost=597.49..597.49 rows=74 width=351) (actual time=14.889..14.889 rows=3,000 loops=1)

  • Buffers: shared hit=388
9. 2.501 11.834 ↓ 40.5 3,000 1

Hash Join (cost=387.48..597.49 rows=74 width=351) (actual time=8.186..11.834 rows=3,000 loops=1)

  • Buffers: shared hit=388
10. 1.197 1.571 ↑ 1.0 3,000 1

Bitmap Heap Scan on ssm_objects a_1 (cost=123.67..321.68 rows=3,000 width=8) (actual time=0.416..1.571 rows=3,000 loops=1)

  • Filter: (a_1.is_active = 1)
  • Buffers: shared hit=174
11. 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.374..0.374 rows=3,001 loops=1)

  • Index Cond: (a_1.objecttype_id = 1)
  • Buffers: shared hit=21
12. 2.944 7.762 ↓ 8.0 3,001 1

Hash (cost=259.13..259.13 rows=375 width=343) (actual time=7.762..7.762 rows=3,001 loops=1)

  • Buffers: shared hit=214
13. 4.085 4.818 ↓ 8.0 3,001 1

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

  • Buffers: shared hit=214
14. 0.715 0.715 ↑ 1.0 3,001 1

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

  • Buffers: shared hit=213
15. 0.004 0.018 ↓ 4.0 4 1

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

  • Buffers: shared hit=1
16. 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.011..0.014 rows=4 loops=1)

  • Filter: (e_1.status_type = 1)
  • Buffers: shared hit=1
17. 0.009 0.019 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=150) (actual time=0.019..0.019 rows=1 loops=1)

  • Buffers: shared hit=1
18. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on ssm_instances d_1 (cost=0..1.01 rows=1 width=150) (actual time=0.009..0.01 rows=1 loops=1)

  • Buffers: shared hit=1
19. 0.010 0.035 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=38) (actual time=0.035..0.035 rows=2 loops=1)

  • Buffers: shared hit=1
20. 0.025 0.025 ↑ 1.0 2 1

Seq Scan on ssm_tl_type f_1 (cost=0..1.02 rows=2 width=38) (actual time=0.023..0.025 rows=2 loops=1)

  • Buffers: shared hit=1
21. 0.901 44.009 ↑ 1.0 3,000 1

Hash (cost=2,290.97..2,290.97 rows=3,001 width=8) (actual time=44.009..44.009 rows=3,000 loops=1)

  • Buffers: shared hit=1201
22. 0.462 43.108 ↑ 1.0 3,000 1

Subquery Scan on b_1 (cost=2,230.95..2,290.97 rows=3,001 width=8) (actual time=41.849..43.108 rows=3,000 loops=1)

  • Buffers: shared hit=1201
23. 6.356 42.646 ↑ 1.0 3,000 1

Aggregate (cost=2,230.95..2,260.96 rows=3,001 width=8) (actual time=41.847..42.646 rows=3,000 loops=1)

  • Buffers: shared hit=1201
24. 3.897 36.290 ↓ 1.6 12,000 1

Hash Join (cost=1,281.49..2,193.14 rows=7,562 width=8) (actual time=22.142..36.29 rows=12,000 loops=1)

  • Buffers: shared hit=1201
25. 7.839 32.371 ↓ 1.6 12,000 1

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

  • Buffers: shared hit=1200
26. 2.554 2.554 ↑ 1.0 12,004 1

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

  • Buffers: shared hit=567
27. 4.224 21.978 ↓ 1.3 12,000 1

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

  • Buffers: shared hit=633
28. 6.364 17.754 ↓ 1.3 12,000 1

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

  • Buffers: shared hit=633
29. 2.405 2.405 ↑ 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.405 rows=12,004 loops=1)

  • Buffers: shared hit=480
30. 3.640 8.985 ↑ 1.0 12,000 1

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

  • Buffers: shared hit=153
31. 5.345 5.345 ↑ 1.0 12,000 1

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

  • Filter: ((a_2.is_active = 1) AND (a_2.objecttype_id = 2))
  • Buffers: shared hit=153
32. 0.009 0.022 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=4) (actual time=0.022..0.022 rows=1 loops=1)

  • Buffers: shared hit=1
33. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on ssm_instances d_2 (cost=0..1.01 rows=1 width=4) (actual time=0.013..0.013 rows=1 loops=1)

  • Buffers: shared hit=1
34. 0.999 36.391 ↓ 5.3 3,000 1

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

  • Buffers: shared hit=258
35. 18.167 35.392 ↓ 5.3 3,000 1

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

  • Buffers: shared hit=258
36. 7.443 17.225 ↓ 5.3 3,000 1

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

  • Sort Key: c_2.type_value, b_3.object_id
  • Sort Method: quicksort Memory: 237kB
  • Buffers: shared hit=258
37. 1.209 9.782 ↓ 5.3 3,000 1

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

  • Buffers: shared hit=258
38. 4.179 8.481 ↓ 1.0 3,000 1

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

  • Buffers: shared hit=256
39. 2.150 2.150 ↑ 1.0 15,105 1

Seq Scan on ssm_classification_object b_3 (cost=0..233.05 rows=15,105 width=8) (actual time=0.016..2.15 rows=15,105 loops=1)

  • Buffers: shared hit=82
40. 0.811 2.152 ↑ 1.0 3,001 1

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

  • Buffers: shared hit=174
41. 0.958 1.341 ↑ 1.0 3,001 1

Bitmap Heap Scan on ssm_objects d_3 (cost=123.67..314.18 rows=3,001 width=4) (actual time=0.42..1.341 rows=3,001 loops=1)

  • Buffers: shared hit=174
42. 0.383 0.383 ↑ 1.0 3,001 1

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

  • Index Cond: (d_3.objecttype_id = 1)
  • Buffers: shared hit=21
43. 0.009 0.092 ↑ 1.1 11 1

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

  • Buffers: shared hit=2
44. 0.031 0.083 ↑ 1.1 11 1

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

  • Buffers: shared hit=2
45. 0.024 0.024 ↑ 1.0 63 1

Seq Scan on ssm_classifications a_3 (cost=0..1.63 rows=63 width=19) (actual time=0.015..0.024 rows=63 loops=1)

  • Buffers: shared hit=1
46. 0.015 0.028 ↑ 1.0 12 1

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

  • Buffers: shared hit=1
47. 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
48. 1.707 21.267 ↓ 4.8 1,535 1

Hash (cost=748.8..748.8 rows=318 width=1,280) (actual time=21.267..21.267 rows=1,535 loops=1)

  • Buffers: shared hit=389
49. 1.662 19.560 ↓ 4.8 1,535 1

Hash Join (cost=686.44..748.8 rows=318 width=1,280) (actual time=17.598..19.56 rows=1,535 loops=1)

  • Buffers: shared hit=389
50. 0.321 0.321 ↑ 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.321 rows=1,602 loops=1)

  • Buffers: shared hit=40
51. 1.475 17.577 ↓ 4.8 1,535 1

Hash (cost=682.46..682.46 rows=318 width=1,161) (actual time=17.577..17.577 rows=1,535 loops=1)

  • Buffers: shared hit=349
52. 1.491 16.102 ↓ 4.8 1,535 1

Hash Join (cost=622.09..682.46 rows=318 width=1,161) (actual time=14.305..16.102 rows=1,535 loops=1)

  • Buffers: shared hit=349
53. 0.330 0.330 ↑ 1.0 1,602 1

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

  • Buffers: shared hit=38
54. 1.411 14.281 ↓ 4.8 1,535 1

Hash (cost=618.12..618.12 rows=318 width=1,156) (actual time=14.281..14.281 rows=1,535 loops=1)

  • Buffers: shared hit=311
55. 1.451 12.870 ↓ 4.8 1,535 1

Hash Join (cost=376.81..618.12 rows=318 width=1,156) (actual time=6.98..12.87 rows=1,535 loops=1)

  • Buffers: shared hit=311
56. 1.362 7.855 ↑ 1.0 3,000 1

Hash Join (cost=274.76..501.63 rows=3,000 width=1,102) (actual time=3.399..7.855 rows=3,000 loops=1)

  • Buffers: shared hit=253
57. 1.482 5.088 ↑ 1.0 3,000 1

Hash Join (cost=193.71..406.16 rows=3,000 width=46) (actual time=1.974..5.088 rows=3,000 loops=1)

  • Buffers: shared hit=208
58. 1.695 2.119 ↑ 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.466..2.119 rows=3,000 loops=1)

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

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

  • Index Cond: (a.objecttype_id = 1)
  • Buffers: shared hit=21
60. 0.737 1.487 ↑ 1.0 1,602 1

Hash (cost=50.02..50.02 rows=1,602 width=42) (actual time=1.487..1.487 rows=1,602 loops=1)

  • Buffers: shared hit=34
61. 0.750 0.750 ↑ 1.0 1,602 1

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

  • Buffers: shared hit=34
62. 0.651 1.405 ↑ 1.0 1,602 1

Hash (cost=61.02..61.02 rows=1,602 width=1,060) (actual time=1.405..1.405 rows=1,602 loops=1)

  • Buffers: shared hit=45
63. 0.754 0.754 ↑ 1.0 1,602 1

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

  • Buffers: shared hit=45
64. 0.773 3.564 ↑ 1.0 1,536 1

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

  • Buffers: shared hit=58
65. 2.791 2.791 ↑ 1.0 1,536 1

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

  • Filter: (lower((d.manufacturer)::text) ~~ '%s%'::text)
  • Buffers: shared hit=58