If you need a complete guide please head to this medium story!
- Install Docker
- Install GNU Make (Not essential)
- Run
docker compose up -d
(If you installed makefile you can usemake up
)
- CRUD operations on database
- Locks & Dead Locks
- Connections
- CPU Usage
- Load Average
- Memory Usage
- Shared Buffers
- Current Fetched Data
- Database Cache
- Parallel Workers
- Transactions
- Sessions
- and so much more...
The containers and their exposed ports are:
- postgresql -
:5432
- prometheus -
:9090
- grafana -
:3000
- postgresql-exporter -
:9187