host_summary_by_statement_latency and x$host_summary_by_statement_latency Sys Schema Views - Source

Revision: 143359
User: Ian Gilfillan
Date: 2024-09-17 13:05

<<product mariadb from=10.6>>
These [[sys-schema|Sys Schema]] views were introduced in MariaDB 10.6.
<</product>>

== Description

The ##host_summary_by_statement_latency## and ##x$host_summary_by_statement_latency## views summarize statement statistics, grouped by host. Rows are sorted by descending total latency by default.  The ##host_summary_by_statement_latency## view is intended to be easier for human reading, while the ##x$host_summary_by_statement_latency## view provides the data in raw form, intended for tools that process the data.

They contain the following columns:

== Example
<<code>>
SELECT * FROM sys.host_summary_by_statement_latency\G
*************************** 1. row ***************************
         host: localhost
        total: 1042
total_latency: 816.89 ms
  max_latency: 64.51 ms
 lock_latency: 215.64 ms
    rows_sent: 750599937895985
rows_examined: 13548
rows_affected: 6
   full_scans: 33
*************************** 2. row ***************************
         host: background
        total: 0
total_latency: 0 ps
  max_latency: 0 ps
 lock_latency: 0 ps
    rows_sent: 0
rows_examined: 0
rows_affected: 0
   full_scans: 0

SELECT * FROM sys.x$host_summary_by_statement_latency\G
*************************** 1. row ***************************
         host: localhost
        total: 1041
total_latency: 812132706000
  max_latency: 64507216000
 lock_latency: 215301000000
    rows_sent: 750599937895983
rows_examined: 13110
rows_affected: 6
   full_scans: 32
*************************** 2. row ***************************
         host: background
        total: 0
total_latency: 0
  max_latency: 0
 lock_latency: 0
    rows_sent: 0
rows_examined: 0
rows_affected: 0
   full_scans: 0
<</code>>

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

host_summary_by_statement_latency and x$host_summary_by_statement_latency Sys Schema Views - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB