A query for calculating the average running time of a job in a GitLab pipeline.

query.txt

db.pipelines.aggregate([
  {
    $unwind: "$jobs"
  },
  {
    $group: {
      _id: {
        "project": "$project_id",
        "jobName": "$jobs.name"
      },
      averageRun: {
        $avt: {
          $dateDiff: {
            startDate: {
              "$dateFromString": {
                "dateString": "$jobs.started_at",
                "format": "%Y-%m-%dT%H:%M:%S.%LZ"
              }
            },
            endDate: {
              "$dateFromString": {
                "dateString": "$jobs.finished_at",
                "format": "%Y-%m-%dT%H:%M:%S.%LZ"
              }
            },
            unit: "second"
          }
        }
      }
    }
  }
])