3 Commits

Author	SHA1	Message	Date
Kacper Sawicki	695de6e0c0	chore(coderd/database): optimize AuditLogs queries (#18600) ... Closes #17689 This PR optimizes the audit logs query performance by extracting the count operation into a separate query and replacing the OR-based workspace_builds with conditional joins. ## Query changes * Extracted count query to separate one * Replaced single `workspace_builds` join with OR conditions with separate conditional joins * Added conditional joins * `wb_build` for workspace_build audit logs (which is a direct lookup) * `wb_workspace` for workspace create audit logs (via workspace) Optimized AuditLogsOffset query: https://explain.dalibo.com/plan/4g1hbedg4a564bg8 New CountAuditLogs query: https://explain.dalibo.com/plan/ga2fbcecb9efbce3	2025-07-01 07:31:14 +02:00
Steven Masley	343f8ec9ab	chore: join owner, template, and org in new workspace view (#15116) ... Joins in fields like `username`, `avatar_url`, `organization_name`, `template_name` to `workspaces` via a **view**. The view must be maintained moving forward, but this prevents needing to add RBAC permissions to fetch related workspace fields.	2024-10-22 09:20:54 -05:00
Steven Masley	ab9298f382	chore: Rewrite rbac rego -> SQL clause (#5138) ... * chore: Rewrite rbac rego -> SQL clause Previous code was challenging to read with edge cases - bug: OrgAdmin could not make new groups - Also refactor some function names	2022-11-28 12:12:34 -06:00