nginx日志查看今日的PV和昨日的对比

关键词

同比

相关函数

round,compare,count

先通过count函数计算总的pv，再用compare函数得出今日的pv与昨日的同比

通过单值图进行展示，显示值为20.381Mil，对比值为-2%

* |
select
  diff [1] as today,
  round((diff [3] -1.0) * 100, 2) as growth
FROM
  (
    SELECT
      compare(pv, 86400) as diff
    FROM
      (
        SELECT
          COUNT(1) as pv
        FROM
          log
      )
  )

SQL查询结果样例：