I've released open-source project — pgsyswatch 🛠
It's an extension for PostgreSQL that tracks system metrics (CPU, memory, disk, network) directly from your database.
What does it offer?
- Easy integration with PostgreSQL.
- Quick identification of bottlenecks in the system.
- Full control over infrastructure performance for DevOps and DB administrators.
- Online binding of the system process and its consumption by the main metrics to a specific SQL query + history of snapshots once a minute in a partitioned table with automatic creation and deletion of old and new sections
🔗 Link: https://github.com/psqlmaster/pgsyswatch