Graphical serve’s stats with Python + Postgresql + Grafana

Python script that gets realtime stats data from server.

Dependencies

• Grafana
• Postgresql server
• Everything else at the top of stats.py!

Usage:

1. Create DB user: sudo -u postgres createuser -D -A -P username
2. Create DB: sudo -u postgres createdb -O username statsdb
3. Edit config-sample.txt (and rename to config.txt) to specify the hostname of the server you would like to get data from, its DB name and DB user.
4. Run ‘python stats-py’ within Python Virtual Environment to test everything is OK. Install all needed packages with ‘pip install package’
5. Use your favourite scheduling method to set ./stats.py to run regularly.
6. Add the datasource PostgreSQL to your Grafana, configuring Host (usually localhost:5432), Database, User andPassword fields.

Then you could graph your server stats with Grafana’s PostgreSQL datasource!

What values can you track in Grafana?

• CPU % usage
• Memory size
• Memory used size
• Memory % used
• Disk size
• Disk free size
• Disk used size
• Disk used %
• Disk IO read bytes
• Disk IO write bytes
• Net IO sent bytes
• Net IO receive bytes