TO see how many actions your DBOS executes in a day, run the SQL statement below against your DBOS database.
WITH daily_workflows AS (
SELECT
DATE_TRUNC('day', TO_TIMESTAMP(created_at / 1000)) AS day,
workflow_uuid
FROM dbos.workflow_status
)
SELECT
dw.day,
COUNT(DISTINCT dw.workflow_uuid) AS workflow_count,
COUNT(oo.workflow_uuid) AS step_count,
COUNT(DISTINCT dw.workflow_uuid) + COUNT(oo.workflow_uuid) AS total_actions
FROM daily_workflows dw
LEFT JOIN dbos.operation_outputs oo ON dw.workflow_uuid = oo.workflow_uuid
GROUP BY dw.day
ORDER BY dw.day DESC;