그라파나설정

일반

알 수 없는 사용자 2022. 2. 22. 16:11

SMALL

Grafana: The open observability platform

Play around with the Grafana Stack Experience Grafana for yourself, no registration or installation needed.

grafana.com

oss 버전

초기아이디비번

admin admin

Mysql사용해서 dw_daily_feed 테이블 사용해서 5개 설정량 섭취량 체크해보기

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeed1
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeedSet1
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeed2
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeedSet2
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeed3
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeedSet3
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeed4
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeedSet4
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeed5
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeedSet5
FROM dw_daily_feed

ORDER BY time

결과

LIST