x$ps_digest_avg_latency_distribution

• 帮助视图(辅助试图)，用于帮助x$ps_digest_95th_percentile_by_avg_us视图生成语句百分之九十五的平均执行时间分布值，数据来源：events_statements_summary_by_digest

• x$ps_digest_avg_latency_distribution视图字段含义如下：

  • cnt：按照语句平均执行时间的分组计数值
  • avg_us：语句平均执行时间（微秒单位）

• 视图定义语句

CREATE OR REPLACE
  ALGORITHM = TEMPTABLE
  DEFINER = 'root'@'localhost'
  SQL SECURITY INVOKER
VIEW x$ps_digest_avg_latency_distribution (
  cnt,  avg_us
) AS
SELECT COUNT(*) cnt,
      ROUND(avg_timer_wait/1000000) AS avg_us
  FROM performance_schema.events_statements_summary_by_digest
GROUP BY avg_us;

• 视图查询信息示例

admin@localhost : sys 01:00:38> select * from x$ps_digest_avg_latency_distribution limit 3;
+-----+--------+
| cnt | avg_us |
+-----+--------+
|  2 |    38 |
|  1 |    43 |
|  1 |    57 |
+-----+--------+
3 rows in set (0.00 sec)

• 参考链接：辅助视图无参考链接

---

上一篇： x$ps_digest_95th_percentile_by_avg_us视图 |

下一篇： x$ps_schema_table_statistics_io视图