sql queries

hugodutka · hugodutka · commit 51b5b96ab92f · 2025-03-03T15:23:10.000Z
diff --git a/coderd/database/queries/workspaceagentresourcemonitors.sql b/coderd/database/queries/workspaceagentresourcemonitors.sql
@@ -1,3 +1,19 @@
+-- name: FetchVolumesResourceMonitorsCreatedAfter :many
+SELECT
+	*
+FROM
+	workspace_agent_volume_resource_monitors
+WHERE
+	created_at > $1;
+
+-- name: FetchMemoryResourceMonitorsCreatedAfter :many
+SELECT
+	*
+FROM
+	workspace_agent_memory_resource_monitors
+WHERE
+	created_at > $1;
+
 -- name: FetchMemoryResourceMonitorsByAgentID :one
 SELECT
 	*
