SOLECTRUS

.MD

House::ChartsController#index

…

Most impactful sections

view44%
http15%
gc11%
rack9%
redis7%
sql5%
cache5%
code2%
unknown1%


view app/views/house/charts/index.turbo_stream.slim	44%
Average Self 37ms Average calls 1x Total Self 37ms Total Children 24ms Total runtime 61ms
http app/lib/sensor/query/helpers/influx/base.rb:95	15%
Average Self 27ms Average calls 0.44x Total Self 12ms Total Children 0ms Total runtime 12ms `POST influxdb`
gc ruby/gc.c	11%
Average Self 9.4ms Average calls 1x Total Self 9.4ms Total Children 0ms Total runtime 9.4ms `GC.start`
sql app/lib/sensor/query/helpers/sql/total.rb:173	5%
Average Self 10ms Average calls 0.44x Total Self 4.6ms Total Children 0ms Total runtime 4.6ms WITH daily AS ( SELECT sv.date, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS custom_power_01_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS custom_power_01_grid_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS custom_power_02_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS custom_power_02_grid_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS custom_power_06_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS custom_power_06_grid_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS custom_power_08_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS custom_power_08_grid_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS custom_power_09_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS custom_power_09_grid_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS house_power_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS house_power_grid_sum FROM summary_values sv WHERE sv.date BETWEEN DATE ? AND DATE ? AND sv.aggregation IN (?) AND sv.field IN (?) GROUP BY sv.date ) SELECT date, SUM(custom_power_01_sum) AS custom_power_01_sum_sum, SUM(custom_power_01_grid_sum) AS custom_power_01_grid_sum_sum, SUM(custom_power_02_sum) AS custom_power_02_sum_sum, SUM(custom_power_02_grid_sum) AS custom_power_02_grid_sum_sum, SUM(custom_power_06_sum) AS custom_power_06_sum_sum, SUM(custom_power_06_grid_sum) AS custom_power_06_grid_sum_sum, SUM(custom_power_08_sum) AS custom_power_08_sum_sum, SUM(custom_power_08_grid_sum) AS custom_power_08_grid_sum_sum, SUM(custom_power_09_sum) AS custom_power_09_sum_sum, SUM(custom_power_09_grid_sum) AS custom_power_09_grid_sum_sum, SUM(house_power_sum) AS house_power_sum_sum, SUM(house_power_grid_sum) AS house_power_grid_sum_sum FROM daily GROUP BY ? ORDER BY ?
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/static.rb:26	5%
Average Self 3.9ms Average calls 1x Total Self 3.9ms Total Children 70ms Total runtime 73ms `ActionDispatch::Static`
redis /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/cache/redis_cache_store.rb:464	3%
Average Self 2.8ms Average calls 1x Total Self 2.8ms Total Children 0ms Total runtime 2.8ms `pipeline`
cache app/controllers/concerns/main_navigation.rb:10	2%
Average Self 1.9ms Average calls 1x Total Self 1.9ms Total Children 1.2ms Total runtime 3.1ms `read`
cache app/lib/sensor/query/helpers/influx/base.rb:79	2%
Average Self 1.9ms Average calls 1x Total Self 1.9ms Total Children 1.9ms Total runtime 3.8ms `read`
redis app/lib/sensor/query/helpers/influx/base.rb:79	2%
Average Self 1.9ms Average calls 1x Total Self 1.9ms Total Children 0ms Total runtime 1.9ms `get`
code app/controllers/house/charts_controller.rb:5	2%
Average Self 1.8ms Average calls 1x Total Self 1.8ms Total Children 61ms Total runtime 63ms `House::ChartsController#index`
redis app/controllers/concerns/main_navigation.rb:10	1%
Average Self 1.2ms Average calls 1x Total Self 1.2ms Total Children 0ms Total runtime 1.2ms `get`
rack /usr/local/bundle/gems/http_accept_language-2.1.1/lib/http_accept_language/middleware.rb:7	1%
Average Self 1.2ms Average calls 1x Total Self 1.2ms Total Children 63ms Total runtime 64ms `HttpAcceptLanguage::Middleware`
rack /usr/local/bundle/gems/railties-8.1.3/lib/rails/rack/logger.rb:20	<1%
Average Self 0.33ms Average calls 1x Total Self 0.33ms Total Children 69ms Total runtime 69ms `Rails::Rack::Logger`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/etag.rb:28	<1%
Average Self 0.33ms Average calls 1x Total Self 0.33ms Total Children 68ms Total runtime 68ms `Rack::ETag`
rack /usr/local/bundle/gems/rack-attack-6.8.0/lib/rack/attack.rb:104	<1%
Average Self 0.33ms Average calls 1x Total Self 0.33ms Total Children 67ms Total runtime 67ms `Rack::Attack`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/http/content_security_policy.rb:37	<1%
Average Self 0.22ms Average calls 1x Total Self 0.22ms Total Children 68ms Total runtime 68ms `ActionDispatch::ContentSecurityPolicy::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/debug_exceptions.rb:30	<1%
Average Self 0.22ms Average calls 1x Total Self 0.22ms Total Children 68ms Total runtime 69ms `ActionDispatch::DebugExceptions`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/executor.rb:13	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 69ms Total runtime 70ms `ActionDispatch::Executor`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/show_exceptions.rb:31	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 69ms Total runtime 69ms `ActionDispatch::ShowExceptions`
rack /usr/local/bundle/gems/honeybadger-6.6.0/lib/honeybadger/rack/error_notifier.rb:29	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 73ms Total runtime 74ms `Honeybadger::Rack::ErrorNotifier`
rack /usr/local/bundle/gems/rack-session-2.1.2/lib/rack/session/abstract/id.rb:267	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 68ms Total runtime 68ms `ActionDispatch::Session::CookieStore`
rack /usr/local/bundle/gems/railties-8.1.3/lib/rails/rack/silence_request.rb:27	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 69ms Total runtime 69ms `Rails::Rack::SilenceRequest`
code /usr/local/bundle/gems/railties-8.1.3/lib/rails/engine.rb:532	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 74ms Total runtime 74ms `Rails::Engine#call`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/deflater.rb:46	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 74ms Total runtime 74ms `Rack::Deflater`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/request_id.rb:31	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 69ms Total runtime 69ms `ActionDispatch::RequestId`
rack Rack::Brotli	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 74ms Total runtime 74ms
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/head.rb:14	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 68ms Total runtime 68ms `Rack::Head`
rack ActionDispatch::Flash	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 68ms Total runtime 68ms
rack /usr/local/bundle/gems/request_store-1.7.0/lib/request_store/middleware.rb:16	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 69ms Total runtime 69ms `RequestStore::Middleware`
rack /usr/local/bundle/gems/rails-settings-cached-2.9.6/lib/rails-settings/middleware.rb:7	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 67ms Total runtime 68ms `RailsSettings::Middleware`
cache /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158	<1%
Average Self 0.11ms Average calls 1x Total Self 0.11ms Total Children 2.8ms Total runtime 2.9ms `increment`
rack /usr/local/bundle/gems/honeybadger-6.6.0/lib/honeybadger/rack/user_informer.rb:19	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 74ms Total runtime 74ms `Honeybadger::Rack::UserInformer`
rack /usr/local/bundle/gems/rack-cors-3.0.0/lib/rack/cors.rb:66	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 74ms Total runtime 74ms `Rack::Cors`
rack /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/cache/strategy/local_cache_middleware.rb:28	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 69ms Total runtime 69ms `ActiveSupport::Cache::Strategy::LocalCache::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/http/permissions_policy.rb:37	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 68ms Total runtime 68ms `ActionDispatch::PermissionsPolicy::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/cookies.rb:706	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 68ms Total runtime 68ms `ActionDispatch::Cookies`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/callbacks.rb:28	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 68ms Total runtime 68ms `ActionDispatch::Callbacks`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/ssl.rb:88	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 73ms Total runtime 73ms `ActionDispatch::SSL`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/remote_ip.rb:95	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 69ms Total runtime 69ms `ActionDispatch::RemoteIp`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/assume_ssl.rb:18	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 73ms Total runtime 73ms `ActionDispatch::AssumeSSL`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/tempfile_reaper.rb:16	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 68ms Total runtime 68ms `Rack::TempfileReaper`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/method_override.rb:19	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 69ms Total runtime 69ms `Rack::MethodOverride`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/conditional_get.rb:28	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 68ms Total runtime 68ms `Rack::ConditionalGet`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/sendfile.rb:130	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 73ms Total runtime 73ms `Rack::Sendfile`
rack /usr/local/bundle/gems/honeybadger-6.6.0/lib/honeybadger/rack/user_feedback.rb:29	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 74ms Total runtime 74ms `Honeybadger::Rack::UserFeedback`

Slowest executions

loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-
loading…	-	-