rds.query-insights.getStatements of the range with load, trends and findings
Statement text is normalised (no literal values). Each statement carries its sqlfp1 fingerprint, the key Error Tracking links by.
Request syntax
GET /rds/api/instances/{id}/insightsPath 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, from, to, bucketSeconds, sampling, plansWithValues, errorTrackingUrl, the load series (at, totalMs, calls) and up to 200 statements: id, fingerprint, query, database, role, calls, totalMs, meanMs, maxMs, rows, cacheHitRatio, walBytes, series, findings, … .
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 shownfromAlwaysstring
Start of the rangetoAlwaysstring
End of the rangebucketSecondsAlwaysnumber
Width of one point of the series, secondssamplingAlwaysobject
How the history is being sampledsampling.lastMinuteAlwaysstring, may be null
Newest minute sampled; null: nothing sampled in the rangesampling.avgSampleMsAlwaysnumber, may be null
Average time one sample took on the database, mssampling.p95SampleMsAlwaysnumber, may be null
95th percentile of that time, msplansWithValuesAlwaysboolean
Whether statements and plans are kept with their literal valueserrorTrackingUrlAlwaysstring, may be null
Console page linking statements to errors; null without an Error Tracking projectloadAlwaysarray of object
Load of the whole database over the rangeload[].atAlwaysstring
Start of the pointload[].totalMsAlwaysnumber
Time all statements spent, msload[].callsAlwaysnumber
Calls of all statementsstatementsAlwaysarray of object
Up to 200 statements, by total timestatements[].idAlwaysstring
Statement id, for get-statementstatements[].fingerprintAlwaysstring
sqlfp1 fingerprint, the key Error Tracking links bystatements[].queryAlwaysstring
Normalised statement text (no literal values)statements[].databaseAlwaysstring
Database it ran instatements[].roleAlwaysstring
Role it ran asstatements[].firstSeenAtAlwaysstring
First time it was sampledstatements[].lastSeenAtAlwaysstring
Last time it was sampledstatements[].callsAlwaysnumber
Calls in the rangestatements[].totalMsAlwaysnumber
Time spent in the range, msstatements[].meanMsAlwaysnumber
Time per call, msstatements[].maxMsAlwaysnumber, may be null
Slowest call, ms; null: unknownstatements[].stddevMsAlwaysnumber, may be null
Standard deviation of a call, ms; null: unknownstatements[].rowsAlwaysnumber
Rows returned or affectedstatements[].rowsPerCallAlwaysnumber
Rows per callstatements[].cacheHitRatioAlwaysnumber, may be null
Share of blocks served from memory, 0 to 1; null: nothing readstatements[].sharedBlocksReadAlwaysnumber
Blocks read from diskstatements[].sharedBlocksHitAlwaysnumber
Blocks served from memorystatements[].tempBlocksWrittenAlwaysnumber
Temporary blocks written: sorts and hashes that spilled to diskstatements[].walBytesAlwaysnumber
WAL written, bytesstatements[].seriesAlwaysarray of object
Its own load over the rangestatements[].series[].atAlwaysstring
Start of the pointstatements[].series[].totalMsAlwaysnumber
Time spent, msstatements[].series[].callsAlwaysnumber
Callsstatements[].findingsAlwaysarray of object
Findings with suggested actionsstatements[].findings[].kindAlwaysone of slow-average, slow-sometimes, missing-index, spills-to-disk, n-plus-one, seq-scan-large-table, unused-index, duplicate-index, vacuum-overdue, long-running, idle-in-transaction, lock-wait
What was foundstatements[].findings[].severityAlwaysone of high, medium, info
How much it mattersstatements[].findings[].titleAlwaysstring
One line: what was seenstatements[].findings[].evidenceAlwaysstring
The numbers behind itstatements[].findings[].actionAlwaysstring
What to do about itstatements[].findings[].sqlWhen presentstring
A statement to copy and run yourself (CREATE INDEX CONCURRENTLY, …); absent when none
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 idcurl -X GET "https://console.platform-development.deutschecloud.app/rds/api/instances/id/insights" \
-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.