SOLECTRUS

.MD

Balance::StatsController#index

…

Most impactful sections

code30%
view25%
sql18%
gc8%
redis7%
http5%
rack5%
unknown1%
cache<1%


code app/controllers/balance/stats_controller.rb:7	30%
Average Self 51ms Average calls 1x Total Self 51ms Total Children 91ms Total runtime 142ms `Balance::StatsController#index`
view app/views/balance/stats/index.turbo_stream.slim	25%
Average Self 43ms Average calls 1x Total Self 43ms Total Children 31ms Total runtime 75ms
sql app/lib/sensor/query/helpers/sql/total.rb:173	9%
Average Self 19ms Average calls 0.83x Total Self 15ms Total Children 0ms Total runtime 15ms 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
gc ruby/gc.c	8%
Average Self 16ms Average calls 0.85x Total Self 14ms Total Children 0ms Total runtime 14ms `GC.start`
sql app/models/summary.rb:59	6%
Average Self 11ms Average calls 0.83x Total Self 9.8ms Total Children 0ms Total runtime 9.8ms `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 < ?`
http app/lib/sensor/query/helpers/influx/base.rb:95	5%
Average Self 49ms Average calls 0.17x Total Self 8.2ms Total Children 0ms Total runtime 8.2ms `POST influxdb`
redis /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/cache/redis_cache_store.rb:464	3%
Average Self 5.7ms Average calls 1x Total Self 5.7ms Total Children 0ms Total runtime 5.7ms `pipeline`
redis app/controllers/balance/stats_controller.rb:95	2%
Average Self 4.4ms Average calls 0.85x Total Self 3.7ms Total Children 0ms Total runtime 3.7ms `get`
sql app/lib/sensor/summarizer.rb:55	2%
Average Self 6.3ms Average calls 0.54x Total Self 3.4ms Total Children 2.6ms Total runtime 6ms `BEGIN SELECT "summaries".* FROM "summaries" WHERE "summaries"."date" = ? ORDER BY "summaries"."date" ASC LIMIT ?`
rack /usr/local/bundle/gems/http_accept_language-2.1.1/lib/http_accept_language/middleware.rb:7	1%
Average Self 2.2ms Average calls 1x Total Self 2.2ms Total Children 142ms Total runtime 145ms `HttpAcceptLanguage::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/static.rb:26	1%
Average Self 2ms Average calls 1x Total Self 2ms Total Children 155ms Total runtime 157ms `ActionDispatch::Static`
redis app/lib/influx/poll_interval.rb:45	<1%
Average Self 11ms Average calls 0.15x Total Self 1.7ms Total Children 0ms Total runtime 1.7ms `set`
sql app/lib/sensor/summarizer.rb:123	<1%
Average Self 5ms Average calls 0.27x Total Self 1.4ms Total Children 0ms Total runtime 1.4ms INSERT INTO "summary_values" ("field","aggregation","value","date") VALUES (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?) ON CONFLICT ("date","aggregation","field") DO UPDATE SET "value"=excluded."value" RETURNING "date","aggregation","field"
cache app/controllers/balance/stats_controller.rb:95	<1%
Average Self 1.5ms Average calls 0.85x Total Self 1.3ms Total Children 3.7ms Total runtime 5ms `read`
rack /usr/local/bundle/gems/railties-8.1.3/lib/rails/rack/logger.rb:20	<1%
Average Self 0.63ms Average calls 1x Total Self 0.63ms Total Children 153ms Total runtime 154ms `Rails::Rack::Logger`
sql app/lib/sensor/summarizer.rb:36	<1%
Average Self 2.2ms Average calls 0.27x Total Self 0.58ms Total Children 0ms Total runtime 0.58ms `COMMIT`
rack /usr/local/bundle/gems/rack-attack-6.8.0/lib/rack/attack.rb:104	<1%
Average Self 0.54ms Average calls 1x Total Self 0.54ms Total Children 151ms Total runtime 152ms `Rack::Attack`
redis /usr/local/bundle/gems/redis-5.4.1/lib/redis/commands/server.rb:90	<1%
Average Self 26ms Average calls 0.02x Total Self 0.54ms Total Children 0ms Total runtime 0.54ms `info`
sql app/lib/sensor/summarizer.rb:63	<1%
Average Self 1.3ms Average calls 0.27x Total Self 0.35ms Total Children 0ms Total runtime 0.35ms `UPDATE "summaries" SET "updated_at" = ? WHERE "summaries"."date" = ?`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/http/content_security_policy.rb:37	<1%
Average Self 0.31ms Average calls 1x Total Self 0.31ms Total Children 153ms Total runtime 153ms `ActionDispatch::ContentSecurityPolicy::Middleware`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/etag.rb:28	<1%
Average Self 0.29ms Average calls 1x Total Self 0.29ms Total Children 152ms Total runtime 152ms `Rack::ETag`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/executor.rb:13	<1%
Average Self 0.19ms Average calls 1x Total Self 0.19ms Total Children 154ms Total runtime 155ms `ActionDispatch::Executor`
cache /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158	<1%
Average Self 0.17ms Average calls 1x Total Self 0.17ms Total Children 6.3ms Total runtime 6.4ms `increment`
redis app/lib/sensor/query/power_peak.rb:35	<1%
Average Self 1ms Average calls 0.15x Total Self 0.15ms Total Children 0ms Total runtime 0.15ms `get`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/request_id.rb:31	<1%
Average Self 0.15ms Average calls 1x Total Self 0.15ms Total Children 154ms Total runtime 154ms `ActionDispatch::RequestId`
redis app/controllers/balance/stats_controller.rb:52	<1%
Average Self 1ms Average calls 0.15x Total Self 0.15ms Total Children 0ms Total runtime 0.15ms `get`
redis app/services/update_check/cache_manager.rb:77	<1%
Average Self 0.86ms Average calls 0.15x Total Self 0.13ms Total Children 0ms Total runtime 0.13ms `get`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/show_exceptions.rb:31	<1%
Average Self 0.13ms Average calls 1x Total Self 0.13ms Total Children 153ms Total runtime 153ms `ActionDispatch::ShowExceptions`
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 152ms Total runtime 152ms `Rack::ConditionalGet`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/debug_exceptions.rb:30	<1%
Average Self 0.1ms Average calls 1x Total Self 0.1ms Total Children 153ms Total runtime 153ms `ActionDispatch::DebugExceptions`
rack /usr/local/bundle/gems/rack-cors-3.0.0/lib/rack/cors.rb:66	<1%
Average Self 0.1ms Average calls 1x Total Self 0.1ms Total Children 157ms Total runtime 157ms `Rack::Cors`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/method_override.rb:19	<1%
Average Self 0.1ms Average calls 1x Total Self 0.1ms Total Children 154ms Total runtime 154ms `Rack::MethodOverride`
sql app/models/price.rb:54	<1%
Average Self 2.5ms Average calls 0.04x Total Self 0.1ms Total Children 0ms Total runtime 0.1ms `SELECT "prices"."value" FROM "prices" WHERE "prices"."name" = ? AND "prices"."starts_at" <= ? ORDER BY "prices"."starts_at" DESC LIMIT ?`
redis app/lib/influx/poll_interval.rb:76	<1%
Average Self 0.71ms Average calls 0.15x Total Self 0.1ms Total Children 0ms Total runtime 0.1ms `get`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/tempfile_reaper.rb:16	<1%
Average Self 0.08ms Average calls 1x Total Self 0.08ms Total Children 152ms Total runtime 152ms `Rack::TempfileReaper`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/cookies.rb:706	<1%
Average Self 0.08ms Average calls 1x Total Self 0.08ms Total Children 153ms Total runtime 153ms `ActionDispatch::Cookies`
rack /usr/local/bundle/gems/honeybadger-6.6.0/lib/honeybadger/rack/error_notifier.rb:29	<1%
Average Self 0.08ms Average calls 1x Total Self 0.08ms Total Children 157ms Total runtime 157ms `Honeybadger::Rack::ErrorNotifier`
rack /usr/local/bundle/gems/honeybadger-6.6.0/lib/honeybadger/rack/user_informer.rb:19	<1%
Average Self 0.08ms Average calls 1x Total Self 0.08ms Total Children 157ms Total runtime 157ms `Honeybadger::Rack::UserInformer`
cache app/lib/influx/poll_interval.rb:76	<1%
Average Self 0.1ms Average calls 0.88x Total Self 0.08ms Total Children 0.1ms Total runtime 0.19ms `read`
code /usr/local/bundle/gems/railties-8.1.3/lib/rails/engine.rb:532	<1%
Average Self 0.08ms Average calls 1x Total Self 0.08ms Total Children 157ms Total runtime 157ms `Rails::Engine#call`
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 153ms Total runtime 153ms `ActionDispatch::Callbacks`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/ssl.rb:88	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 157ms Total runtime 157ms `ActionDispatch::SSL`
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 152ms Total runtime 152ms `Rack::Head`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/sendfile.rb:130	<1%
Average Self 0.06ms Average calls 1x Total Self 0.06ms Total Children 157ms Total runtime 157ms `Rack::Sendfile`
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 154ms Total runtime 154ms `RequestStore::Middleware`
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 152ms Total runtime 152ms `RailsSettings::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/http/permissions_policy.rb:37	<1%
Average Self 0.04ms Average calls 1x Total Self 0.04ms Total Children 152ms Total runtime 153ms `ActionDispatch::PermissionsPolicy::Middleware`
cache app/controllers/balance/stats_controller.rb:52	<1%
Average Self 0.29ms Average calls 0.15x Total Self 0.04ms Total Children 0.15ms Total runtime 0.19ms `read`
rack /usr/local/bundle/gems/rack-session-2.1.2/lib/rack/session/abstract/id.rb:267	<1%
Average Self 0.04ms Average calls 1x Total Self 0.04ms Total Children 153ms Total runtime 153ms `ActionDispatch::Session::CookieStore`
rack Rack::Brotli	<1%
Average Self 0.04ms Average calls 1x Total Self 0.04ms Total Children 157ms Total runtime 157ms
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/remote_ip.rb:95	<1%
Average Self 0.04ms Average calls 1x Total Self 0.04ms Total Children 154ms Total runtime 154ms `ActionDispatch::RemoteIp`
cache app/services/update_check/cache_manager.rb:77	<1%
Average Self 0.29ms Average calls 0.15x Total Self 0.04ms Total Children 0.13ms Total runtime 0.17ms `read`
rack ActionDispatch::Flash	<1%
Average Self 0.04ms Average calls 1x Total Self 0.04ms Total Children 153ms Total runtime 153ms
rack /usr/local/bundle/gems/railties-8.1.3/lib/rails/rack/silence_request.rb:27	<1%
Average Self 0.04ms Average calls 1x Total Self 0.04ms Total Children 154ms Total runtime 154ms `Rails::Rack::SilenceRequest`
rack /usr/local/bundle/gems/honeybadger-6.6.0/lib/honeybadger/rack/user_feedback.rb:29	<1%
Average Self 0.04ms Average calls 1x Total Self 0.04ms Total Children 157ms Total runtime 157ms `Honeybadger::Rack::UserFeedback`
rack /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/cache/strategy/local_cache_middleware.rb:28	<1%
Average Self 0.04ms Average calls 1x Total Self 0.04ms Total Children 154ms Total runtime 154ms `ActiveSupport::Cache::Strategy::LocalCache::Middleware`
redis app/lib/sensor/query/helpers/influx/base.rb:79	<1%
Average Self 0.5ms Average calls 0.04x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `get`
cache app/lib/sensor/query/power_peak.rb:35	<1%
Average Self 0.14ms Average calls 0.15x Total Self 0.02ms Total Children 0.15ms Total runtime 0.17ms `read`
cache app/lib/sensor/query/helpers/influx/base.rb:79	<1%
Average Self 0.5ms Average calls 0.04x Total Self 0.02ms Total Children 0.02ms Total runtime 0.04ms `read write`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/deflater.rb:46	<1%
Average Self 0.02ms Average calls 1x Total Self 0.02ms Total Children 157ms Total runtime 157ms `Rack::Deflater`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/assume_ssl.rb:18	<1%
Average Self 0.02ms Average calls 1x Total Self 0.02ms Total Children 157ms Total runtime 157ms `ActionDispatch::AssumeSSL`
cache app/lib/influx/poll_interval.rb:45	<1%
Average Self 0.14ms Average calls 0.15x Total Self 0.02ms Total Children 1.7ms Total runtime 1.7ms `write`

Slowest executions

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