Documentation Home
MySQL 8.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.2Mb
PDF (A4) - 40.3Mb
Man Pages (TGZ) - 262.0Kb
Man Pages (Zip) - 367.6Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


MySQL 8.4 Reference Manual  / ...  / MySQL sys Schema  / sys Schema Object Reference  / sys Schema Stored Procedures  /  The ps_statement_avg_latency_histogram() Procedure

30.4.4.21 The ps_statement_avg_latency_histogram() Procedure

Displays a textual histogram graph of the average latency values across all normalized statements tracked within the Performance Schemaevents_statements_summary_by_digest table.

This procedure can be used to display a very high-level picture of the latency distribution of statements running within this MySQL instance.

Parameters

None.

Example

The histogram output in statement units. For example,* = 2 units in the histogram legend means that each* character represents 2 statements.

mysql> CALL sys.ps_statement_avg_latency_histogram()\G*************************** 1. row ***************************Performance Schema Statement Digest Average Latency Histogram:  . = 1 unit  * = 2 units  # = 3 units(0 - 66ms)     88  | #############################(66 - 133ms)   14  | ..............(133 - 199ms)  4   | ....(199 - 265ms)  5   | **(265 - 332ms)  1   | .(332 - 398ms)  0   |(398 - 464ms)  1   | .(464 - 531ms)  0   |(531 - 597ms)  0   |(597 - 663ms)  0   |(663 - 730ms)  0   |(730 - 796ms)  0   |(796 - 863ms)  0   |(863 - 929ms)  0   |(929 - 995ms)  0   |(995 - 1062ms) 0   |  Total Statements: 114; Buckets: 16; Bucket Size: 66 ms;