SOLECTRUS

.MD

Balance::StatsController#index

…

Most impactful sections

view38%
http18%
redis17%
gc8%
rack7%
sql6%
code4%
unknown1%
cache1%


view app/views/balance/stats/index.turbo_stream.slim	38%
Average Self 43ms Average calls 1x Total Self 43ms Total Children 44ms Total runtime 88ms
http app/lib/sensor/query/helpers/influx/base.rb:95	18%
Average Self 46ms Average calls 0.44x Total Self 20ms Total Children 0ms Total runtime 20ms `POST influxdb`
gc ruby/gc.c	8%
Average Self 10ms Average calls 0.88x Total Self 8.9ms Total Children 0ms Total runtime 8.9ms `GC.start`
redis app/controllers/balance/stats_controller.rb:52	6%
Average Self 15ms Average calls 0.44x Total Self 6.6ms Total Children 0ms Total runtime 6.6ms `get`
sql app/lib/sensor/query/helpers/sql/total.rb:173	5%
Average Self 10ms Average calls 0.56x Total Self 6ms Total Children 0ms Total runtime 6ms WITH price_ranges AS ( SELECT name, starts_at, LEAD(starts_at, ?, ?::date) OVER (PARTITION BY name ORDER BY starts_at) AS next_start, value::numeric AS eur_per_kwh FROM prices WHERE name IN (?) ), daily AS ( SELECT sv.date, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS battery_charging_power_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS battery_charging_power_grid_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS battery_discharging_power_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS grid_export_power_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS grid_import_power_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS heatpump_power_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS heatpump_power_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, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS inverter_power_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS inverter_power_1_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS inverter_power_2_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS inverter_power_3_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS wallbox_power_sum, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS wallbox_power_grid_sum, MAX(pb.eur_per_kwh) AS pb_eur_per_kwh, MAX(pf.eur_per_kwh) AS pf_eur_per_kwh FROM summary_values sv LEFT JOIN price_ranges pb ON pb.name = ? AND sv.date >= pb.starts_at AND sv.date < pb.next_start LEFT JOIN price_ranges pf ON pf.name = ? AND sv.date >= pf.starts_at AND sv.date < pf.next_start WHERE sv.date BETWEEN DATE ? AND DATE ? AND sv.aggregation IN (?) AND sv.field IN (?) GROUP BY sv.date ) SELECT SUM(battery_charging_power_sum) AS battery_charging_power_sum_sum, SUM(battery_charging_power_grid_sum) AS battery_charging_power_grid_sum_sum, SUM(battery_charging_power_grid_sum * pb_eur_per_kwh / ?) AS battery_charging_costs_sum_sum, SUM(battery_discharging_power_sum) AS battery_discharging_power_sum_sum, SUM((COALESCE(battery_discharging_power_sum, ?) * pb_eur_per_kwh - COALESCE(battery_charging_power_sum, ?) * pf_eur_per_kwh) / ?) AS battery_savings_sum_sum, SUM(grid_export_power_sum) AS grid_export_power_sum_sum, SUM(grid_import_power_sum) AS grid_import_power_sum_sum, SUM(COALESCE(grid_import_power_sum,?) * pb_eur_per_kwh / ?) AS grid_costs_sum_sum, SUM(COALESCE(grid_export_power_sum,?) * pf_eur_per_kwh / ?) AS grid_revenue_sum_sum, SUM(heatpump_power_sum) AS heatpump_power_sum_sum, SUM(heatpump_power_grid_sum) AS heatpump_power_grid_sum_sum, SUM(heatpump_power_grid_sum * pb_eur_per_kwh / ?) AS heatpump_costs_grid_sum_sum, SUM(GREATEST(COALESCE(heatpump_power_sum,?) - COALESCE(heatpump_power_grid_sum,?), ?) / ? * pf_eur_per_kwh) AS heatpump_costs_pv_sum_sum, SUM(house_power_sum) AS house_power_sum_sum, SUM(house_power_grid_sum) AS house_power_grid_sum_sum, SUM(house_power_grid_sum * pb_eur_per_kwh / ?) AS house_costs_grid_sum_sum, SUM(GREATEST(COALESCE(house_power_sum,?) - COALESCE(house_power_grid_sum,?), ?) / ? * pf_eur_per_kwh) AS house_costs_pv_sum_sum, SUM(inverter_power_sum) AS inverter_power_sum_sum, SUM(inverter_power_1_sum) AS inverter_power_1_sum_sum, SUM(inverter_power_2_sum) AS inverter_power_2_sum_sum, SUM(inverter_power_3_sum) AS inverter_power_3_sum_sum, SUM(GREATEST((COALESCE(inverter_power_sum,?) - COALESCE(grid_export_power_sum,?)), ?) * pf_eur_per_kwh / ?) AS opportunity_costs_sum_sum, SUM(wallbox_power_sum) AS wallbox_power_sum_sum, SUM((COALESCE(house_power_sum,?) + COALESCE(heatpump_power_sum,?) + COALESCE(wallbox_power_sum,?)) * pb_eur_per_kwh / ?) AS traditional_costs_sum_sum, SUM(wallbox_power_grid_sum) AS wallbox_power_grid_sum_sum, SUM(wallbox_power_grid_sum * pb_eur_per_kwh / ?) AS wallbox_costs_grid_sum_sum, SUM(GREATEST(COALESCE(wallbox_power_sum,?) - COALESCE(wallbox_power_grid_sum,?), ?) / ? * pf_eur_per_kwh) AS wallbox_costs_pv_sum_sum FROM daily
code app/controllers/balance/stats_controller.rb:7	4%
Average Self 4.3ms Average calls 1x Total Self 4.3ms Total Children 90ms Total runtime 94ms `Balance::StatsController#index`
redis /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/cache/redis_cache_store.rb:464	3%
Average Self 3.7ms Average calls 1x Total Self 3.7ms Total Children 0ms Total runtime 3.7ms `pipeline`
redis app/lib/influx/poll_interval.rb:76	3%
Average Self 8.1ms Average calls 0.44x Total Self 3.6ms Total Children 0ms Total runtime 3.6ms `get`
rack /usr/local/bundle/gems/http_accept_language-2.1.1/lib/http_accept_language/middleware.rb:7	2%
Average Self 2.6ms Average calls 1x Total Self 2.6ms Total Children 94ms Total runtime 97ms `HttpAcceptLanguage::Middleware`
redis app/controllers/balance/stats_controller.rb:95	2%
Average Self 4.1ms Average calls 0.56x Total Self 2.3ms Total Children 0ms Total runtime 2.3ms `get`
redis app/lib/influx/poll_interval.rb:45	2%
Average Self 4.7ms Average calls 0.44x Total Self 2.1ms Total Children 0ms Total runtime 2.1ms `set`
redis app/lib/sensor/query/power_peak.rb:35	2%
Average Self 4.6ms Average calls 0.44x Total Self 2ms Total Children 0ms Total runtime 2ms `get`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/static.rb:26	2%
Average Self 1.9ms Average calls 1x Total Self 1.9ms Total Children 104ms Total runtime 106ms `ActionDispatch::Static`
sql app/models/summary.rb:67	1%
Average Self 2.8ms Average calls 0.56x Total Self 1.6ms Total Children 0ms Total runtime 1.6ms `SELECT gs.date FROM generate_series(?, ?, ?::interval) AS gs(date) LEFT JOIN summaries s ON s.date = gs.date WHERE s.date IS NULL OR s.date < ? AND s.updated_at < (s.date + INTERVAL ?) AT TIME ZONE ? AT TIME ZONE ? OR s.date >= ? AND s.updated_at < ?`
rack /usr/local/bundle/gems/railties-8.1.3/lib/rails/rack/logger.rb:20	<1%
Average Self 0.88ms Average calls 1x Total Self 0.88ms Total Children 103ms Total runtime 104ms `Rails::Rack::Logger`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/http/content_security_policy.rb:37	<1%
Average Self 0.56ms Average calls 1x Total Self 0.56ms Total Children 102ms Total runtime 103ms `ActionDispatch::ContentSecurityPolicy::Middleware`
rack /usr/local/bundle/gems/rack-attack-6.8.0/lib/rack/attack.rb:104	<1%
Average Self 0.5ms Average calls 1x Total Self 0.5ms Total Children 101ms Total runtime 101ms `Rack::Attack`
cache app/controllers/balance/stats_controller.rb:95	<1%
Average Self 0.56ms Average calls 0.56x Total Self 0.31ms Total Children 2.3ms Total runtime 2.6ms `read`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/etag.rb:28	<1%
Average Self 0.25ms Average calls 1x Total Self 0.25ms Total Children 101ms Total runtime 102ms `Rack::ETag`
cache /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158	<1%
Average Self 0.25ms Average calls 1x Total Self 0.25ms Total Children 3.7ms Total runtime 3.9ms `increment`
cache app/lib/influx/poll_interval.rb:76	<1%
Average Self 0.1ms Average calls 2.6x Total Self 0.25ms Total Children 3.6ms Total runtime 3.8ms `read`
cache app/controllers/balance/stats_controller.rb:52	<1%
Average Self 0.43ms Average calls 0.44x Total Self 0.19ms Total Children 6.6ms Total runtime 6.8ms `read`
cache app/lib/sensor/query/power_peak.rb:35	<1%
Average Self 0.43ms Average calls 0.44x Total Self 0.19ms Total Children 2ms Total runtime 2.2ms `read`
rack /usr/local/bundle/gems/rack-cors-3.0.0/lib/rack/cors.rb:66	<1%
Average Self 0.13ms Average calls 1x Total Self 0.13ms Total Children 106ms Total runtime 106ms `Rack::Cors`
rack Rack::Brotli	<1%
Average Self 0.13ms Average calls 1x Total Self 0.13ms Total Children 106ms Total runtime 106ms
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/request_id.rb:31	<1%
Average Self 0.13ms Average calls 1x Total Self 0.13ms Total Children 104ms Total runtime 104ms `ActionDispatch::RequestId`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/ssl.rb:88	<1%
Average Self 0.13ms Average calls 1x Total Self 0.13ms Total Children 106ms Total runtime 106ms `ActionDispatch::SSL`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/conditional_get.rb:28	<1%
Average Self 0.13ms Average calls 1x Total Self 0.13ms Total Children 102ms Total runtime 102ms `Rack::ConditionalGet`
rack ActionDispatch::Flash	<1%
Average Self 0.13ms Average calls 1x Total Self 0.13ms Total Children 103ms Total runtime 103ms
code /usr/local/bundle/gems/railties-8.1.3/lib/rails/engine.rb:532	<1%
Average Self 0.13ms Average calls 1x Total Self 0.13ms Total Children 106ms Total runtime 107ms `Rails::Engine#call`
cache app/lib/influx/poll_interval.rb:45	<1%
Average Self 0.29ms Average calls 0.44x Total Self 0.13ms Total Children 2.1ms Total runtime 2.2ms `write`
rack /usr/local/bundle/gems/rails-settings-cached-2.9.6/lib/rails-settings/middleware.rb:7	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 101ms Total runtime 101ms `RailsSettings::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/http/permissions_policy.rb:37	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 102ms Total runtime 102ms `ActionDispatch::PermissionsPolicy::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/show_exceptions.rb:31	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 103ms Total runtime 103ms `ActionDispatch::ShowExceptions`
rack /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/cache/strategy/local_cache_middleware.rb:28	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 104ms Total runtime 104ms `ActiveSupport::Cache::Strategy::LocalCache::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/callbacks.rb:28	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 103ms Total runtime 103ms `ActionDispatch::Callbacks`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/executor.rb:13	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 104ms Total runtime 104ms `ActionDispatch::Executor`
rack /usr/local/bundle/gems/request_store-1.7.0/lib/request_store/middleware.rb:16	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 104ms Total runtime 104ms `RequestStore::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/debug_exceptions.rb:30	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 103ms Total runtime 103ms `ActionDispatch::DebugExceptions`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/remote_ip.rb:95	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 104ms Total runtime 104ms `ActionDispatch::RemoteIp`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/tempfile_reaper.rb:16	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 101ms Total runtime 101ms `Rack::TempfileReaper`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/head.rb:14	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 102ms Total runtime 102ms `Rack::Head`
rack /usr/local/bundle/gems/honeybadger-6.9.0/lib/honeybadger/rack/error_notifier.rb:29	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 106ms Total runtime 106ms `Honeybadger::Rack::ErrorNotifier`
rack /usr/local/bundle/gems/honeybadger-6.9.0/lib/honeybadger/rack/user_feedback.rb:29	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 106ms Total runtime 106ms `Honeybadger::Rack::UserFeedback`
rack /usr/local/bundle/gems/railties-8.1.3/lib/rails/rack/silence_request.rb:27	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 104ms Total runtime 104ms `Rails::Rack::SilenceRequest`
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 104ms Total runtime 104ms `Rack::MethodOverride`
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 106ms Total runtime 106ms `Rack::Sendfile`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/deflater.rb:46	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 106ms Total runtime 106ms `Rack::Deflater`
rack /usr/local/bundle/gems/rack-session-2.1.2/lib/rack/session/abstract/id.rb:267	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 103ms Total runtime 103ms `ActionDispatch::Session::CookieStore`
rack /usr/local/bundle/gems/honeybadger-6.9.0/lib/honeybadger/rack/user_informer.rb:19	<1%
Average Self 0ms Average calls 1x Total Self 0ms Total Children 106ms Total runtime 106ms `Honeybadger::Rack::UserInformer`
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 106ms Total runtime 106ms `ActionDispatch::AssumeSSL`
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 103ms Total runtime 103ms `ActionDispatch::Cookies`

Slowest executions

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