Retrieve Database Stats

Fetch the top queries of a database, including the count of rows read and written.

GET /v1/organizations/{organizationSlug}/databases/{databaseName}/stats

cURL

curl -L -X GET 'https://api.turso.tech/v1/organizations/{organizationSlug}/databases/{databaseName}/stats' \
-H 'Authorization: Bearer TOKEN'

200

{
  "top_queries": [
    {
      "query": "SELECT COUNT(*), CustomerID FROM Orders GROUP BY CustomerID HAVING COUNT(*) > 5;",
      "rows_read": 123,
      "rows_written": 4567
    }
  ]
}

cURL

curl -L -X GET 'https://api.turso.tech/v1/organizations/{organizationSlug}/databases/{databaseName}/stats' \
-H 'Authorization: Bearer TOKEN'

Authorizations

Authorization · string · header · required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

organizationSlug · string · required

The slug of the organization or user account.

databaseName · string · required

The name of the database.

Response

200

application/json

Successful response

top_queries · object[] | null

The top queries performed on the given database as well as the total rows read and written.

Show child attributes