```json { "queries": [ { "query": "SELECT model_name, SUM(calls) AS total_calls, SUM(cost_usd) AS total_cost FROM analysis_run_llm_usage GROUP BY 1 ORDER BY 3 DESC", "description": "Total LLM calls and cost by model, highest-spending models first." }, { "query": "SELECT dataset_id, COUNT(*) AS batch_count, SUM(total_rows) AS total_rows FROM batches WHERE status = 'completed' GROUP BY 1 ORDER BY 2 DESC LIMIT 10", "description": "Top 10 datasets by number of completed batches and total rows processed." }, { "query": "SELECT status, COUNT(*) AS job_count, AVG(elapsed_ms) AS avg_duration_ms FROM jobs GROUP BY 1 ORDER BY 2 DESC", "description": "Job counts and average duration by status." }, { "query": "SELECT purpose, model, COUNT(*) AS call_count, AVG(latency_ms) AS avg_latency FROM llm_calls WHERE status = 'ok' GROUP BY 1, 2 ORDER BY 3 DESC LIMIT 10", "description": "Top 10 LLM call purposes by volume with average latency for successful calls." }, { "query": "SELECT DATE_TRUNC('day', CAST(created_at AS TIMESTAMP)) AS day, COUNT(*) AS message_count FROM nia_messages GROUP BY 1 ORDER BY 1 DESC LIMIT 20", "description": "Daily message volume in NIA conversations over the last 20 days." }, { "query": "SELECT family, tag, COUNT(*) AS tag_count FROM column_tags WHERE source = 'llm' GROUP BY 1, 2 ORDER BY 3 DESC LIMIT 15", "description": "Top 15 LLM-assigned column tags by frequency across all datasets." }, { "query": "SELECT table_type, COUNT(*) AS table_count FROM table_classifications GROUP BY 1 ORDER BY 2 DESC", "description": "Distribution of table types (dimension, event, state, etc.) across all datasets." }, { "query": "SELECT dataset_id, SUM(total_cost_usd) AS total_cost FROM nia_conversations WHERE total_cost_usd IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10", "description": "Top 10 datasets by total NIA conversation cost." }, { "query": "SELECT error_type, COUNT(*) AS error_count FROM llm_calls WHERE status = 'error' GROUP BY 1 ORDER BY 2 DESC", "description": "Most common LLM error types and their frequencies." }, { "query": "SELECT probe_kind, status, COUNT(*) AS run_count FROM neal_probe_runs GROUP BY 1, 2 ORDER BY 3 DESC LIMIT 15", "description": "Neal probe run outcomes by probe type and status." } ] } ```