Platform Tables

SELECT f.name, COUNT(r.id) AS runs
FROM platform_runs r
JOIN platform_flows f ON f.id = r.workflow_id
GROUP BY f.name
ORDER BY runs DESC;

SELECT f.name, r.started_at
FROM platform_runs r
JOIN platform_flows f ON f.id = r.workflow_id
WHERE r.status = 'Failed'
  AND r.created_at >= date_trunc('week', now())
ORDER BY r.started_at DESC;

SELECT a.name, COUNT(c.id) AS conversations
FROM platform_conversations c
JOIN platform_agents a ON a.id = c.assistant_id
GROUP BY a.name
ORDER BY conversations DESC;