Grafana曲线图展示每秒新增数据量

添加MySQL数据源 -> 添加查询条件

sql 模式编写查询条件:

SELECT
  $__timeGroupAlias(create_time, $interval),
  count(order_no) as '创单数量'
FROM t_order
WHERE
  merchant_id = $merchant_id AND
  $__timeFilter(create_time)
GROUP BY 1
ORDER BY
  $__timeGroup(create_time, $interval);
SELECT
  $__timeGroupAlias(create_time, 1s),
  count(uuid) AS "num"
FROM t_user
WHERE
  $__timeFilter(create_time)
GROUP BY 1
ORDER BY $__timeGroup(create_time, 1s)

版权声明:
作者:Joe.Ye
链接:https://www.appblog.cn/index.php/2023/03/25/grafana-curve-showing-amount-of-new-data-added-per-second/
来源:APP全栈技术分享
文章版权归作者所有,未经允许请勿转载。

THE END
分享
二维码
打赏
海报
Grafana曲线图展示每秒新增数据量
添加MySQL数据源 -> 添加查询条件 sql 模式编写查询条件: SELECT $__timeGroupAlias(create_time, $interval), count(order_no) as '创单数量&#……
<<上一篇
下一篇>>
文章目录
关闭
目 录