---
title: "/api/query-logs/{id}"
method: GET
path: "/api/query-logs/{id}"
---

# /api/query-logs/{id}

`GET /api/query-logs/{id}`

## Path parameters

- `id` string, required

## Response `200`

Successful response

- object
  - `data` object, required
    - `id` integer, required
    - `query` string, required
    - `normalized_query` string
    - `duration` number
    - `connection` string
    - `status` 'completed' | 'failed' | 'slow'
    - `error` string
    - `executed_at` string, required
    - `model` string
    - `method` string
    - `line` number
    - `memory_usage` number
    - `rows_affected` number
    - `transaction_id` string
    - `tags` string
    - `affected_tables` string
    - `indexes_used` string
    - `missing_indexes` string
    - `explain_plan` string
    - `optimization_suggestions` string
    - `created_at` string, date-time
    - `updated_at` string, date-time

## Other responses

- `422` — Validation failed
- `500` — Server error

---

[API](https://skmtc.net/stacksjs/apis/stacks-api.md) · [All operations](https://skmtc.net/stacksjs/apis/stacks-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/stacksjs/stacks-api/revisions/f48edd85a8b4/schema)