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
0
二维码
打赏
海报
Grafana曲线图展示每秒新增数据量
添加MySQL数据源 -> 添加查询条件
sql 模式编写查询条件:
SELECT
$__timeGroupAlias(create_time, $interval),
count(order_no) as '创单数量……
文章目录
关闭
共有 0 条评论