rds.query-insights.get-slow-logSlow query log settings and the statements (and plans) it captured
Request syntax
GET /rds/api/instances/{id}/insights/slow-logPath parameters
idRequiredstring
Constraints: 3-64 chars, /^(?!ewdoc-)[a-z0-9-]+$/
Query parameters
rangeOptionalenum
1h by the minute, 24h by 15 minutes, 7d by 2 hours
One of:
1h,24h,7dDefault:
"24h"
Response
200 with range, settings (null with settingsError when they cannot be read), plansWithValues, topology and entries: the slow statements logged in the range.
A JSON response is wrapped as { "success": true, "data": … }; the CLI prints the whole body with --json.
Fields of data
rangeAlwaysone of 1h, 24h, 7d
The range shownsettingsAlwaysobject, may be null
The settings in force; null when they could not be readsettings.minDurationMsAlwaysnumber
Statements slower than this are logged, ms; -1: offsettings.autoExplainAlwaysboolean
Plans of slow statements are loggedsettings.explainMinMsAlwaysnumber, may be null
Plans are logged above this, ms; null: not setsettingsErrorAlwaysstring, may be null
Why the settings could not be read; null when they wereplansWithValuesAlwaysboolean
Whether statements and plans are kept with their literal valuestopologyAlwaysone of single, cluster
Topology of the databaseentriesAlwaysarray of object
Slow statements logged in the rangeentries[].atAlwaysstring
When it was loggedentries[].nodeAlwaysstring
Node it ran onentries[].durationMsAlwaysnumber
How long it took, msentries[].statementAlwaysstring, may be null
Statement, normalised unless values are keptentries[].fingerprintAlwaysstring, may be null
sqlfp1 fingerprintentries[].planLoggedAlwaysboolean
A plan was logged for this runentries[].planAlwaysstring, may be null
The logged plan; only when values are kept
Checked against the handlers: every route test validates their answers against this schema.
Errors
- 400The request does not pass the schema above. The body is { "error": …, "issues": […] }, one issue per field.
- 401No credentials, or an access key that is unknown, revoked or expired.
- 403The caller's policies do not allow rds:DescribeDBQueryInsights on this resource. The body names the action and the resource, and the refusal is recorded in the audit log.
- 404The resource does not exist in your organization.
Examples
The required parameters only, with example values. Replace id and the other placeholders with your own.
dcloud rds query-insights get-slow-log idcurl -X GET "https://console.platform-development.deutschecloud.app/rds/api/instances/id/insights/slow-log" \
-H "Authorization: EWS-ACCESS-KEY $ACCESS_KEY"Generated from the API description, the same one the API checks requests against and the CLI is built from. MCP tool: dcloud_rds_query-insights_get-slow-log.