• Stars
    star
    568
  • Rank 78,502 (Top 2 %)
  • Language PLpgSQL
  • License
    Other
  • Created about 7 years ago
  • Updated 2 months 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,916
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
414
star
6

pg_parquet

Copy to/from Parquet in S3 from within PostgreSQL
Rust
248
star
7

pg_eventserv

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

postgres-operator-examples

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

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
10

postgresql-prometheus-adapter

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

Postgres-AI-Tutorial

Python
58
star
12

pgnodemx

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

pgstigcheck-inspec

PostgreSQL STIG Compliance Testing Solution using InSpec
Ruby
41
star
14

crunchy-postgresql-manager

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

pgbouncer_fdw

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

crunchy_check_access

Functions and views to facilitate PostgreSQL object access inspection
PLpgSQL
28
star
17

bridge-cli

CLI for Crunchy Bridge
Crystal
23
star
18

postgres-operator-client

Go
14
star
19

pgo-osb

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

crunchy-demo-data

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

crunchy-katacoda

Shell
10
star
22

openshift-postgres-cartridge

OpenShift V2 PG cartridge
Shell
8
star
23

backup-scripts

High Performance PostgreSQL Tools
Shell
8
star
24

crunchy-watch

A PostgreSQL Automated Failover Container
Go
8
star
25

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
26

terraform-provider-crunchybridge

Go
6
star
27

exporter2perfdata

Go
5
star
28

pgseccomp

C
5
star
29

crunchy-bridge-for-analytics-examples

Crunchy Bridge for Analytics Examples repository
PLpgSQL
4
star
30

pg_goggles

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

openshift-postgres-rls-cartridge

Shell
3
star
32

nixpkgs

Nix
3
star
33

crunchy-bridge-operator

Go
3
star
34

crunchy-hugo-theme

Theme used for Crunchy Data generated documentation
JavaScript
3
star
35

skybridge2

Go
2
star
36

postgres-ci-cd-demo

Python
2
star
37

os-pg-testing

Shell
1
star
38

postgres-realtime-demo

Python
1
star
39

pgmonitor-extension

PLpgSQL
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

doc-content-guide

1
star
44

crunchy-postgresql-manager-openshift

CPM Openshift version
HTML
1
star
45

homebrew-brew

homebrew tap
Ruby
1
star
46

spatial-suite-demo-webapp

JavaScript
1
star