• Stars
    star
    568
  • Rank 78,180 (Top 2 %)
  • Language PLpgSQL
  • License
    Other
  • Created about 7 years ago
  • Updated 19 days ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

PostgreSQL Monitoring, Metrics Collection and Alerting Resources from Crunchy Data

pgMonitor

pgMonitor is your all-in-one tool to easily create an environment to visualize the health and performance of your PostgreSQL cluster.

pgMonitor

pgMonitor combines a suite of tools to facilitate the collection and visualization of important metrics that you need be aware of in your PostgreSQL database and your host environment, including:

  • Connection counts: how busy is your system being accessed and if connections are hanging
  • Database size: how much disk your cluster is using
  • Replication lag: know if your replicas are falling behind in loading data from your primary
  • Transaction wraparound: don't let your PostgreSQL database stop working
  • Bloat: how much extra space are your tables and indexes using
  • System metrics: CPU, Memory, I/O, uptime

pgMonitor is also highly configurable, and advanced users can design their own metrics, visualizations, and add in other features such as alerting.

Running pgMonitor will give you confidence in understanding how well your PostgreSQL cluster is performing, and will provide you the information to make calculated adjustments to your environment.


Please view the official Crunchy Data pgMonitor documentation here. If you are interested in contributing or making an update to the documentation, please view the Contributing Guidelines.


Sponsors

Crunchy Data

Crunchy Data is pleased to sponsor pgMonitor and many other open-source projects to help promote support the PostgreSQL community and software ecosystem.


Legal Notices

Copyright Β© 2017-2023 Crunchy Data Solutions, Inc. All Rights Reserved.

CRUNCHY DATA SOLUTIONS, INC. PROVIDES THIS GUIDE "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.

Crunchy, Crunchy Data Solutions, Inc. and the Crunchy Hippo Logo are trademarks of Crunchy Data Solutions, Inc. All Rights Reserved.

More Repositories

1

postgres-operator

Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
Go
3,884
star
2

crunchy-containers

Containers for Managing PostgreSQL on Kubernetes by Crunchy Data
Shell
1,011
star
3

pg_tileserv

A very thin PostGIS-only tile server in Go. Takes in HTTP tile requests, executes SQL, returns MVT tiles.
Go
858
star
4

pg_featureserv

Lightweight RESTful Geospatial Feature Server for PostGIS in Go
Go
451
star
5

crunchy-proxy

PostgreSQL Connection Proxy by Crunchy Data (beta)
Go
413
star
6

pg_eventserv

Small golang server to push PgSQL listen/notify events into websockets
Go
200
star
7

postgres-operator-examples

Examples for deploying applications with PGO, the Postgres Operator from Crunchy Data
Handlebars
184
star
8

pgCompare

pgCompare – a straightforward utility crafted to simplify the data comparison process, providing a robust solution for comparing data across various database platforms.
Java
79
star
9

postgresql-prometheus-adapter

Remote storage adapter enabling Prometheus to use PostgreSQL as a long-term store for time-series metrics.
Go
75
star
10

Postgres-AI-Tutorial

Python
58
star
11

pgnodemx

A PostgreSQL extension that provides SQL functions to allow capture of node OS metrics via SQL queries.
C
47
star
12

pgstigcheck-inspec

PostgreSQL STIG Compliance Testing Solution using InSpec
Ruby
41
star
13

crunchy-postgresql-manager

PostgreSQL-as-a-Service Management Utility. Superseded by Crunchy Container Suite: https://github.com/CrunchyData/crunchy-containers
HTML
36
star
14

pgbouncer_fdw

PostgreSQL Foreign Data Wrapper to Connect to pgbouncer
PLpgSQL
32
star
15

crunchy_check_access

Functions and views to facilitate PostgreSQL object access inspection
PLpgSQL
27
star
16

bridge-cli

CLI for Crunchy Bridge
Crystal
23
star
17

postgres-operator-client

Go
14
star
18

pgo-osb

Open Service Broker Implementation Based on the Crunchy PostgreSQL Operator
Go
13
star
19

crunchy-demo-data

Demo Data that is used in Crunchy Data Demos and Workshop that can be freely redistributed
HTML
13
star
20

crunchy-katacoda

Shell
10
star
21

openshift-postgres-cartridge

OpenShift V2 PG cartridge
Shell
8
star
22

backup-scripts

High Performance PostgreSQL Tools
Shell
8
star
23

crunchy-watch

A PostgreSQL Automated Failover Container
Go
8
star
24

pgSimload

pgSimload, a versatile CLI tool to create activity on PostgreSQL server(s) and/or test HA in Crunchy Postgres or Crunchy Postgres for Kubernetes
Go
7
star
25

terraform-provider-crunchybridge

Go
6
star
26

exporter2perfdata

Go
5
star
27

pgseccomp

C
5
star
28

pg_goggles

pg_goggles provides better scaled and summarized views into PostgreSQL's cryptic internal counters.
4
star
29

openshift-postgres-rls-cartridge

Shell
3
star
30

nixpkgs

Nix
3
star
31

crunchy-bridge-operator

Go
3
star
32

crunchy-hugo-theme

Theme used for Crunchy Data generated documentation
JavaScript
3
star
33

skybridge2

Go
2
star
34

postgres-ci-cd-demo

Python
2
star
35

crunchy-bridge-for-analytics-examples

1
star
36

os-pg-testing

Shell
1
star
37

pgmonitor-extension

PLpgSQL
1
star
38

postgres-realtime-demo

Python
1
star
39

doc-content-guide

1
star
40

spatial-suite-rest-demo

Python
1
star
41

crystal-keyring

Keyring implementation for Crystal
Crystal
1
star
42

crunchy-docs

TypeScript
1
star
43

crunchy-postgresql-manager-openshift

CPM Openshift version
HTML
1
star
44

homebrew-brew

homebrew tap
Ruby
1
star
45

spatial-suite-demo-webapp

JavaScript
1
star