- Notifications
You must be signed in to change notification settings - Fork925
Open
Description
Random thought. We haveAdditionalFields
. Could we just add a custom query option toGetAuditLogsOffset
that searches audit logs by their json body payload for the workspace id? Would that be too slow? Should we just add another column and allow aworkspace_id
for audit logs?
Originally posted by@Emyrk in#16507 (review)
Since it's possible to create indexes on jsonb fields, we could ensure good response time for the searches as well. For instance:
CREATE INDEX ON audit_logs((additional_fields->>'workspace_id')::uuid);
Metadata
Metadata
Assignees
Labels
No labels