Path Parameters
The project id.
The rollout id.
The stage id.
The task id.
The taskRun id.
{
  "name": "<string>",
  "postgres": {
    "session": {
      "pid": "<string>",
      "blockedByPids": [
        "<string>"
      ],
      "query": "<string>",
      "state": "<string>",
      "waitEventType": "<string>",
      "waitEvent": "<string>",
      "datname": "<string>",
      "usename": "<string>",
      "applicationName": "<string>",
      "clientAddr": "<string>",
      "clientPort": "<string>",
      "backendStart": "2023-11-07T05:31:56Z",
      "xactStart": "2023-11-07T05:31:56Z",
      "queryStart": "2023-11-07T05:31:56Z"
    },
    "blockingSessions": [
      {
        "pid": "<string>",
        "blockedByPids": [
          "<string>"
        ],
        "query": "<string>",
        "state": "<string>",
        "waitEventType": "<string>",
        "waitEvent": "<string>",
        "datname": "<string>",
        "usename": "<string>",
        "applicationName": "<string>",
        "clientAddr": "<string>",
        "clientPort": "<string>",
        "backendStart": "2023-11-07T05:31:56Z",
        "xactStart": "2023-11-07T05:31:56Z",
        "queryStart": "2023-11-07T05:31:56Z"
      }
    ],
    "blockedSessions": [
      {
        "pid": "<string>",
        "blockedByPids": [
          "<string>"
        ],
        "query": "<string>",
        "state": "<string>",
        "waitEventType": "<string>",
        "waitEvent": "<string>",
        "datname": "<string>",
        "usename": "<string>",
        "applicationName": "<string>",
        "clientAddr": "<string>",
        "clientPort": "<string>",
        "backendStart": "2023-11-07T05:31:56Z",
        "xactStart": "2023-11-07T05:31:56Z",
        "queryStart": "2023-11-07T05:31:56Z"
      }
    ]
  }
}Retrieves database session information for a running task. Permissions required: bb.taskRuns.list
{
  "name": "<string>",
  "postgres": {
    "session": {
      "pid": "<string>",
      "blockedByPids": [
        "<string>"
      ],
      "query": "<string>",
      "state": "<string>",
      "waitEventType": "<string>",
      "waitEvent": "<string>",
      "datname": "<string>",
      "usename": "<string>",
      "applicationName": "<string>",
      "clientAddr": "<string>",
      "clientPort": "<string>",
      "backendStart": "2023-11-07T05:31:56Z",
      "xactStart": "2023-11-07T05:31:56Z",
      "queryStart": "2023-11-07T05:31:56Z"
    },
    "blockingSessions": [
      {
        "pid": "<string>",
        "blockedByPids": [
          "<string>"
        ],
        "query": "<string>",
        "state": "<string>",
        "waitEventType": "<string>",
        "waitEvent": "<string>",
        "datname": "<string>",
        "usename": "<string>",
        "applicationName": "<string>",
        "clientAddr": "<string>",
        "clientPort": "<string>",
        "backendStart": "2023-11-07T05:31:56Z",
        "xactStart": "2023-11-07T05:31:56Z",
        "queryStart": "2023-11-07T05:31:56Z"
      }
    ],
    "blockedSessions": [
      {
        "pid": "<string>",
        "blockedByPids": [
          "<string>"
        ],
        "query": "<string>",
        "state": "<string>",
        "waitEventType": "<string>",
        "waitEvent": "<string>",
        "datname": "<string>",
        "usename": "<string>",
        "applicationName": "<string>",
        "clientAddr": "<string>",
        "clientPort": "<string>",
        "backendStart": "2023-11-07T05:31:56Z",
        "xactStart": "2023-11-07T05:31:56Z",
        "queryStart": "2023-11-07T05:31:56Z"
      }
    ]
  }
}The project id.
The rollout id.
The stage id.
The task id.
The taskRun id.
Was this page helpful?