Debug R2 SQL diagnostics

GET

/v1/logs/debug

GET

/v1/logs/debug

$ curl https://api.runtype.com/v1/logs/debug \
>      -H "Authorization: <apiKey>" \
>      -H "Content-Type: application/json"

1 {
2   "success": true,
3   "data": {
4     "query": "SELECT * FROM logs WHERE level = 'debug' ORDER BY timestamp DESC LIMIT 10;",
5     "executionTimeMs": 12,
6     "rowsReturned": 10,
7     "logs": [
8       {
9         "timestamp": "2024-06-15T10:23:45Z",
10         "level": "debug",
11         "message": "Connection pool initialized",
12         "context": {
13           "connectionId": "conn-1234",
14           "durationMs": 5
15         }
16       },
17       {
18         "timestamp": "2024-06-15T10:23:46Z",
19         "level": "debug",
20         "message": "SQL query executed",
21         "context": {
22           "queryId": "qry-5678",
23           "rowsAffected": 3
24         }
25       }
26     ]
27   }
28 }

R2 SQL diagnostic endpoint for troubleshooting log queries. Non-production only.

Debug R2 SQL diagnostics

Debug R2 SQL diagnostics

Authentication

Response

Errors

Authentication

Response

Errors

$	curl https://api.runtype.com/v1/logs/debug \
>	-H "Authorization: <apiKey>" \
>	-H "Content-Type: application/json"

1	{
2	"success": true,
3	"data": {
4	"query": "SELECT * FROM logs WHERE level = 'debug' ORDER BY timestamp DESC LIMIT 10;",
5	"executionTimeMs": 12,
6	"rowsReturned": 10,
7	"logs": [
8	{
9	"timestamp": "2024-06-15T10:23:45Z",
10	"level": "debug",
11	"message": "Connection pool initialized",
12	"context": {
13	"connectionId": "conn-1234",
14	"durationMs": 5
15	}
16	},
17	{
18	"timestamp": "2024-06-15T10:23:46Z",
19	"level": "debug",
20	"message": "SQL query executed",
21	"context": {
22	"queryId": "qry-5678",
23	"rowsAffected": 3
24	}
25	}
26	]
27	}
28	}