...
| No Format |
|---|
USE pfx_dw;
SELECT
prod_show.name
, SEC_TO_TIME(SUM(cpu_seconds)) AS cpu_minutes
FROM
job_fact AS fact
INNER JOIN
prod_show_dim AS prod_show
ON
fact.prod_show_sk=prod_show.prod_show_sk
WHERE
job_id > 41000
GROUP BY
prod_show.prod_show_sk;
+------------+-------------+
| name | cpu_minutes |
+------------+-------------+
| | 00:00:05 |
| new Show 2 | 00:11:25 |
| newShow | 00:05:00 |
+------------+-------------+ |
Tags and the WranglerView Performance Charts
The various job tag fields can also be used in the WV performance charts to compare running frames or amount of pending work in the queue between shows, shots, etc.