Properties
| Name | Type | Description |
|---|---|---|
| id | string | Unique identifier for the session |
| name | string | Display name of the session |
| status | string | Current status of the session |
| databaseProvider | string | Database provider used during the session |
| queryCount | integer | Total number of queries captured |
| totalDuration | number | Total query execution time in milliseconds |
| startedAt | string | When the recording session started |
| endedAt | string | When the recording session ended (null if active) |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "#/components/schemas/Session",
"title": "Session",
"type": "object",
"description": "A query recording session for performance analysis",
"properties": {
"id": {
"type": "string",
"description": "Unique identifier for the session"
},
"name": {
"type": "string",
"description": "Display name of the session"
},
"status": {
"type": "string",
"description": "Current status of the session",
"enum": [
"active",
"completed",
"expired"
]
},
"databaseProvider": {
"type": "string",
"description": "Database provider used during the session",
"enum": [
"postgresql",
"mysql",
"cockroachdb",
"sqlserver"
]
},
"queryCount": {
"type": "integer",
"description": "Total number of queries captured",
"minimum": 0
},
"totalDuration": {
"type": "number",
"format": "float",
"description": "Total query execution time in milliseconds"
},
"startedAt": {
"type": "string",
"format": "date-time",
"description": "When the recording session started"
},
"endedAt": {
"type": "string",
"format": "date-time",
"description": "When the recording session ended (null if active)"
}
},
"required": [
"id",
"status",
"databaseProvider",
"queryCount",
"startedAt"
]
}