Prometheus video renderer

What we'll do

Render videos in Grafana through Prometheus metrics.

How we do it

Install dependencies

brew install golang ffmpeg jsonnet-bundler
cat <<EOF >> ~/.zshrc 
# go
export GOPATH=$HOME/go
export GOBIN=$HOME/go/bin

source ~/.zshrc 
go get

Setup project

git clone
cd prometheus_video_renderer

bingo get -v
(cd grafana; jb install)

mkdir data

docker compose up
make dashboards

Convert video to metrics

We'll be using Nyan Cat original video for obvious reasons. Go ahead and download, name it nyan_cat.mp4 and place the file in the project folder.

mkdir -p frames/nyan_cat
ffmpeg -i 'nyan_cat.mp4' -vf 'scale=150:100' -vsync 0 'frames/nyan_cat/out%06d.png'

mkdir -p metrics/nyan_cat
ulimit -n 8192
prometheus_video_renderer --project nyan_cat --mode rgb --start-time 1628640000000 # 11-08-2021 00:00:00

Backfill metrics into Prometheus

scripts/ nyan_cat

Visualize output

Go to http://localhost:3000/d/pvr-dash-8-rgb/prometheus-video-renderer-8-0?orgId=1&from=1628675100000&to=1628675400000 image

Go to http://localhost:8081/render?deviceScaleFactor=1.000000&domain=localhost&encoding=&height=1080&renderKey=TljYdA5Bp7IEU7D7rasBnwc6my7mu5hW&timeout=59&timezone=&url=http://grafana:3000/d/pvr-dash-8-rgb?from%3D1628675100000%26height%3D1080%26timeout%3D59%26to%3D1628675400000%26width%3D1920%26render%3D1&width=1920 image

Render frames through Grafana

mkdir -p frames/nyan_cat/rendered/video

grafana-image-renderer-cli sequence \
    --api-url=http://localhost:3000 \
    --api-key-or-basic-auth=admin:admin \
    --dashboard=pvr-dash-8-rgb \
    --start-time=1628675099640 \
    --frame-interval=5m \
    --out-directory=frames/nyan_cat/rendered \

Merge everything back into a video

Now trim your original video to the portion of the video rendered if needed so that the audio can be merged with output.

cd frames/nyan_cat/rendered

ffmpeg -framerate 30 -i '%06d.png' \
    -i ../../../nyan_cat_trimmed.mp4 -c copy -map 0:0 -map 1:1 -c:v libx264rgb -pix_fmt rgb24 -preset veryslow -crf 0 -qp 0 \

Open video/grafanyan_cat.mp4 and enjoy ^_^

Example output: