---
title: "List live queries"
method: GET
path: "/postgres/{postgresId}/query/processes"
tags: ["Postgres"]
---

# List live queries

`GET /postgres/{postgresId}/query/processes`

List currently running queries (from `pg_stat_activity`) on a Postgres instance by ID.

## Response `200`

OK

- object
  - `processes` object[], required
    - `pid` integer
    - `databaseName` string
    - `username` string
    - `applicationName` string
    - `clientAddr` string
    - `backendStart` string, date-time
    - `queryStart` string, date-time
    - `state` string
    - `waitEvent` string
    - `waitEventType` string
    - `query` string
    - `duration` number — Duration of the query, in seconds.
    - `isLeader` boolean — Whether this process is running against the primary instance of a highly available database.

## Other responses

- `400` — The request could not be understood by the server.
- `401` — Authorization information is missing or invalid.
- `404` — Unable to find the requested resource.
- `429` — Rate limit has been surpassed.
- `500` — An unexpected server error has occurred.
- `503` — Server currently unavailable.

---

[API](https://skmtc.net/render/apis/render-public-api.md) · [All operations](https://skmtc.net/render/apis/render-public-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/render/render-public-api/versions/80e0ff74d033/schema)