apiVersion: jenkins.io/v1 kind: PipelineActivity metadata: annotations: lighthouse.jenkins-x.io/cloneURI: https://github.com/greencapitaltrade/bifrost.git lighthouse.jenkins-x.io/job: release pipeline.jenkins-x.io/traceID: 18af49641d9c73cd55216f14d463660a creationTimestamp: "2026-08-12T11:33:55Z" generation: 7 labels: branch: main build: "205" buildID: "1786534365631" context: release created-by-lighthouse: "true" event-GUID: 8f829750-9640-11f1-9097-777ed081c99e lighthouse.jenkins-x.io/baseSHA: 4dca8078be3465376f18c1961ffc07722c7e3916 lighthouse.jenkins-x.io/branch: main lighthouse.jenkins-x.io/buildNum: "1786534365631" lighthouse.jenkins-x.io/context: release lighthouse.jenkins-x.io/id: apitaltrade-bifrost-main-release-hp8g7 lighthouse.jenkins-x.io/job: release lighthouse.jenkins-x.io/lastCommitSHA: 4dca8078be3465376f18c1961ffc07722c7e3916 lighthouse.jenkins-x.io/refs.org: greencapitaltrade lighthouse.jenkins-x.io/refs.repo: bifrost lighthouse.jenkins-x.io/type: postsubmit owner: greencapitaltrade podName: apitaltrade-bifrost-main-release-q49cv-from-build-pack-pod provider: github repository: bifrost tekton.dev/pipeline: apitaltrade-bifrost-main-release managedFields: - apiVersion: jenkins.io/v1 fieldsType: FieldsV1 fieldsV1: f:metadata: f:labels: .: {} f:branch: {} f:build: {} f:buildID: {} f:owner: {} f:repository: {} f:spec: .: {} f:batchPipelineActivity: {} f:build: {} f:gitBranch: {} f:gitOwner: {} f:gitRepository: {} f:pipeline: {} manager: jx-gitops-1.3.15 operation: Update time: "2026-08-12T11:33:55Z" - apiVersion: jenkins.io/v1 fieldsType: FieldsV1 fieldsV1: f:metadata: f:labels: f:context: {} f:provider: {} f:spec: f:lastCommitMessage: {} f:lastCommitSHA: {} f:releaseNotesURL: {} f:version: {} manager: jx-changelog-0.10.29 operation: Update time: "2026-08-12T11:39:08Z" - apiVersion: jenkins.io/v1 fieldsType: FieldsV1 fieldsV1: f:metadata: f:annotations: .: {} f:lighthouse.jenkins-x.io/cloneURI: {} f:lighthouse.jenkins-x.io/job: {} f:labels: f:created-by-lighthouse: {} f:event-GUID: {} f:lighthouse.jenkins-x.io/baseSHA: {} f:lighthouse.jenkins-x.io/branch: {} f:lighthouse.jenkins-x.io/buildNum: {} f:lighthouse.jenkins-x.io/context: {} f:lighthouse.jenkins-x.io/id: {} f:lighthouse.jenkins-x.io/job: {} f:lighthouse.jenkins-x.io/lastCommitSHA: {} f:lighthouse.jenkins-x.io/refs.org: {} f:lighthouse.jenkins-x.io/refs.repo: {} f:lighthouse.jenkins-x.io/type: {} f:podName: {} f:tekton.dev/pipeline: {} f:spec: f:baseSHA: {} f:completedTimestamp: {} f:context: {} f:gitUrl: {} f:message: {} f:startedTimestamp: {} f:status: {} f:steps: {} manager: jx-build-controller operation: Update time: "2026-08-12T12:05:38Z" name: greencapitaltrade-bifrost-main-205 namespace: jx resourceVersion: "263704950" uid: 45c0716c-19f1-4080-9f64-7d37aca22c8d spec: baseSHA: 4dca8078be3465376f18c1961ffc07722c7e3916 batchPipelineActivity: {} build: "205" buildLogsUrl: s3://logs-gct-prod-20260425045301534100000007/jenkins-x/logs/greencapitaltrade/bifrost/main/205.log completedTimestamp: "2026-08-12T11:41:37Z" context: release gitBranch: main gitOwner: greencapitaltrade gitRepository: bifrost gitUrl: https://github.com/greencapitaltrade/bifrost.git lastCommitMessage: | perf(asset): read charge state from device_state, cache state definitions _compute_charge_state ran a DISTINCT ON over report_energy_v — the ~9M-row telemetry table through a 3-table view, with no (asset_id, timestamp) index and no early termination — on every asset list page and every detail read. Cost scaled with an asset's telemetry history: a live asset's detail read took 15-30s in production and a limit>=120 list page timed out outright, even selecting only id+status. Ingestion already deep-merges every measurement into device_state with replay protection, so the latest energy reading is a dict lookup on the device. Read that first (battery_soc/level_percent, current_ma/current_a scaled to mA; per key the freshest 'at' across the asset's devices wins). The history scan survives only for assets whose devices carry no energy keys in state — pre-device_state hardware and GPS-only trackers, for which it is cheap. depends() now includes device_state so new frames invalidate the compute. Also ormcache get_state_definitions' registry lookup per capability-code set (invalidated on any feature/feature-data write): it ran per device per serialized row, so a 50-row page fired hundreds of identical searches via the state payload and derive_iot_status. Co-Authored-By: Claude Fable 5 lastCommitSHA: 4c34dfbe68a0de3844bec4ab58f6c74c851127fd message: 'Tasks Completed: 1 (Failed: 0, Cancelled 0), Skipped: 0' pipeline: greencapitaltrade/bifrost/main releaseNotesURL: https://github.com/greencapitaltrade/bifrost/releases/tag/v6.95.1 startedTimestamp: "2026-08-12T11:34:39Z" status: Succeeded steps: - kind: Stage stage: completedTimestamp: "2026-08-12T11:41:37Z" name: from build pack startedTimestamp: "2026-08-12T11:33:25Z" status: Succeeded steps: - completedTimestamp: "2026-08-12T11:33:46Z" name: Git Clone startedTimestamp: "2026-08-12T11:33:25Z" status: Succeeded - completedTimestamp: "2026-08-12T11:33:52Z" name: Next Version startedTimestamp: "2026-08-12T11:33:46Z" status: Succeeded - completedTimestamp: "2026-08-12T11:33:57Z" name: Jx Variables startedTimestamp: "2026-08-12T11:33:52Z" status: Succeeded - completedTimestamp: "2026-08-12T11:34:00Z" name: Setup Pip Cache startedTimestamp: "2026-08-12T11:33:57Z" status: Succeeded - completedTimestamp: "2026-08-12T11:34:03Z" name: Process Config Templates startedTimestamp: "2026-08-12T11:34:02Z" status: Succeeded - completedTimestamp: "2026-08-12T11:34:03Z" name: Update Asset Management Version startedTimestamp: "2026-08-12T11:34:03Z" status: Succeeded - completedTimestamp: "2026-08-12T11:34:11Z" name: Check Registry startedTimestamp: "2026-08-12T11:34:08Z" status: Succeeded - completedTimestamp: "2026-08-12T11:38:55Z" name: Build Container Build startedTimestamp: "2026-08-12T11:34:13Z" status: Succeeded - completedTimestamp: "2026-08-12T11:39:08Z" name: Promote Changelog startedTimestamp: "2026-08-12T11:38:55Z" status: Succeeded - completedTimestamp: "2026-08-12T11:39:15Z" name: Promote Helm Release startedTimestamp: "2026-08-12T11:39:08Z" status: Succeeded - completedTimestamp: "2026-08-12T11:40:45Z" name: Promote Jx Promote startedTimestamp: "2026-08-12T11:39:15Z" status: Succeeded - completedTimestamp: "2026-08-12T11:41:37Z" name: Publish Org Kb startedTimestamp: "2026-08-12T11:40:46Z" status: Succeeded - kind: Promote promote: environment: staging pullRequest: pullRequestURL: https://github.com/greencapitaltrade/mcu/pull/5381 startedTimestamp: "2026-08-12T11:40:10Z" status: Succeeded startedTimestamp: "2026-08-12T11:40:10Z" status: Succeeded - kind: Promote promote: environment: production pullRequest: pullRequestURL: https://github.com/greencapitaltrade/mcu/pull/5382 startedTimestamp: "2026-08-12T11:40:42Z" status: Succeeded startedTimestamp: "2026-08-12T11:40:42Z" status: Succeeded version: 6.95.1 status: {}