UpCloud

Database Monitoring

Monitor your Managed Databases with real-time logs, active session information, query performance statistics, and system metrics.

GET/1.3/database/{uuid}/logs

List logs

Returns recent log entries for a Managed Database service.

Query parameters

  • Name
    limit
    Type
    integer
    Description

    Maximum number of log entries to return. Default: 100.

  • Name
    offset
    Type
    string
    Description

    Offset for pagination (returned from previous request).

  • Name
    order
    Type
    string
    Description

    Sort order: "asc" or "desc". Default: "desc".

Request

GET
/1.3/database/{uuid}/logs
curl -X GET "https://api.upcloud.com/1.3/database/09a4b9d5-c1f8-4c9f-9e7a-1234567890ab/logs?limit=10" \
  -u your_username:your_password
GET/1.3/database/{uuid}/sessions

List sessions

Returns a list of active sessions (connections) for a Managed Database service. Available for MySQL, PostgreSQL, and Valkey.

Request

GET
/1.3/database/{uuid}/sessions
curl -X GET https://api.upcloud.com/1.3/database/09a4b9d5-c1f8-4c9f-9e7a-1234567890ab/sessions \
  -u your_username:your_password
DELETE/1.3/database/{uuid}/sessions/{id}

Terminate session

Terminates an active database session. Available for MySQL and PostgreSQL.

Query parameters

  • Name
    terminate
    Type
    boolean
    Description

    Force termination (pg_terminate_backend). Default: false (pg_cancel_backend).

Request

DELETE
/1.3/database/{uuid}/sessions/{id}
curl -X DELETE "https://api.upcloud.com/1.3/database/09a4b9d5-c1f8-4c9f-9e7a-1234567890ab/sessions/12345?terminate=true" \
  -u your_username:your_password
GET/1.3/database/{uuid}/query-statistics

List query statistics

Returns query performance statistics for a Managed Database service. Available for MySQL and PostgreSQL.

Query parameters

  • Name
    limit
    Type
    integer
    Description

    Maximum number of queries to return. Default: 100.

  • Name
    offset
    Type
    integer
    Description

    Offset for pagination.

  • Name
    order_by
    Type
    string
    Description

    Sort field: "calls", "total_time", "rows", etc.

Request

GET
/1.3/database/{uuid}/query-statistics
curl -X GET "https://api.upcloud.com/1.3/database/09a4b9d5-c1f8-4c9f-9e7a-1234567890ab/query-statistics?limit=5&order_by=total_time" \
  -u your_username:your_password
GET/1.3/database/{uuid}/metrics

List metrics

Returns system metrics for a Managed Database service.

Query parameters

  • Name
    period
    Type
    string
    Description

    Time period: "hour", "day", "week", "month", "year". Default: "hour".

Request

GET
/1.3/database/{uuid}/metrics
curl -X GET "https://api.upcloud.com/1.3/database/09a4b9d5-c1f8-4c9f-9e7a-1234567890ab/metrics?period=hour" \
  -u your_username:your_password