add index on created_at

hugodutka · hugodutka · commit b47a018beda4 · 2024-11-15T17:00:24.000Z
diff --git a/coderd/database/migrations/000276_workspace_modules.up.sql b/coderd/database/migrations/000276_workspace_modules.up.sql
@@ -12,3 +12,5 @@ CREATE TABLE workspace_modules (
     key TEXT NOT NULL,
     created_at timestamp with time zone NOT NULL
 );
+
+CREATE INDEX workspace_modules_created_at_idx ON workspace_modules (created_at);
