telegraf → TimescaleDB を Grafana に表示する

without timzone.sql

SELECT
  host,
  MAX(usage_user),
  time_bucket('10min', time) AS bucket
FROM
  telegraf.cpu
WHERE
  (
    to_timestamp($__unixEpochFrom()) -
      (NOW() - NOW() AT TIME ZONE 'UTC')
  ) < time
  AND
  time < 
  (
    to_timestamp($__unixEpochTo()) -
      (NOW() - NOW() AT TIME ZONE 'UTC')
  )
GROUP BY
  host, bucket
HAVING
  host = 'example.com'