Hi Team,
I want to show comparison graph of jenkins pipeline steps between two jenkins build. How can i get it?
i am able to get the table with all duration, stage name with following queries.
index="jenkins_statistics" (host=jenkins.com/test) event_tag=job_event type=completed "stages{}.name"="" "stages{}.children{}.exec_node"="" |rename stages{}.duration as stageduration | rename stages{}.name as stageName | rename "stages{}.children{}.exec_node" as pipeline_nodes| eval exec_nodes=mvdedup(pipeline_nodes)
| eval build_on_node=coalesce(exec_nodes, node) | table build_on_node, job_name, stageName, stageduration
index="jenkins_statistics" (host=jenkins.com/test) event_tag=job_event type=completed "stages{}.name"="" "stages{}.children{}.exec_node"=""
| rename stages{}.duration as stageduration
| rename stages{}.name as stageName
| rename "stages{}.children{}.exec_node" as pipeline_nodes
| eval exec_nodes=mvdedup(pipeline_nodes)
| eval build_on_node=coalesce(exec_nodes, node)
| table build_on_node, job_name, stageName, stageduration
| eval stage=build_on_node."_".job_name."_".stageName
| chart sum(stageduration) as stageduration by stage
| table build_on_node, job_name, stageName, stageduration
If you provide the results, we could create query.