Oct 7, 2025 · Oct 7, 2025
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/provisionerdaemons.sql b/coderd/database/queries/provisionerdaemons.sql
 -- Filter by max age if provided
 AND (
 sqlc.narg('max_age_ms')::bigint IS NULL
 OR pd.last_seen_at IS NULL
 OR pd.last_seen_at IS NULL
 OR pd.last_seen_at >= (NOW() - (sqlc.narg('max_age_ms')::bigint || ' ms')::interval)
 )
 AND (
diff --git a/coderd/database/queries/provisionerjoblogs.sql b/coderd/database/queries/provisionerjoblogs.sql
 unnest(@level :: log_level [ ]) AS LEVEL,
 unnest(@stage :: VARCHAR(128) [ ]) AS stage,
 unnest(@output :: VARCHAR(1024) [ ]) AS output RETURNING *;


 -- name: UpdateProvisionerJobLogsOverflowed :exec
 UPDATE
 UPDATE
 provisioner_jobs
 SET
 SET
 logs_overflowed = $2
 WHERE
 WHERE
 id = $1;


 -- name: UpdateProvisionerJobLogsLength :exec
 UPDATE
 UPDATE
 provisioner_jobs
 SET
 SET
 logs_length = logs_length + $2
 WHERE
 WHERE
 id = $1;
diff --git a/coderd/database/queries/provisionerkeys.sql b/coderd/database/queries/provisionerkeys.sql
    provisioner_keys
 WHERE
    organization_id = $1
 AND
 AND
    lower(name) = lower(@name);

 -- name: ListProvisionerKeysByOrganizationExcludeReserved :many
 AND
    -- exclude reserved built-in key
    id != '00000000-0000-0000-0000-000000000001'::uuid
 AND
 AND
    -- exclude reserved user-auth key
    id != '00000000-0000-0000-0000-000000000002'::uuid
 AND
 AND
    -- exclude reserved psk key
    id != '00000000-0000-0000-0000-000000000003'::uuid;

diff --git a/coderd/database/queries/testadmin.sql b/coderd/database/queries/testadmin.sql
 DECLARE
    table_record record;
 BEGIN
    FOR table_record IN
        SELECT table_schema, table_name
        FROM information_schema.tables
    FOR table_record IN
        SELECT table_schema, table_name
        FROM information_schema.tables
        WHERE table_schema NOT IN ('pg_catalog', 'information_schema')
        AND table_type = 'BASE TABLE'
    LOOP
        EXECUTE format('ALTER TABLE %I.%I DISABLE TRIGGER ALL',
                    table_record.table_schema,
        EXECUTE format('ALTER TABLE %I.%I DISABLE TRIGGER ALL',
                    table_record.table_schema,
                    table_record.table_name);
    END LOOP;
 END;
diff --git a/coderd/database/queries/workspaceagentstats.sql b/coderd/database/queries/workspaceagentstats.sql
 coalesce((PERCENTILE_CONT(0.95) WITHIN GROUP (ORDER BY connection_median_latency_ms)), -1)::FLOAT AS workspace_connection_latency_95
 FROM workspace_agent_stats
 -- The greater than 0 is to support legacy agents that don't report connection_median_latency_ms.
 WHERE workspace_agent_stats.created_at > $1 AND connection_median_latency_ms > 0
 WHERE workspace_agent_stats.created_at > $1 AND connection_median_latency_ms > 0
 GROUP BY user_id, agent_id, workspace_id, template_id
 ), latest_agent_stats AS (
 SELECT
Original file line number	Diff line number	Diff line change
Expand Up		@@ -113,7 +113,7 @@ WHERE
		-- Filter by max age if provided
		AND (
		sqlc.narg('max_age_ms')::bigint IS NULL
		OR pd.last_seen_at IS NULL
		OR pd.last_seen_at IS NULL
		OR pd.last_seen_at >= (NOW() - (sqlc.narg('max_age_ms')::bigint \|\| ' ms')::interval)
		)
		AND (
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -19,19 +19,19 @@ SELECT
		unnest(@level :: log_level [ ]) AS LEVEL,
		unnest(@stage :: VARCHAR(128) [ ]) AS stage,
		unnest(@output :: VARCHAR(1024) [ ]) AS output RETURNING *;


		-- name: UpdateProvisionerJobLogsOverflowed :exec
		UPDATE
		UPDATE
		provisioner_jobs
		SET
		SET
		logs_overflowed = $2
		WHERE
		WHERE
		id = $1;


		-- name: UpdateProvisionerJobLogsLength :exec
		UPDATE
		UPDATE
		provisioner_jobs
		SET
		SET
		logs_length = logs_length + $2
		WHERE
		WHERE
		id = $1;
Original file line number	Diff line number	Diff line change
Expand Up		@@ -34,7 +34,7 @@ FROM
		provisioner_keys
		WHERE
		organization_id = $1
		AND
		AND
		lower(name) = lower(@name);

		-- name: ListProvisionerKeysByOrganizationExcludeReserved :many
Expand All		@@ -47,10 +47,10 @@ WHERE
		AND
		-- exclude reserved built-in key
		id != '00000000-0000-0000-0000-000000000001'::uuid
		AND
		AND
		-- exclude reserved user-auth key
		id != '00000000-0000-0000-0000-000000000002'::uuid
		AND
		AND
		-- exclude reserved psk key
		id != '00000000-0000-0000-0000-000000000003'::uuid;

Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -6,14 +6,14 @@ DO $$
		DECLARE
		table_record record;
		BEGIN
		FOR table_record IN
		SELECT table_schema, table_name
		FROM information_schema.tables
		FOR table_record IN
		SELECT table_schema, table_name
		FROM information_schema.tables
		WHERE table_schema NOT IN ('pg_catalog', 'information_schema')
		AND table_type = 'BASE TABLE'
		LOOP
		EXECUTE format('ALTER TABLE %I.%I DISABLE TRIGGER ALL',
		table_record.table_schema,
		EXECUTE format('ALTER TABLE %I.%I DISABLE TRIGGER ALL',
		table_record.table_schema,
		table_record.table_name);
		END LOOP;
		END;
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -189,7 +189,7 @@ WITH agent_stats AS (
		coalesce((PERCENTILE_CONT(0.95) WITHIN GROUP (ORDER BY connection_median_latency_ms)), -1)::FLOAT AS workspace_connection_latency_95
		FROM workspace_agent_stats
		-- The greater than 0 is to support legacy agents that don't report connection_median_latency_ms.
		WHERE workspace_agent_stats.created_at > $1 AND connection_median_latency_ms > 0
		WHERE workspace_agent_stats.created_at > $1 AND connection_median_latency_ms > 0
		GROUP BY user_id, agent_id, workspace_id, template_id
		), latest_agent_stats AS (
		SELECT
Expand Down