---
title: "Fetch MySQL service query statistics"
method: POST
path: "/project/{project}/service/{service_name}/mysql/query/stats"
tags: ["Service:_MySQL"]
---

# Fetch MySQL service query statistics

`POST /project/{project}/service/{service_name}/mysql/query/stats`

## Path parameters

- `project` string, required
- `service_name` string, required

## Request body

- MySQLServiceQueryStatisticsRequestBody — MySQLServiceQueryStatisticsRequestBody
  - `limit` integer — Limit for number of results
  - `offset` integer — Offset for retrieved results based on sort order
  - `order_by` string — Sort order can be either asc or desc and multiple comma separated columns with their own order can be specified: :asc,:desc. Accepted sort columns are: avg_timer_wait, count_star, digest, digest_text, first_seen, last_seen, max_timer_wait, min_timer_wait, query_sample_seen, query_sample_text, query_sample_timer_wait, quantile_95, quantile_99, quantile_999, schema_name, sum_created_tmp_disk_tables, sum_created_tmp_tables, sum_errors, sum_lock_time, sum_no_good_index_used, sum_no_index_used, sum_rows_affected, sum_rows_examined, sum_rows_sent, sum_select_full_join, sum_select_full_range_join, sum_select_range, sum_select_range_check, sum_select_scan, sum_sort_merge_passes, sum_sort_range, sum_sort_rows, sum_sort_scan, sum_timer_wait, sum_warnings

## Response `200`

Response

- MySQLServiceQueryStatisticsResponse — MySQLServiceQueryStatisticsResponse
  - `errors` object[] — List of errors occurred during request processing
    - `message` string, required — Printable error message
    - `more_info` string — URL to the documentation of the error
    - `status` integer, required — HTTP error status code
  - `message` string — Printable result of the request
  - `queries` object[], required — List of query statistics
    - `avg_timer_wait` number — Query statistic
    - `count_star` number — Query statistic
    - `digest` string — Query statistic
    - `digest_text` string — Query statistic
    - `first_seen` string — Query statistic
    - `last_seen` string — Query statistic
    - `max_timer_wait` number — Query statistic
    - `min_timer_wait` number — Query statistic
    - `quantile_95` number — Query statistic
    - `quantile_99` number — Query statistic
    - `quantile_999` number — Query statistic
    - `query_sample_seen` string — Query statistic
    - `query_sample_text` string — Query statistic
    - `query_sample_timer_wait` string — Query statistic
    - `schema_name` string — Query statistic
    - `sum_created_tmp_disk_tables` number — Query statistic
    - `sum_created_tmp_tables` number — Query statistic
    - `sum_errors` number — Query statistic
    - `sum_lock_time` number — Query statistic
    - `sum_no_good_index_used` number — Query statistic
    - `sum_no_index_used` number — Query statistic
    - `sum_rows_affected` number — Query statistic
    - `sum_rows_examined` number — Query statistic
    - `sum_rows_sent` number — Query statistic
    - `sum_select_full_join` number — Query statistic
    - `sum_select_full_range_join` number — Query statistic
    - `sum_select_range` number — Query statistic
    - `sum_select_range_check` number — Query statistic
    - `sum_select_scan` number — Query statistic
    - `sum_sort_merge_passes` number — Query statistic
    - `sum_sort_range` number — Query statistic
    - `sum_sort_rows` number — Query statistic
    - `sum_sort_scan` number — Query statistic
    - `sum_timer_wait` number — Query statistic
    - `sum_warnings` number — Query statistic

---

[API](https://skmtc.dev/aiven/apis/aiven-api-documentation.md) · [All operations](https://skmtc.dev/aiven/apis/aiven-api-documentation/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/aiven/aiven-api-documentation/revisions/6577fedfd4a2/schema)