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: 9fa52286bfc6325caa7e3c4a7fe768ea creationTimestamp: "2026-08-12T12:38:22Z" generation: 7 labels: branch: main build: "207" buildID: "1786538272759" created-by-lighthouse: "true" event-GUID: c106876a-9649-11f1-9941-386337824e0c lighthouse.jenkins-x.io/baseSHA: 5665ff0b3f87861f80bdfc536cb1ac1b4daad8bf lighthouse.jenkins-x.io/branch: main lighthouse.jenkins-x.io/buildNum: "1786538272759" lighthouse.jenkins-x.io/context: release lighthouse.jenkins-x.io/id: apitaltrade-bifrost-main-release-vvv46 lighthouse.jenkins-x.io/job: release lighthouse.jenkins-x.io/lastCommitSHA: 5665ff0b3f87861f80bdfc536cb1ac1b4daad8bf 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-jcfch-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-12T12:38:22Z" - apiVersion: jenkins.io/v1 fieldsType: FieldsV1 fieldsV1: f:spec: f:lastCommitMessage: {} f:lastCommitSHA: {} f:releaseNotesURL: {} f:version: {} manager: jx-changelog-0.10.29 operation: Update time: "2026-08-12T12:41:07Z" - apiVersion: jenkins.io/v1 fieldsType: FieldsV1 fieldsV1: f:metadata: f:labels: f:provider: {} f:spec: f:completedTimestamp: {} f:gitUrl: {} f:startedTimestamp: {} f:status: {} manager: jx-promote-0.6.45 operation: Update time: "2026-08-12T12:42:12Z" - apiVersion: jenkins.io/v1 fieldsType: FieldsV1 fieldsV1: f:metadata: f:annotations: .: {} f:lighthouse.jenkins-x.io/cloneURI: {} f:lighthouse.jenkins-x.io/job: {} f:pipeline.jenkins-x.io/traceID: {} 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:buildLogsUrl: {} f:context: {} f:message: {} f:steps: {} manager: jx-build-controller operation: Update time: "2026-08-12T12:49:42Z" name: greencapitaltrade-bifrost-main-207 namespace: jx resourceVersion: "263788600" uid: 62e03cc4-23da-4d73-99b9-0080c71b8230 spec: baseSHA: 5665ff0b3f87861f80bdfc536cb1ac1b4daad8bf batchPipelineActivity: {} build: "207" buildLogsUrl: s3://logs-gct-prod-20260425045301534100000007/jenkins-x/logs/greencapitaltrade/bifrost/main/207.log completedTimestamp: "2026-08-12T12:41:47Z" context: release gitBranch: main gitOwner: greencapitaltrade gitRepository: bifrost gitUrl: https://github.com/greencapitaltrade/bifrost.git lastCommitMessage: | perf(asset): stop serializing energy fields; index (asset_id, timestamp) fuel_level/charge_state/charge_current_ma in the asset payloads have had zero consumers since Fury 4.0.1 (asset-level telemetry removed; energy lives in device state[] as battery_soc/fuel_level/current_a etc.), but serializing them triggered _compute_charge_state on every list page and detail read. Its history fallback — needed for devices with energy rows predating the device_state layer — scans the multi-million-row telemetry table, which kept 200-row pages at ~26-30s even after 6.95.1 moved the compute to device_state (measured in prod 2026-08-12). Dropping the keys removes the compute from the API path entirely; it survives for backend form views, now device_state-first. Also adds idx_asset_iot_data_asset_time (asset_id, timestamp DESC) via the existing CONCURRENTLY machinery — per-asset newest-first reads (the compute's fallback, report queries) currently re-sort through the single-column index. Co-Authored-By: Claude Fable 5 lastCommitSHA: 103697466a017e617cb883c24fce9f0bc91a4b5e message: 'Tasks Completed: 1 (Failed: 0, Cancelled 0), Skipped: 0' pipeline: greencapitaltrade/bifrost/main releaseNotesURL: https://github.com/greencapitaltrade/bifrost/releases/tag/v6.95.3 startedTimestamp: "2026-08-12T12:40:47Z" status: Succeeded steps: - kind: Stage stage: completedTimestamp: "2026-08-12T12:41:47Z" name: Release startedTimestamp: "2026-08-12T12:40:47Z" status: Succeeded - kind: Promote promote: environment: staging pullRequest: pullRequestURL: https://github.com/greencapitaltrade/mcu/pull/5393 startedTimestamp: "2026-08-12T12:41:47Z" status: Succeeded startedTimestamp: "2026-08-12T12:41:47Z" status: Succeeded - kind: Stage stage: completedTimestamp: "2026-08-12T12:42:50Z" name: from build pack startedTimestamp: "2026-08-12T12:37:58Z" status: Succeeded steps: - completedTimestamp: "2026-08-12T12:38:15Z" name: Git Clone startedTimestamp: "2026-08-12T12:37:58Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:19Z" name: Next Version startedTimestamp: "2026-08-12T12:38:15Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:22Z" name: Jx Variables startedTimestamp: "2026-08-12T12:38:19Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:25Z" name: Setup Pip Cache startedTimestamp: "2026-08-12T12:38:23Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:27Z" name: Process Config Templates startedTimestamp: "2026-08-12T12:38:26Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:27Z" name: Update Asset Management Version startedTimestamp: "2026-08-12T12:38:27Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:30Z" name: Check Registry startedTimestamp: "2026-08-12T12:38:27Z" status: Succeeded - completedTimestamp: "2026-08-12T12:40:58Z" name: Build Container Build startedTimestamp: "2026-08-12T12:38:30Z" status: Succeeded - completedTimestamp: "2026-08-12T12:41:07Z" name: Promote Changelog startedTimestamp: "2026-08-12T12:40:58Z" status: Succeeded - completedTimestamp: "2026-08-12T12:41:10Z" name: Promote Helm Release startedTimestamp: "2026-08-12T12:41:07Z" status: Succeeded - completedTimestamp: "2026-08-12T12:42:15Z" name: Promote Jx Promote startedTimestamp: "2026-08-12T12:41:11Z" status: Succeeded - completedTimestamp: "2026-08-12T12:42:50Z" name: Publish Org Kb startedTimestamp: "2026-08-12T12:42:15Z" status: Succeeded - kind: Stage stage: completedTimestamp: "2026-08-12T12:42:50Z" name: from build pack startedTimestamp: "2026-08-12T12:37:58Z" status: Succeeded steps: - completedTimestamp: "2026-08-12T12:38:15Z" name: Git Clone startedTimestamp: "2026-08-12T12:37:58Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:19Z" name: Next Version startedTimestamp: "2026-08-12T12:38:15Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:22Z" name: Jx Variables startedTimestamp: "2026-08-12T12:38:19Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:25Z" name: Setup Pip Cache startedTimestamp: "2026-08-12T12:38:23Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:27Z" name: Process Config Templates startedTimestamp: "2026-08-12T12:38:26Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:27Z" name: Update Asset Management Version startedTimestamp: "2026-08-12T12:38:27Z" status: Succeeded - completedTimestamp: "2026-08-12T12:38:30Z" name: Check Registry startedTimestamp: "2026-08-12T12:38:27Z" status: Succeeded - completedTimestamp: "2026-08-12T12:40:58Z" name: Build Container Build startedTimestamp: "2026-08-12T12:38:30Z" status: Succeeded - completedTimestamp: "2026-08-12T12:41:07Z" name: Promote Changelog startedTimestamp: "2026-08-12T12:40:58Z" status: Succeeded - completedTimestamp: "2026-08-12T12:41:10Z" name: Promote Helm Release startedTimestamp: "2026-08-12T12:41:07Z" status: Succeeded - completedTimestamp: "2026-08-12T12:42:15Z" name: Promote Jx Promote startedTimestamp: "2026-08-12T12:41:11Z" status: Succeeded - completedTimestamp: "2026-08-12T12:42:50Z" name: Publish Org Kb startedTimestamp: "2026-08-12T12:42:15Z" status: Succeeded version: 6.95.3 status: {}