Hello! This is my first attempt to write a query based on what I understood from the requirements and the information I could gather. https://sql.telemetry.mozilla.org/queries/63517 This query sums the durations of the jobs related to a certain push, grouping them by user and framework. I know that some aspects where not taken into consideration but I couldn't figure out the following: - how can I know which job is a retrigger, a backfill or a "default" - for backfills, how can I get the jobs that they depend on
Bug 1562162 Comment 2 Edit History
Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.
Hello! This is my first attempt to write a query based on what I understood from the requirements and the information I could gather. https://sql.telemetry.mozilla.org/queries/63517 This query sums the durations of the jobs related to a certain push, grouping them by user and framework. I know that some aspects were not taken into consideration but I couldn't figure out the following: - how can I know which job is a retrigger, a backfill or a "default" - for backfills, how can I get the jobs that they depend on