# host\_summary and x$host\_summary Sys Schema Views

{% hint style="info" %}
Sys Schema views are available from MariaDB 10.6.
{% endhint %}

## Description

The `host_summary` and `x$host_summary` views contain host activity information, grouped by host. The `host_summary` view is intended to be easier for human reading, while the `x$host_summary` view provides the data in raw form, intended for tools that process the data.

They contain the following columns:

| Column                   | Description                                                                                                                                           |
| ------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------- |
| host                     | Host that the client connected from, or background for background threads (where the HOST column in the underlying Performance Schema table is NULL). |
| statements               | Total number of statements for the host.                                                                                                              |
| statement\_latency       | Total wait time of timed statements for the host.                                                                                                     |
| statement\_avg\_latency  | Average wait time per timed statement for the host.                                                                                                   |
| table\_scans             | Total table scans for the host.                                                                                                                       |
| file\_ios                | Total file I/O events for the host.                                                                                                                   |
| file\_io\_latency        | Total wait time of timed file I/O events for the host.                                                                                                |
| current\_connections     | Current connections for the host.                                                                                                                     |
| total\_connections       | Total connections for the host.                                                                                                                       |
| unique\_users            | Number of distinct users for the host.                                                                                                                |
| current\_memory          | Current allocated memory for the host.                                                                                                                |
| total\_memory\_allocated | Total allocated memory for the host.                                                                                                                  |

## Example

```sql
SELECT * FROM sys.host_summary\G
*************************** 1. row ***************************
                  host: localhost
            statements: 59
     statement_latency: 148.11 ms
 statement_avg_latency: 2.51 ms
           table_scans: 11
              file_ios: 2065
       file_io_latency: 79.57 ms
   current_connections: 1
     total_connections: 3
          unique_users: 1
        current_memory: -2672 bytes
total_memory_allocated: 0 bytes

SELECT * FROM sys.x$host_summary\G
*************************** 1. row ***************************
                  host: localhost
            statements: 98
     statement_latency: 160926285000
 statement_avg_latency: 1642104948.9796
           table_scans: 12
              file_ios: 2071
       file_io_latency: 79742533755
   current_connections: 1
     total_connections: 3
          unique_users: 1
        current_memory: -2672
total_memory_allocated: 0
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/host_summary-and-xhost_summary-sys-schema-views.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.