back to home

cybertec-postgresql / pgwatch

🔬pgwatch: PostgreSQL metrics monitor/dashboard

View on GitHub
799 stars
121 forks
19 issues
GoTypeScriptPLpgSQL

AI Architecture Analysis

This repository is indexed by RepoMind. By analyzing cybertec-postgresql/pgwatch in our AI interface, you can instantly generate complete architecture diagrams, visualize control flows, and perform automated security audits across the entire codebase.

Our Agentic Context Augmented Generation (Agentic CAG) engine loads full source files into context on-demand, avoiding the fragmentation of traditional RAG systems. Ask questions about the architecture, dependencies, or specific features to see it in action.

Source files are only loaded when you start an analysis to optimize performance.

Embed this Badge

Showcase RepoMind's analysis directly in your repository's README.

[![Analyzed by RepoMind](https://img.shields.io/badge/Analyzed%20by-RepoMind-4F46E5?style=for-the-badge)](https://repomind.in/repo/cybertec-postgresql/pgwatch)
Preview:Analyzed by RepoMind

Repository Overview (README excerpt)

Crawler view

pgwatch: PostgreSQL monitoring solution Overview pgwatch is a scalable and flexible PostgreSQL-specific monitoring solution that offers a comprehensive view of database performance and health. It provides a user-friendly interface through Grafana dashboards, allowing users to easily inspect various metrics and trends. Visit demo.pgwatch.com for a Grafana demo, and pgwat.ch for full documentation. Quick Start To fetch and run the latest **demo** Docker image, exposing • Grafana on port 3000, • the administrative web UI on port 8080, • the internal configuration and metrics database on port 5432: After a few minutes, you can open the "Database Overview" dashboard and start looking at the metrics. To define your own dashboards, you need to log in to Grafana as admin ( / ). If you don't want to add the test database for monitoring, remove the parameter when launching the container. Development and production use For production and long-term installation Docker image should be used. For the fastest development and deployment experience, the Docker compose files are provided. • The usual production setup should involve: • For development purposes, you want to build the image from source: These commands will build and start services listed in the compose file: • configuration and metric database; • pgwatch monitoring agent with WebUI; • Grafana with dashboards. Monitor Database After starting, you could open the monitoring dashboard and start looking at metrics. To add a test database to monitoring, you can use the built-in WebUI. Produce Workload To emulate workload for the added test database, execute: Inspect database > [!IMPORTANT] pgAdmin uses port 80. If you want it to use another port, change it in file. To look at what is inside the database, you can spin up pgAdmin4: Go to in your favorite browser and log in as , password . Server should already be added to the group. Development If you apply any changes to the source code and want to restart the agent, it's usually enough to run: The command above will rebuild the agent from source and relaunch the container. Logs If you are running containers in detached mode, you can still follow the logs: Or you may check the log of a particular service: Contributing Feedback, suggestions, problem reports, and pull requests are very much appreciated.