Saya sarankan Anda membiasakan diri dengan decoding laporan oleh Roman Havronenko "ExtendedPromQL"
Tentang saya secara singkat. Nama saya Roman. Saya bekerja di CloudFlare, tinggal di London. Tapi saya juga pelindung VictoriaMetrics.
Dan saya penulis plugin ClickHouse untuk Grafana dan ClickHouse-proxy - ini adalah proxy kecil untuk ClickHouse.
, « » , – . , , . , – java - . , , .
. PromQL? PromQL – Prometheus Query Language. , Prometheus, time series , .
time series ? , .
:
( , ), .
. , . . . , 15 000 . time series .
"" () . , . , -, . . , , , Jay Silent Bob. , ; .
. ClickHouse . , «Steps», . . . , ; - -, , : Jay Silent Bob.
, Grafana, , -, .
. . – . , time series ClickHouse, Grafana.
Graph Panel. Grafana, , .
— Grafana, ClickHouse, , . . . , . . , .
. , ?
, .
, . , ? , , Grafana time series, - , time series – - labels.
. Jay.
. . .
, , , , Prometheus PromQL. . . . Steps. Jay. , .
Jay Silent Bob. ClickHouse runningDifference, . . , . .
, . . 1,8 Silent Bob Jay.
Prometheus , . , .
Grafana , PromQL. Rate Macros . Grafana «rate», - . , - , , SQL- – . , .
, . ClickHouse, rate, time series: Silent Bob, Jay, time series. , .
Prometheus sum (rate). ClickHouse , RateColumns, , Prometheus.
PromQL , , , .
:
- Limited SELECT.
- JOIN.
- HAVING.
, , - PromQL, SQL , , , SQL. ? , .
. . , , , , .
– Extending PromQL.
VictoriaMetrics. VictoriaMetrics? time series , OpenSource, single cluster-. , , . . - 0,4 , Prometheus – 1,2-1,4.
Prometheus. InfluxDB, Graphite, OpenTSDB.
"", . . .
Prometheus Grafana, . . PromQL engine. Grafana Prometheus endpoint VictoriaMetrics , .
, VictoriaMetrics.
, .
Omit interval param – Grafana. zoom-in/out , $__interval. Grafana . VictoriaMetrics , . . .
– interval referencing. . , , , .
rollup function. Rollup function time series time series. min, max avg. , , - outliers ( ) .
irate rate, - , time series , . , , max avg.
default. Default – , Grafana, time series . ? - . , , . , success error. , error. default .
Keep_last_Value – , . Prometheus 5 , .
Scrape_interval – , Prometheus , . , .
Label replace – . , , . 5 , .
, ? . . .
. , extended PromQL? Common Table Expressions. QR- (https://github.com/VictoriaMetrics/VictoriaMetrics/wiki/ExtendedPromQL), , playground, VictoriaMetrics .
? – . , . . - , , , JSON, find replace, . ? , , .
, Grafana , . Grafana?
: commonFilter , . , , Grafana . .
, . , , . https://github.com/grafana/grafana/pull/16694
PromQL extended. , . ru (resource usage). , . . . . . , . , , , - .
- . NodeExporter Grafana. , . . ., , , , , . ?
, , . . , , Grafana.
, , ru, VictoriaMetrics. , CTE.
, , . , , Grafana - . , , Grafana , - . - -. , - , . . .
, , , SRE. , , , , Grafana, . . , . 100 , - .
, Grafana, ? , . , , , , , ?
. . Grafana. , , NodeExporter, , . .
. . . Grafana, JSON , . . . - , .
-, , Grafana . Grafana "", - - – . , .
VictoriaMetrics. . compression, time series , PromQL, , vertical scalability Thanos.
:
. Grafana, 5 . . production. , , , , . . , , Grafana? , - – . , , . .
. . – , , , , , . - , , , . – , , , capacity planning - .
?
? , .
Grafana.
Grafana? Grafana DataSource.
- .
, Grafana . GET-, , , step. , , , . . , Grafana, .
! ! mapping , Grafana . , ?
.
, alert Grafana. alert . , , alerts Grafana?
Grafana - -, – , . Grafana , alertmanager.
Ya, saya menggunakannya, tetapi sepertinya lebih mudah diatur di Grafana, tetapi terima kasih atas sarannya!