Sign in
Postgres Clusters

List Slow Queries

Changed on

List the top 20 queries by cumulative total execution time, excluding the postgres database. Uses the latest available metrics within the lookback range; statistics are cumulative PostgreSQL counters, not deltas over that range. Returns full query text and execution times in seconds.

get/v1/postgres/{postgres_cluster_id}/queries/slow

Request

  • Base URL: https://api.machines.dev
  • URL: https://api.machines.dev/v1/postgres/{postgres_cluster_id}/queries/slow
  • Auth: HTTP bearer

Path parameters

postgres_cluster_idstring required

Managed Postgres Cluster ID

Query parameters

rangeinteger

Metrics lookback in seconds

Response

OK

Changes

  • ab2c6417040dRevision changes
    • ○

      added the optional property to the response with the status

    • ○

      added the optional property to the response with the status

    • ○

      added the optional property to the response with the status

    • ○

      added the optional property to the response with the status

  • 4a82f51548c8Revision changes
    • ○

      the endpoint scheme security FlyBearerAuth was removed from the API