Sign in
External Services

get/external-services/{service_id}/pg-stat-statements/slow-queries

Request

  • Base URL: /api (relative, and the document was published on a file host, not at the API’s origin)
  • URL: /api/external-services/{service_id}/pg-stat-statements/slow-queries
  • Auth: HTTP bearer

Path parameters

service_idinteger required

ID of the provisioned Postgres service

Query parameters

pageinteger nullable

Page number (1-based). Defaults to 1.

page_sizeinteger nullable

Number of rows per page (1–100). Defaults to 20.

sort_bystring nullable

Column to sort by: one of calls, total_exec_time_ms, mean_exec_time_ms, rows, cache_hit_ratio. Defaults to mean_exec_time_ms. Applied server-side so ordering stays consistent across pages.

sort_orderstring nullable

Sort direction: asc or desc. Defaults to desc.

Response

Paginated slow queries from pg_stat_statements

pageinteger required

Current page number (1-based).

page_sizeinteger required

Number of rows per page used for this request.

total_countinteger required

Total number of qualifying rows across all pages.

Changes

No recorded changes to this operation across all 50 revisions of this API.