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: 921ca6529fa3b3d65d7660608466801a creationTimestamp: "2026-08-12T14:03:23Z" generation: 7 labels: branch: main build: "208" buildID: "1786543362210" created-by-lighthouse: "true" event-GUID: 77c1dcaa-9656-11f1-808d-80e80af15781 lighthouse.jenkins-x.io/baseSHA: 730b8748ef495865814b1094a02d544f7e8cf054 lighthouse.jenkins-x.io/branch: main lighthouse.jenkins-x.io/buildNum: "1786543362210" lighthouse.jenkins-x.io/context: release lighthouse.jenkins-x.io/id: apitaltrade-bifrost-main-release-hkrsb lighthouse.jenkins-x.io/job: release lighthouse.jenkins-x.io/lastCommitSHA: 730b8748ef495865814b1094a02d544f7e8cf054 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-vn42z-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-12T14:03:23Z" - 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-12T14:07:30Z" - 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-12T14:09:07Z" - 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-12T14:20:44Z" name: greencapitaltrade-bifrost-main-208 namespace: jx resourceVersion: "263959520" uid: 22a7ffe3-91a0-42d3-90b2-53b4cc714ea5 spec: baseSHA: 730b8748ef495865814b1094a02d544f7e8cf054 batchPipelineActivity: {} build: "208" buildLogsUrl: s3://logs-gct-prod-20260425045301534100000007/jenkins-x/logs/greencapitaltrade/bifrost/main/208.log completedTimestamp: "2026-08-12T14:08:33Z" context: release gitBranch: main gitOwner: greencapitaltrade gitRepository: bifrost gitUrl: https://github.com/greencapitaltrade/bifrost.git lastCommitMessage: | perf(asset): probe per asset in trip catch-up discovery, not window scans The catch-up work-list discovery ran a GROUP BY over report_gps_v for the whole multi-day catch-up window on every cron beat (every minute) — a full scan+aggregate of the multi-million-row telemetry view to select the next 25 assets past the cursor. RDS Performance Insights measured it at ~80% of total database load in production (2026-08-12), starving every API request; asset list pages read 7-28s depending on cron timing. Iterate assets past the cursor instead and EXISTS-probe each one's window slice via idx_asset_iot_data_asset_time (newest-first, stops at the first valid fix). Same work set, ordered and limited identically; company now comes from the asset rather than the sample, which is the company detect_trips_batch runs under anyway. Per-beat discovery cost drops from a full-view scan to index probes. Co-Authored-By: Claude Fable 5 lastCommitSHA: 5a8bbc96835b695b8b785f9454f4d5ace351ee71 message: 'Tasks Completed: 1 (Failed: 0, Cancelled 0), Skipped: 0' pipeline: greencapitaltrade/bifrost/main releaseNotesURL: https://github.com/greencapitaltrade/bifrost/releases/tag/v6.95.4 startedTimestamp: "2026-08-12T14:07:33Z" status: Succeeded steps: - kind: Stage stage: completedTimestamp: "2026-08-12T14:08:33Z" name: Release startedTimestamp: "2026-08-12T14:07:33Z" status: Succeeded - kind: Promote promote: environment: staging pullRequest: pullRequestURL: https://github.com/greencapitaltrade/mcu/pull/5395 startedTimestamp: "2026-08-12T14:08:33Z" status: Succeeded startedTimestamp: "2026-08-12T14:08:33Z" status: Succeeded - kind: Stage stage: completedTimestamp: "2026-08-12T14:10:02Z" name: from build pack startedTimestamp: "2026-08-12T14:02:52Z" status: Succeeded steps: - completedTimestamp: "2026-08-12T14:03:13Z" name: Git Clone startedTimestamp: "2026-08-12T14:02:52Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:20Z" name: Next Version startedTimestamp: "2026-08-12T14:03:14Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:25Z" name: Jx Variables startedTimestamp: "2026-08-12T14:03:20Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:29Z" name: Setup Pip Cache startedTimestamp: "2026-08-12T14:03:25Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:30Z" name: Process Config Templates startedTimestamp: "2026-08-12T14:03:30Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:31Z" name: Update Asset Management Version startedTimestamp: "2026-08-12T14:03:31Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:34Z" name: Check Registry startedTimestamp: "2026-08-12T14:03:31Z" status: Succeeded - completedTimestamp: "2026-08-12T14:07:19Z" name: Build Container Build startedTimestamp: "2026-08-12T14:03:35Z" status: Succeeded - completedTimestamp: "2026-08-12T14:07:30Z" name: Promote Changelog startedTimestamp: "2026-08-12T14:07:20Z" status: Succeeded - completedTimestamp: "2026-08-12T14:07:35Z" name: Promote Helm Release startedTimestamp: "2026-08-12T14:07:31Z" status: Succeeded - completedTimestamp: "2026-08-12T14:09:10Z" name: Promote Jx Promote startedTimestamp: "2026-08-12T14:07:35Z" status: Succeeded - completedTimestamp: "2026-08-12T14:10:02Z" name: Publish Org Kb startedTimestamp: "2026-08-12T14:09:10Z" status: Succeeded - kind: Stage stage: completedTimestamp: "2026-08-12T14:10:02Z" name: from build pack startedTimestamp: "2026-08-12T14:02:52Z" status: Succeeded steps: - completedTimestamp: "2026-08-12T14:03:13Z" name: Git Clone startedTimestamp: "2026-08-12T14:02:52Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:20Z" name: Next Version startedTimestamp: "2026-08-12T14:03:14Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:25Z" name: Jx Variables startedTimestamp: "2026-08-12T14:03:20Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:29Z" name: Setup Pip Cache startedTimestamp: "2026-08-12T14:03:25Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:30Z" name: Process Config Templates startedTimestamp: "2026-08-12T14:03:30Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:31Z" name: Update Asset Management Version startedTimestamp: "2026-08-12T14:03:31Z" status: Succeeded - completedTimestamp: "2026-08-12T14:03:34Z" name: Check Registry startedTimestamp: "2026-08-12T14:03:31Z" status: Succeeded - completedTimestamp: "2026-08-12T14:07:19Z" name: Build Container Build startedTimestamp: "2026-08-12T14:03:35Z" status: Succeeded - completedTimestamp: "2026-08-12T14:07:30Z" name: Promote Changelog startedTimestamp: "2026-08-12T14:07:20Z" status: Succeeded - completedTimestamp: "2026-08-12T14:07:35Z" name: Promote Helm Release startedTimestamp: "2026-08-12T14:07:31Z" status: Succeeded - completedTimestamp: "2026-08-12T14:09:10Z" name: Promote Jx Promote startedTimestamp: "2026-08-12T14:07:35Z" status: Succeeded - completedTimestamp: "2026-08-12T14:10:02Z" name: Publish Org Kb startedTimestamp: "2026-08-12T14:09:10Z" status: Succeeded version: 6.95.4 status: {}