Railway

Deploy and Host pgwatch on Railway

pgwatch is an open-source, flexible, and self-contained PostgreSQL metrics monitor. It uses Grafana for visualization and relies on standard PostgreSQL statistics collectors to track database health, performance, and resource utilization without requiring intrusive agents.

About Hosting pgwatch

Hosting pgwatch requires a centralized metrics database, a Grafana instance for visualization, and the pgwatch collector daemon. This template provides a preconfigured, one-click deployment that orchestrates these components automatically. Out of the box, the environment variables and persistent volumes are fully set up. To begin monitoring, the only manual configuration required is logging into the pgwatch dashboard and entering your target PostgreSQL database URL. Once connected, the metrics are routed directly to Grafana, allowing you to visualize database health immediately.

Common Use Cases

Identifying slow queries and performance bottlenecks in production PostgreSQL databases.
Monitoring database resource utilization, such as connection counts and locking statistics.
Tracking cache hit ratios and transaction rates to optimize database configurations.

Dependencies for pgwatch Hosting

PostgreSQL database (for storing pgwatch configuration and historical time-series data)
Grafana (for rendering the dashboards and visualizing exported metrics)

Deployment Dependencies

Implementation Details

This template is a preconfigured, one-click deployment. Once the deployment is live on Railway, you can access the dashboards immediately:

pgwatch Web UI: Log in with the default credentials admin / admin. These are configured automatically via the PW_WEBUSER and PW_WEBPASSWORD environment variables.
Grafana: Log in with the default credentials admin / admin. Grafana will prompt you to change this password upon your first successful login.

To start seeing data, simply navigate to the pgwatch Web UI, add your target PostgreSQL database connection URL, and your metrics will populate in the Grafana dashboards.

Why Deploy pgwatch on Railway?

Railway is a singular platform to deploy your infrastructure stack. Railway will host your infrastructure so you don't have to deal with configuration, while allowing you to vertically and horizontally scale it.

By deploying pgwatch on Railway, you are one step closer to supporting a complete full-stack application with minimal burden. Host your servers, databases, AI agents, and more on Railway.