Documentation Home
MySQL 9.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.0Mb
PDF (A4) - 40.1Mb
Man Pages (TGZ) - 259.0Kb
Man Pages (Zip) - 366.2Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


MySQL 9.0 Reference Manual  /  ...  /  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 Schema events_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.

Press CTRL+C to copy
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;