SOLECTRUS

.MD

Heatpump::StatsController#index

…

Most impactful sections

code20%
view19%
http15%
redis14%
sql12%
rack9%
gc8%
unknown2%
cache1%


code app/controllers/heatpump/stats_controller.rb:7	20%
Average Self 15ms Average calls 1x Total Self 15ms Total Children 45ms Total runtime 61ms `Heatpump::StatsController#index`
view app/views/heatpump/stats/index.turbo_stream.slim	19%
Average Self 14ms Average calls 1x Total Self 14ms Total Children 25ms Total runtime 40ms
http app/lib/sensor/query/helpers/influx/base.rb:95	15%
Average Self 22ms Average calls 0.51x Total Self 11ms Total Children 0ms Total runtime 11ms `POST influxdb`
gc ruby/gc.c	8%
Average Self 6ms Average calls 0.98x Total Self 5.9ms Total Children 0ms Total runtime 5.9ms `GC.start`
sql app/lib/sensor/query/helpers/sql/total.rb:173	6%
Average Self 9.1ms Average calls 0.49x Total Self 4.5ms Total Children 0ms Total runtime 4.5ms 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 heatpump_heating_power_sum, AVG(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS heatpump_heating_power_avg, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS heatpump_power_sum, AVG(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS heatpump_power_avg, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS heatpump_power_grid_sum, AVG(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS heatpump_power_grid_avg, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS heatpump_tank_temp_sum, AVG(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS heatpump_tank_temp_avg, SUM(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS outdoor_temp_sum, AVG(sv.value) FILTER (WHERE sv.aggregation = ? AND sv.field = ?) AS outdoor_temp_avg, 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(heatpump_heating_power_sum) AS heatpump_heating_power_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, AVG(heatpump_tank_temp_avg) AS heatpump_tank_temp_avg_avg, AVG(outdoor_temp_avg) AS outdoor_temp_avg_avg FROM daily
sql app/models/summary.rb:59	5%
Average Self 7.3ms Average calls 0.49x Total Self 3.6ms Total Children 0ms Total runtime 3.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 < ?`
redis /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/cache/redis_cache_store.rb:464	4%
Average Self 3.3ms Average calls 1x Total Self 3.3ms Total Children 0ms Total runtime 3.3ms `pipeline`
redis app/lib/sensor/definitions/base.rb:39	4%
Average Self 3ms Average calls 0.98x Total Self 2.9ms Total Children 0ms Total runtime 2.9ms `get`
redis app/lib/influx/poll_interval.rb:45	4%
Average Self 5.5ms Average calls 0.51x Total Self 2.8ms Total Children 0ms Total runtime 2.8ms `set`
rack /usr/local/bundle/gems/http_accept_language-2.1.1/lib/http_accept_language/middleware.rb:7	3%
Average Self 2.2ms Average calls 1x Total Self 2.2ms Total Children 61ms Total runtime 63ms `HttpAcceptLanguage::Middleware`
redis app/lib/influx/poll_interval.rb:76	2%
Average Self 3.6ms Average calls 0.51x Total Self 1.9ms Total Children 0ms Total runtime 1.9ms `get`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/static.rb:26	2%
Average Self 1.6ms Average calls 1x Total Self 1.6ms Total Children 69ms Total runtime 71ms `ActionDispatch::Static`
rack /usr/local/bundle/gems/railties-8.1.3/lib/rails/rack/logger.rb:20	<1%
Average Self 0.67ms Average calls 1x Total Self 0.67ms Total Children 68ms Total runtime 69ms `Rails::Rack::Logger`
sql app/lib/sensor/summarizer.rb:123	<1%
Average Self 5.2ms Average calls 0.12x Total Self 0.6ms Total Children 0ms Total runtime 0.6ms 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/lib/sensor/definitions/base.rb:39	<1%
Average Self 0.45ms Average calls 0.98x Total Self 0.44ms Total Children 2.9ms Total runtime 3.3ms `read`
cache app/lib/influx/poll_interval.rb:76	<1%
Average Self 0.14ms Average calls 3.1x Total Self 0.42ms Total Children 1.9ms Total runtime 2.3ms `read`
rack /usr/local/bundle/gems/rack-attack-6.8.0/lib/rack/attack.rb:104	<1%
Average Self 0.35ms Average calls 1x Total Self 0.35ms Total Children 66ms Total runtime 67ms `Rack::Attack`
sql app/lib/sensor/summarizer.rb:55	<1%
Average Self 1.4ms Average calls 0.23x Total Self 0.33ms Total Children 0.02ms Total runtime 0.35ms `BEGIN SELECT "summaries".* FROM "summaries" WHERE "summaries"."date" = ? ORDER BY "summaries"."date" ASC LIMIT ?`
sql app/lib/sensor/summarizer.rb:36	<1%
Average Self 2.2ms Average calls 0.12x Total Self 0.26ms Total Children 0ms Total runtime 0.26ms `COMMIT`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/etag.rb:28	<1%
Average Self 0.23ms Average calls 1x Total Self 0.23ms Total Children 67ms Total runtime 67ms `Rack::ETag`
rack /usr/local/bundle/gems/rack-cors-3.0.0/lib/rack/cors.rb:66	<1%
Average Self 0.23ms Average calls 1x Total Self 0.23ms Total Children 71ms Total runtime 71ms `Rack::Cors`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/http/content_security_policy.rb:37	<1%
Average Self 0.21ms Average calls 1x Total Self 0.21ms Total Children 67ms Total runtime 67ms `ActionDispatch::ContentSecurityPolicy::Middleware`
sql app/lib/sensor/summarizer.rb:135	<1%
Average Self 1.8ms Average calls 0.12x Total Self 0.21ms Total Children 0ms Total runtime 0.21ms `DELETE FROM "summary_values" WHERE "summary_values"."date" = ? AND "summary_values"."aggregation" = ? AND ("summary_values"."field" = ? OR "summary_values"."field" = ? OR "summary_values"."field" = ? OR "summary_values"."field" = ? OR "summary_values"."field" = ? OR "summary_values"."field" = ?)`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/show_exceptions.rb:31	<1%
Average Self 0.19ms Average calls 1x Total Self 0.19ms Total Children 68ms Total runtime 68ms `ActionDispatch::ShowExceptions`
sql app/lib/sensor/summarizer.rb:63	<1%
Average Self 1.2ms Average calls 0.12x Total Self 0.14ms Total Children 0ms Total runtime 0.14ms `UPDATE "summaries" SET "updated_at" = ? WHERE "summaries"."date" = ?`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/head.rb:14	<1%
Average Self 0.12ms Average calls 1x Total Self 0.12ms Total Children 67ms Total runtime 67ms `Rack::Head`
rack /usr/local/bundle/gems/honeybadger-6.6.0/lib/honeybadger/rack/error_notifier.rb:29	<1%
Average Self 0.12ms Average calls 1x Total Self 0.12ms Total Children 71ms Total runtime 71ms `Honeybadger::Rack::ErrorNotifier`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/conditional_get.rb:28	<1%
Average Self 0.12ms Average calls 1x Total Self 0.12ms Total Children 67ms Total runtime 67ms `Rack::ConditionalGet`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/executor.rb:13	<1%
Average Self 0.09ms Average calls 1x Total Self 0.09ms Total Children 69ms Total runtime 69ms `ActionDispatch::Executor`
cache /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158	<1%
Average Self 0.09ms Average calls 1x Total Self 0.09ms Total Children 3.3ms Total runtime 3.4ms `increment`
code /usr/local/bundle/gems/railties-8.1.3/lib/rails/engine.rb:532	<1%
Average Self 0.09ms Average calls 1x Total Self 0.09ms Total Children 71ms Total runtime 71ms `Rails::Engine#call`
rack /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/cache/strategy/local_cache_middleware.rb:28	<1%
Average Self 0.09ms Average calls 1x Total Self 0.09ms 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 0.09ms Average calls 1x Total Self 0.09ms Total Children 67ms Total runtime 67ms `ActionDispatch::PermissionsPolicy::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/ssl.rb:88	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 71ms Total runtime 71ms `ActionDispatch::SSL`
cache app/lib/influx/poll_interval.rb:45	<1%
Average Self 0.14ms Average calls 0.51x Total Self 0.07ms Total Children 2.8ms Total runtime 2.9ms `write`
rack ActionDispatch::Flash	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 67ms Total runtime 68ms
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/cookies.rb:706	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms 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 0.07ms Average calls 1x Total Self 0.07ms Total Children 68ms Total runtime 68ms `ActionDispatch::Callbacks`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/request_id.rb:31	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 69ms Total runtime 69ms `ActionDispatch::RequestId`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/remote_ip.rb:95	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 69ms Total runtime 69ms `ActionDispatch::RemoteIp`
rack /usr/local/bundle/gems/rack-session-2.1.2/lib/rack/session/abstract/id.rb:267	<1%
Average Self 0.07ms Average calls 1x Total Self 0.07ms Total Children 68ms Total runtime 68ms `ActionDispatch::Session::CookieStore`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/sendfile.rb:130	<1%
Average Self 0.05ms Average calls 1x Total Self 0.05ms Total Children 71ms Total runtime 71ms `Rack::Sendfile`
rack /usr/local/bundle/gems/request_store-1.7.0/lib/request_store/middleware.rb:16	<1%
Average Self 0.05ms Average calls 1x Total Self 0.05ms Total Children 69ms Total runtime 69ms `RequestStore::Middleware`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/tempfile_reaper.rb:16	<1%
Average Self 0.05ms Average calls 1x Total Self 0.05ms Total Children 67ms Total runtime 67ms `Rack::TempfileReaper`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/method_override.rb:19	<1%
Average Self 0.05ms Average calls 1x Total Self 0.05ms Total Children 69ms Total runtime 69ms `Rack::MethodOverride`
rack /usr/local/bundle/gems/honeybadger-6.6.0/lib/honeybadger/rack/user_feedback.rb:29	<1%
Average Self 0.02ms Average calls 1x Total Self 0.02ms Total Children 71ms Total runtime 71ms `Honeybadger::Rack::UserFeedback`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/debug_exceptions.rb:30	<1%
Average Self 0.02ms Average calls 1x Total Self 0.02ms Total Children 68ms Total runtime 68ms `ActionDispatch::DebugExceptions`
cache app/services/update_check/cache_manager.rb:77	<1%
Average Self 0.33ms Average calls 0.07x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `read`
rack Rack::Brotli	<1%
Average Self 0.02ms Average calls 1x Total Self 0.02ms Total Children 71ms Total runtime 71ms
rack /usr/local/bundle/gems/rails-settings-cached-2.9.6/lib/rails-settings/middleware.rb:7	<1%
Average Self 0.02ms Average calls 1x Total Self 0.02ms Total Children 67ms Total runtime 67ms `RailsSettings::Middleware`
cache app/lib/sensor/definitions/base.rb:38	<1%
Average Self 1ms Average calls 0.02x Total Self 0.02ms Total Children 0ms Total runtime 0.02ms `read`
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 71ms Total runtime 71ms `Honeybadger::Rack::UserInformer`
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 71ms Total runtime 71ms `Rack::Deflater`
redis app/lib/sensor/definitions/base.rb:38	<1%
Average Self 0ms Average calls 0.02x Total Self 0ms Total Children 0ms Total runtime 0ms `get`
redis app/services/update_check/cache_manager.rb:77	<1%
Average Self 0ms Average calls 0.07x Total Self 0ms Total Children 0ms Total runtime 0ms `get`
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 71ms Total runtime 71ms `ActionDispatch::AssumeSSL`
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 69ms Total runtime 69ms `Rails::Rack::SilenceRequest`

Slowest executions

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