How can I check the load of the PostgreSQL container?

• pgcenter

  2 1,509 0.0 Go

  Command-line admin tool for observing and troubleshooting Postgres.

pgmetrics will not tell you anything about the load in your database and container. It is more about the details of the internal structure of the database. You can try the pgcenter tool. https://github.com/lesovsky/pgcenter

• patroni

  19 6,212 9.2 Python

  A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes

  

Want a tool for increasing the durability of your DB? I suggest running postgres via systemd, or failing that, start-stop-daemon. To get even more robust, look in to something like setting up pgbouncer in front of haproxy in front of a set of read-only replica PG instances running in either logical or streaming replication. To get even MORE robust, I suggest Patroni for high-availability PG.

• SurveyJS

  surveyjs.io sponsored

  Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

  

• Grafana

  379 60,279 10.0 TypeScript

  The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.

  

Want a tool for alerting when your DB or app are offline? The tool I would suggest is DataDog but it is not free... I am told that Grafana is a good Open Source monitoring & observability platform.

Suggest a related project