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

# List top queries

`GET /postgres/{postgresId}/query/top-queries`

List the top 50 queries by total execution time (from `pg_stat_statements`) on a Postgres instance by ID.

## Response `200`

OK

- object
  - `topQueries` object[], required
    - `queryId` string
    - `query` string
    - `calls` integer
    - `totalTimeMs` number
    - `minTimeMs` number
    - `maxTimeMs` number
    - `meanTimeMs` number
    - `stddevTimeMs` number
    - `rows` integer
    - `sharedBlocksHit` integer
    - `sharedBlocksRead` integer
    - `sharedBlocksDirtied` integer
    - `sharedBlocksWritten` integer
    - `localBlocksHit` integer
    - `localBlocksRead` integer
    - `localBlocksDirtied` integer
    - `localBlocksWritten` integer
    - `tempBlocksRead` integer
    - `tempBlocksWritten` integer

## 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)