Execution Performance Dashboard

Overview

The Execution Performance Dashboard provides comprehensive visualization capabilities for monitoring duration and outcome statistics across various execution types in the continuous delivery pipeline. This dashboard enables stakeholders to analyze performance metrics for:

• Pipeline executions
• Task executions
• Build processes
• Test and test suite runs

Implementation Details

The dashboard implements visualization through parameterized SQL queries that extract execution metrics from the CDViz database. The example below demonstrates the query structure for pipeline execution analysis:

SELECT
  LEAST(queued_at, started_at, finished_at) AS at,
  subject_id AS subject_id,
  extract('epoch' from (started_at - queued_at)) AS queued_duration,
  extract('epoch' from (finished_at - started_at)) AS run_duration,
  --
  last_payload -> 'subject' -> 'content' ->> 'url' AS url,
  outcome AS outcome
FROM cdviz.pipelinerun
WHERE
  ($__timeFilter(queued_at) OR $__timeFilter(finished_at))
  AND last_payload -> 'subject' -> 'content' ->> 'pipelineName' = ANY(ARRAY[${selected_value:sqlstring}]::text[])
ORDER BY at DESC
LIMIT $limit

Technical Considerations

• Some execution types may not include queued duration metrics (e.g., tasks)
• The SQL queries utilize views defined on the cdevents_lake table
• For missing views, consider:
  • Submitting a pull request to add the view to the database schema
  • Creating custom views in your environment
  • Using SQL WITH statements in your queries as a workaround
• The dashboard includes a hidden limit variable that controls the number of displayed results (default: 20)

Source Code References

• Database schema: schema.sql
• Dashboard generator: execution_dashboards.ts