Managed Databases

Get slow queries

The slowest recent queries.

PostgreSQL — aggregated statistics from pg_stat_statements: each row is one normalized query with its call count, mean, and total time.
Valkey — individual slow commands from SLOWLOG: calls is 1 per entry and rows is not applicable.

collecting indicates whether statistics collection is active yet.

get/api/v1/databases/{database_id}/slow-queries

Path parameters

database_idstring required

Database ID (UUID) or short id (the database_id field, e.g. a1b2c3d4)

Query parameters

limitinteger

Maximum number of entries to return

Response

Slow query entries

successboolean

collectingboolean

Whether slow-query statistics are being collected

Changes