What is pgwatch2?
It is a flexible self-contained PostgreSQL metrics monitoring/dashboarding solution.
pgwatch2 is a tool in the Databases category of a tech stack.
Key Features
Non-invasive setup, no extensions nor superuser rights required for the base functionalityIntuitive metrics presentation using the Grafana dashboarding engine with optional AlertingLots of pre-configured dashboards and metric configurations covering all Statistics Collector dataEasy extensibility by defining metrics in pure SQL (thus they could also be from business domain)4 supported data stores for metrics storage (PostgreSQL, InfluxDB, Graphite, Prometheus)Multiple configuration options (YAML, PostgreSQL, ENV) supporting both "push" and "pull" models
pgwatch2 Pros & Cons
Pros of pgwatch2
No pros listed yet.
Cons of pgwatch2
No cons listed yet.
pgwatch2 Alternatives & Comparisons
What are some alternatives to pgwatch2?
Slick
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
Spring Data
It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
DataGrip
A cross-platform IDE that is aimed at DBAs and developers working with SQL databases.
DBeaver
It is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.
