pgwatch2 - PostgreSQL metrics monitor/dashboard

  •        121

Software is packaged as Docker (for custom setup see the last paragraph below, for a Docker quickstart see here) for getting started quickly. After some minutes you could open the "db-overview" dashboard and start looking at metrics. For defining your own dashboards you need to log in as admin (admin/pgwatch2admin). NB! If you don't want to add the "test" database (the pgwatch2 configuration db) for monitoring set the NOTESTDB=1 env parameter when launching the image.

https://github.com/cybertec-postgresql/pgwatch2

Tags
Implementation
License
Platform

   




Related Projects

PGObserver - A battle-tested, flexible & comprehensive monitoring solution for your PostgreSQL databases

  •    Python

PGObserver is a battle-tested monitoring solution for your PostgreSQL databases. It covers almost all the metrics provided by the database engine's internal statistics collector, and works out of the box with all PostgreSQL versions (beginning with 9.0) as well as AWS RDS. You don’t have to install any non-standard, server-side database extensions to take advantage of its core functionality, nor do you need to register any privileged users.For some metrics you must install data-gathering wrapper functions — also known as stored procedures — on the server being monitored. This will enable you to circumvent the superuser requirements.

AppMetrics - App Metrics is an open-source and cross-platform

  •    CSharp

App Metrics is an open-source and cross-platform .NET library used to record metrics within an application. App Metrics can run on .NET Core or on the full .NET framework also supporting .NET 4.5.2. App Metrics abstracts away the underlaying repository of your Metrics for example InfluxDB, Graphite, Elasticsearch etc, by sampling and aggregating in memory and providing extensibility points to flush metrics to a repository at a specified interval.App Metrics provides various metric types to measure things such as the rate of requests, counting the number of user logins over time, measure the time taken to execute a database query, measure the amount of free memory and so on. Metrics types supported are Gauges, Counters, Meters, Histograms and Timers and Application Performance Indexes Apdex.

postgresql-metrics - Tool that extracts and provides metrics on your PostgreSQL database

  •    Python

Service to extract and provide metrics on your PostgreSQL database.This tool is a CLI (command line) tool that can be called to extract statistics and create metrics regarding your PostgreSQL database cluster. CLI is runnable in long running process mode, which will periodically send the gathered metrics forward.

Stagemonitor - Application performance monitoring for java server applications

  •    Java

Stagemonitor is a Java monitoring agent that tightly integrates with time series databases like Elasticsearch, Graphite and InfluxDB to analyze graphed metrics and Kibana to analyze requests and call stacks. It includes preconfigured Grafana and Kibana dashboards that can be customized. It supports Real Time Metrics, Call tree of the current request including SQL statements to identify the bottlenecks of a request, Execution time and count of database interactions, Analyze the HTTP headers and lot more.

pg_view - Get a detailed, real-time view of your PostgreSQL database and system metrics

  •    Python

pg_view is a powerful command-line tool that offers a detailed, real-time view of your PostgreSQL database and system metrics. It combines the indicators commonly displayed by sar or iostat with output from PostgreSQL's process activity view, and presents global and per-process statistics in an easy-to-interpret way.pg_view can be especially helpful when you're monitoring system load, query locks and I/O utilization during lengthy data migrations. It's also useful when you're running servers 24x7 and aiming for zero downtime. Learn more about it at tech.zalando.com.


Grafana - The leading graph and dashboard builder for visualizing time series metrics

  •    Go

Grafana is an open source, feature rich metrics dashboard and graph editor for Graphite, Elasticsearch, OpenTSDB, Prometheus and InfluxDB. It is most commonly used for visualizing time series data for Internet infrastructure and application analytics but many use it in other domains including industrial sensors, home automation, weather, and process control.

influxdb - Scalable datastore for metrics, events, and real-time analytics

  •    Go

InfluxDB is an open source time series database with no external dependencies. It's useful for recording metrics, events, and performing analytics. If you're feeling adventurous and want to contribute to InfluxDB, see our contributing doc for info on how to make feature requests, build from source, and run tests.

grafterm - Metrics dashboards on terminal (a grafana inspired terminal version)

  •    Go

Visualize metrics dashboards on the terminal, like a simplified and minimalist version of Grafana for terminal. And run grafterm in debug mode.

mackerel-agent - mackerel-agent is an agent program to post your hosts' metrics to mackerel.io.

  •    Go

mackerel-agent is a client software for Mackerel. Mackerel is an online visualization and monitoring service for servers. Collected information will be visualized on Mackerel.

Hawkular metrics - Time Series Metrics Engine based on Cassandra

  •    Java

Hawkular Metrics is a metrics collection, aggregation, visualization framework. Hawkular is a set of Open Source projects designed to be a generic solution for common monitoring problems. The Hawkular projects provide REST services that can be used for all kinds of monitoring needs. The aim is to provide a generic solution that can be used for common monitoring problems.

pgcenter - Command-line admin tool for observing and troubleshooting Postgres.

  •    Go

pgCenter is a command-line admin tool for observing and troubleshooting Postgres. Postgres provides various activity statistics that include detailed information about its behaviour: connections, statements, database operations, replication, resources usage and more. General purpose of the statistics is to help DBAs to monitor and troubleshoot Postgres. However, these statistics provided in textual form retrieved from SQL functions and views, and Postgres doesn't provide any tools for working with them. pgCenter's main goal is to help Postgres DBA manage statistics that theу have in their databases and see all the necessary data in convenient format based on builtin stats views and functions.

repmgr - The Most Popular Replication Manager for PostgreSQL (Postgres) - latest version 4

  •    C

repmgr is a suite of open-source tools to manage replication and failover within a cluster of PostgreSQL servers. It enhances PostgreSQL's built-in replication capabilities with utilities to set up standby servers, monitor replication, and perform administrative tasks such as failover or switchover operations. repmgr 4 is a complete rewrite of the existing repmgr codebase, allowing the use of all of the latest features in PostgreSQL replication.

Micrometer - An application metrics facade for the most popular monitoring tools

  •    Java

An application metrics facade for the most popular monitoring tools. Instrument your code with dimensional metrics with a vendor neutral interface and decide on the monitoring backend at the last minute. Micrometer is the instrumentation library underpinning Spring Boot 2.0's metrics collection.

rust-postgres - Native PostgreSQL driver for the Rust programming language

  •    Rust

A native PostgreSQL driver for Rust.Rust-Postgres is a pure-Rust frontend for the popular PostgreSQL database.

govaluate - Arbitrary expression evaluation for golang

  •    Go

Provides support for evaluating arbitrary C-like artithmetic/string expressions. Sometimes, you can't know ahead-of-time what an expression will look like, or you want those expressions to be configurable. Perhaps you've got a set of data running through your application, and you want to allow your users to specify some validations to run on it before committing it to a database. Or maybe you've written a monitoring framework which is capable of gathering a bunch of metrics, then evaluating a few expressions to see if any metrics should be alerted upon, but the conditions for alerting are different for each monitor.

prometheus - Kubernetes Setup for Prometheus and Grafana

  •    Smarty

This will create the namespace monitoring and bring up all components in there. See grafana.net for some example dashboards and plugins.