SOLECTRUS

.MD

/inverter/stats/inverter_power/2026-05-24

24 May 09:29

total runtime

105ms

Most impactful sections

code63%
sql16%
gc7%
view5%
unknown4%
rack4%
redis<1%
cache<1%


code app/controllers/inverter/stats_controller.rb:7	63%
Average Self 66ms Calls 1x Total Self 66ms Total Children 26ms Total runtime 92ms `Inverter::StatsController#index`
gc ruby/gc.c	7%
Average Self 7ms Calls 1x Total Self 7ms Total Children 0ms Total runtime 7ms `GC.start`
sql app/lib/sensor/summarizer.rb:123	5%
Average Self 5ms Calls 1x Total Self 5ms Total Children 0ms Total runtime 5ms INSERT INTO "summary_values" ("field","aggregation","value","date") VALUES (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?) ON CONFLICT ("date","aggregation","field") DO UPDATE SET "value"=excluded."value" RETURNING "date","aggregation","field"
view app/views/inverter/stats/index.turbo_stream.slim	5%
Average Self 5ms Calls 1x Total Self 5ms Total Children 2ms Total runtime 7ms
sql app/models/summary.rb:59	4%
Average Self 4ms Calls 1x Total Self 4ms Total Children 0ms Total runtime 4ms `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 < ?`
sql app/lib/sensor/summarizer.rb:55	3%
Average Self 1.5ms Calls 2x Total Self 3ms Total Children 0ms Total runtime 3ms `BEGIN SELECT "summaries".* FROM "summaries" WHERE "summaries"."date" = ? ORDER BY "summaries"."date" ASC LIMIT ?`
sql app/lib/sensor/summarizer.rb:36	2%
Average Self 2ms Calls 1x Total Self 2ms Total Children 0ms Total runtime 2ms `COMMIT`
sql app/lib/sensor/summarizer.rb:135	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms `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" = ?)`
rack /usr/local/bundle/gems/rack-cors-3.0.0/lib/rack/cors.rb:66	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 97ms Total runtime 98ms `Rack::Cors`
sql app/lib/sensor/summarizer.rb:63	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms `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 1ms Calls 1x Total Self 1ms Total Children 95ms Total runtime 96ms `ActionDispatch::ContentSecurityPolicy::Middleware`
sql app/lib/sensor/query/helpers/sql/total.rb:173	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms WITH daily AS ( SELECT sv.date, 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 FROM summary_values sv WHERE sv.date BETWEEN DATE ? AND DATE ? AND sv.aggregation IN (?) AND sv.field IN (?) GROUP BY sv.date ) SELECT 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 FROM daily
rack /usr/local/bundle/gems/http_accept_language-2.1.1/lib/http_accept_language/middleware.rb:7	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 92ms Total runtime 93ms `HttpAcceptLanguage::Middleware`
cache /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/notifications/fanout.rb:158	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 1ms Total runtime 2ms `increment`
redis /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/cache/redis_cache_store.rb:464	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 0ms Total runtime 1ms `pipeline`
rack /usr/local/bundle/gems/railties-8.1.3/lib/rails/rack/logger.rb:20	<1%
Average Self 1ms Calls 1x Total Self 1ms Total Children 96ms Total runtime 97ms `Rails::Rack::Logger`
rack /usr/local/bundle/gems/railties-8.1.3/lib/rails/rack/silence_request.rb:27	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `Rails::Rack::SilenceRequest`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/remote_ip.rb:95	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `ActionDispatch::RemoteIp`
rack /usr/local/bundle/gems/request_store-1.7.0/lib/request_store/middleware.rb:16	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `RequestStore::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/request_id.rb:31	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `ActionDispatch::RequestId`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/method_override.rb:19	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `Rack::MethodOverride`
rack /usr/local/bundle/gems/activesupport-8.1.3/lib/active_support/cache/strategy/local_cache_middleware.rb:28	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `ActiveSupport::Cache::Strategy::LocalCache::Middleware`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/executor.rb:13	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `ActionDispatch::Executor`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/static.rb:26	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `ActionDispatch::Static`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/sendfile.rb:130	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `Rack::Sendfile`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/ssl.rb:88	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `ActionDispatch::SSL`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/assume_ssl.rb:18	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `ActionDispatch::AssumeSSL`
rack /usr/local/bundle/gems/honeybadger-6.6.1/lib/honeybadger/rack/error_notifier.rb:29	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `Honeybadger::Rack::ErrorNotifier`
rack /usr/local/bundle/gems/honeybadger-6.6.1/lib/honeybadger/rack/user_informer.rb:19	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `Honeybadger::Rack::UserInformer`
rack Rack::Brotli	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/deflater.rb:46	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `Rack::Deflater`
code /usr/local/bundle/gems/railties-8.1.3/lib/rails/engine.rb:532	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 98ms Total runtime 98ms `Rails::Engine#call`
rack /usr/local/bundle/gems/honeybadger-6.6.1/lib/honeybadger/rack/user_feedback.rb:29	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 97ms Total runtime 97ms `Honeybadger::Rack::UserFeedback`
redis app/lib/sensor/definitions/base.rb:39	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 0ms Total runtime 0ms `get`
cache app/lib/sensor/definitions/base.rb:39	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 0ms Total runtime 0ms `read`
rack /usr/local/bundle/gems/rack-attack-6.8.0/lib/rack/attack.rb:104	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 95ms Total runtime 95ms `Rack::Attack`
rack /usr/local/bundle/gems/rails-settings-cached-2.9.6/lib/rails-settings/middleware.rb:7	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 95ms Total runtime 95ms `RailsSettings::Middleware`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/tempfile_reaper.rb:16	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 95ms Total runtime 95ms `Rack::TempfileReaper`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/etag.rb:28	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 95ms Total runtime 95ms `Rack::ETag`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/conditional_get.rb:28	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 95ms Total runtime 95ms `Rack::ConditionalGet`
rack /usr/local/bundle/gems/rack-3.2.6/lib/rack/head.rb:14	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 95ms Total runtime 95ms `Rack::Head`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/http/permissions_policy.rb:37	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 95ms Total runtime 95ms `ActionDispatch::PermissionsPolicy::Middleware`
rack ActionDispatch::Flash	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 96ms Total runtime 96ms
rack /usr/local/bundle/gems/rack-session-2.1.2/lib/rack/session/abstract/id.rb:267	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 96ms Total runtime 96ms `ActionDispatch::Session::CookieStore`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/cookies.rb:706	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 96ms Total runtime 96ms `ActionDispatch::Cookies`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/callbacks.rb:28	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 96ms Total runtime 96ms `ActionDispatch::Callbacks`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/debug_exceptions.rb:30	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 96ms Total runtime 96ms `ActionDispatch::DebugExceptions`
rack /usr/local/bundle/gems/actionpack-8.1.3/lib/action_dispatch/middleware/show_exceptions.rb:31	<1%
Average Self 0ms Calls 1x Total Self 0ms Total Children 96ms Total runtime 96ms `ActionDispatch::ShowExceptions`

Server

	Load	CPU	RAM	Swap	Disk
app.demo.solectrus.de	Load avg 3%	CPU 5%	RAM 80%	Swap 66%	Disk 16%

Deployment

v1.1.1-304-gf0cc7ea

24 May 05:54