How to Add Pool Data from Cexplorer to your Grafana Dashboard
This guide will walk you through the process of adding your pool stats from Cexploer.io to your Grafana dashboard.
Copy your Json file from Cexplorer.io. Navigate to your pool then click on Share Tab. Then scroll down to "Data" and copy link to "JSON data output" file. Copy URL.
Keep this URL you will need it later
click on Share Tab
scroll down to "Data" copy link to "JSON data output"
Copy URL
Create poolStat directory by running the following commands:
cd $NODE_HOME
mkdir -p poolStat
Now we will create a script in the poolStat directory to pull pool stat json file and trim non-numeric strings.
Prometheus can work only with numeric data, so we must trim non-numeric strings which is returned from the JSON file provided by Cexplorer.
Replace "https://js.cexplorer.io/api-static/pool/poolID.json" with the URL that you copied from Step 1
cd poolStat
echo "curl https://js.cexplorer.io/api-static/pool/poolID.json 2>/dev/null | jq '.data | del(.pool_id, .name, .pool_id_hash, .handles, .twitter_handle, .telegram_handle, .homepage, .url, .img, .updated, .stats)' | tr -d \\\"{},: | awk NF | sed -e 's/^[ \t]*/cexplorer_/' > $NODE_HOME/poolStat/poolStat.prom" > getstats.sh
Add permissions and run getstat script by running these commands:
chmod +x getstats.sh
./getstats.sh
Check output file to make sure it contains only numeric values by running:
cd $NODE_HOME/poolStat
cat poolStat.prom
Your results should look similar to this example:cexplorer_stake 1172188909230 cexplorer_stake_active 1172188909230 cexplorer_tax_ratio 1 cexplorer_tax_fix 340000000 cexplorer_blocks_epoch 0 cexplorer_blocks_lifetime 19 cexplorer_roa_short 1.226 cexplorer_roa_lifetime 1.52 cexplorer_pledge 25000000000 cexplorer_delegators 18 cexplorer_position 672 cexplorer_blocks_est_epoch 1.01 cexplorer_luck_lifetime 0.89 cexplorer_saturation 0.016733
Configure prometheus-node-exporter.service to grab data from poolStat.prom file.
First let's backup the prometheus-node-exporter.service file by running the following:
sudo cp /lib/systemd/system/prometheus-node-exporter.service /lib/systemd/system/prometheus-node-exporter.service_backup
Then let's edit file by running the following command:
sudo nano /lib/systemd/system/prometheus-node-exporter.service
Now we need to change ExecStart line to:
Replace "< YOUR NODE FULL PATH >"
Hint: to find your full path run:
cd $NODE_HOME
readlink -f poolStat
[Service]
ExecStart=/usr/bin/prometheus-node-exporter --collector.textfile.directory=< YOUR NODE FULL PATH >/poolStat/ --collector.textfile
hange the default user to your Linux user name in prometheus-node-exporter.service. Replace below.
[Service]
User=<Linux User Name>
Or Alternatively: The default user of prometheus-node-exporter is “prometheus”. So, you could give the user “prometheus” read and write rights for poolStat.prom
Reload daemon and restart services by running:
sudo systemctl daemon-reload
sudo systemctl restart prometheus-node-exporter.service
sudo systemctl restart prometheus.service
Verify that the services are running properly:
sudo systemctl status grafana-server.service prometheus.service prometheus-node-exporter.service
The data will constantly change so we need to setup a cron job to grab the new data every so often. In this example we will grab new data every 6 hours.
First run:
crontab -e
Add the following to your cronjobs.
Replace "<YOUR NODE FULL PATH>"
Hint: to find your full path run:
find ~+ -type f -name getstats.sh
0 */6 * * * <YOUR NODE FULL PATH >/poolStat/getstats.sh
Now for your data source select Prometheus:
Select Prometheus for Data source
Now you should see all the "cexplorer_" Metrics
Some of the data you might want to display:
Remember amounts are given in lovelace so you need to divide by 1,000,000 to display in ADA
- 1.Pledge = (cexplorer_pledge)/1000000
- 2.Active Stake = (cexplorer_stake)/1000000
- 3.Lifetime Blocks = cexplorer_blocks_lifetime
- 4.Estimated Blocks per Epoch = cexplorer_blocks_est_epoch
- 5.Lifetime ROA = cexplorer_roa_lifetime
- 6.Current Number of Delegators = cexplorer_delegators
- 7.Pool Rank = cexplorer_position
- 8.Lifetime Luck = (cexplorer_luck_lifetime)*100
Thanks to the following pools for helping to put together these guides. Please consider delegating to their pools to support them. Are you a pool? Consider buying them a coffee
Last modified 6mo ago