如何计算grafana / postgres中不同记录的列值之间的差异

作者: 明月清风上善若水自由如风
发布时间: 2024-07-01 04:26:58 (1月前)
转自：

2 条回复

0#
回复此人
那年 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 我无法在grafana中执行此操作（减去两个查询）并且能够使用postgres查询（包括grafana宏）执行此操作： </p> <pre> <code> SELECT (first / second * 10000 - 10000) as spread, time FROM ( SELECT $__timeGroupAlias("time",$__interval,previous), avg(bid) AS "first" FROM bbo_20s WHERE $__timeFilter("time") AND market = 1 GROUP BY time ) AS e FULL JOIN ( SELECT $__timeGroupAlias("time",$__interval,previous), avg(bid) AS "second" FROM bbo_20s WHERE $__timeFilter("time") AND market = 2 GROUP BY time ) AS c USING ("time") ; </code> </pre> <P> 结果看起来像这样，性能非常好： </p> <P> <a href="https://i.stack.imgur.com/BnnGw.png" rel="nofollow noreferrer"> <img src =“https://i.stack.imgur.com/BnnGw.png”alt =“在此处输入图片说明”/> </A> </p> </DIV>

编辑

登录后才能参与评论