Title: Separate connection log methods from app identities · Issue #27412 · coder/coder · GitHub
Open Graph Title: Separate connection log methods from app identities · Issue #27412 · coder/coder
X Title: Separate connection log methods from app identities · Issue #27412 · coder/coder
Description: Completed server-side connection log storage, API, search, and UI work for the Scalable Approach for Adding New IDE Session Types RFC, refined by the Completing Scalable IDE Session Tracking RFC. The original ENUM-to-TEXT proposal evolve...
Open Graph Description: Completed server-side connection log storage, API, search, and UI work for the Scalable Approach for Adding New IDE Session Types RFC, refined by the Completing Scalable IDE Session Tracking RFC. T...
X Description: Completed server-side connection log storage, API, search, and UI work for the Scalable Approach for Adding New IDE Session Types RFC, refined by the Completing Scalable IDE Session Tracking RFC. T...
Opengraph URL: https://github.com/coder/coder/issues/27412
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Separate connection log methods from app identities","articleBody":"Completed server-side connection log storage, API, search, and UI work for the [Scalable Approach for Adding New IDE Session Types RFC](https://app.notion.com/p/coderhq/Scalable-Approach-for-Adding-New-IDE-Session-Types-2d2d579be5928044bfd3cab09f1466b7), refined by the [Completing Scalable IDE Session Tracking RFC](https://app.notion.com/p/3e9d579be5928178b37ce324b8ba0c8b).\n\nThe original ENUM-to-TEXT proposal evolved into separating **how** a connection was made (`connection_method`) from **which app** made it (`app_name`). The server-side implementation landed in [coder/coder#30466](https://github.com/coder/coder/pull/30466), replacing #29674. This issue remains completed/closed.\n\n## Landed scope\n\n- [x] Migration `000617` separates method and app identity in `connection_logs`. Historical `vscode` and `jetbrains` rows become SSH rows with their canonical app names; other rows retain their methods with no app identity.\n- [x] `GET /api/v2/connectionlog` returns `connection_method` and optional `app_name` / `app_display_name`. Deprecated `type` remains a plain string for compatibility.\n- [x] Coderd maps legacy agent reports into the new storage shape.\n- [x] Search supports `method:` and repeatable `app:` filters with consistent list/count results. Deprecated `type:` retains its previous behavior and cannot be mixed with the new filters.\n- [x] The UI uses a Method menu, shows app identity alongside the method, warns on deprecated `type:` filters, and uses `method:ssh` for the Active SSH connections preset.\n- [x] SDK/generated artifacts, migration and filter regression coverage, and API/filter documentation are updated.\n\n## Upgrade and rollback\n\nMigration 617 rewrites `connection_logs` under an `ACCESS EXCLUSIVE` lock. #30466 measured about 5.8s for 1M rows, 49.7s for 10M, and 99.5s for 25M on indexed PostgreSQL 13 (single runs, excluding lock waits; not deployment guarantees). Rollback folds app names back into legacy types and loses per-app detail; apps registered after the migration fall back to SSH.\n\n## Separate follow-ups (not completion requirements)\n\n- [CLIENT-1037](https://linear.app/codercom/issue/CLIENT-1037/report-agent-connection-methods-and-app-identities) / [#30467](https://github.com/coder/coder/pull/30467): explicit agent API v2.13 method/app reports and their ingestion compatibility. The unmerged proto and agent-reporting work formerly listed here has moved to that issue, replacing #29675.\n- [CLIENT-1010](https://linear.app/codercom/issue/CLIENT-1010/expose-per-app-session-duration-from-the-connection-log): duration API/UI and trustworthy disconnect timestamps.\n- Future removal of deprecated `type`, `type:` filters, and `excluded_app_names`; workspace-app and port filters; JetBrains per-product propagation; and a raw port-forward producer are outside the landed scope.\n\nDepends on the completed [CLIENT-644](https://linear.app/codercom/issue/CLIENT-644/normalize-workspace-agent-session-counts-into-a-child-table) work.\n\n---\n\nUpdated by Coder Agents on behalf of @EhabY.","author":{"url":"https://github.com/EhabY","@type":"Person","name":"EhabY"},"datePublished":"2026-07-22T09:22:25Z","url":"https://github.com/coder/coder/issues/27412"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:5ccc234e-b2c6-41da-2715-9aa47d19db6c |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 813E:3A73AA:1779A4E:1DB3350:6B017842 |
| html-safe-nonce | 25aceed7e4756c00c688dcc5096d0a41d5518ec8abce602ebec006518e3f358b |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4MTNFOjNBNzNBQToxNzc5QTRFOjFEQjMzNTA6NkIwMTc4NDIiLCJ2aXNpdG9yX2lkIjoiMzA0MTE0MTM5MDYwOTMxNTkwNiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | df5242532c5506dfd694d4d7bdbeec76927e0cd062f098fabe110a1eee18e074 |
| hovercard-subject-tag | issue:4947455222 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/coder/coder/27412/issue_layout |
| twitter:image | https://opengraph.githubassets.com/f278b5560e07400b4518bc755eacaad4af2d229690e168ab209f709b8627f9cb/coder/coder/issues/27412 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/f278b5560e07400b4518bc755eacaad4af2d229690e168ab209f709b8627f9cb/coder/coder/issues/27412 |
| og:image:alt | Completed server-side connection log storage, API, search, and UI work for the Scalable Approach for Adding New IDE Session Types RFC, refined by the Completing Scalable IDE Session Tracking RFC. T... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | EhabY |
| hostname | github.com |
| expected-hostname | github.com |
| None | cc5dfdd32f62ebd3223cab3af3aa2b268d3605218237326a48a99d1efd89495c |
| turbo-cache-control | no-preview |
| go-import | github.com/coder/coder git https://github.com/coder/coder.git |
| octolytics-dimension-user_id | 95932066 |
| octolytics-dimension-user_login | coder |
| octolytics-dimension-repository_id | 440752086 |
| octolytics-dimension-repository_nwo | coder/coder |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 440752086 |
| octolytics-dimension-repository_network_root_nwo | coder/coder |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 8c77c9e8439031ad54c75a250694842892f693e1 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width