JohnArchieMckown / PostgreSQL-DBA-tools

This repository contains a number of UNIX scripts, and PostgreSQL queries. The author, Melvin Davidson, originally distributed them on the pgsql-general mailing list and has allowed me to create this repository for them. These scripts and queries are donated "as is" and are not guaranteed in any way.

☆47

Related projects ⓘ

Alternatives and complementary repositories for PostgreSQL-DBA-tools

pgsentinel / pgsentinel
postgresql extension providing Active session history
☆169Updated 3 months ago
pgexperts / flexible-freeze
Flexible freeze scripts for managing off-hours vacuuming and freezing of PostgreSQL databases.
☆92Updated 4 months ago
dbacvetkov / PASH-Viewer
PostgreSQL ASH Viewer (PASH Viewer) provides graphical view of active session history data within the PostgreSQL database
☆121Updated 2 years ago
omniti-labs / pgtreats
Tasty treats for PostgreSQL
☆111Updated 5 years ago
EnterpriseDB / pg_catcheck
Postgres Catalog Checker
☆81Updated last week
keithf4 / pg_bloat_check
Bloat check script for PostgreSQL
☆141Updated 9 months ago
awslabs / pg-collector
PG Collector for Postgresql is a sql script that gathers valuable database information and presents it in a consolidated HTML file which …
☆86Updated 2 months ago
gregs1104 / pgbench-tools
PostgreSQL Benchmarking Toolset
☆254Updated last week
cybertec-postgresql / ora_migrator
Tools for Oracle to PostgreSQL migration
☆109Updated 5 months ago
cybertec-postgresql / postgres-showcase
Postgres features showcase (commented SQL samples) for beginners
☆167Updated 4 years ago
CyberDem0n / bg_mon
Background worker for monitoring PostgreSQL
☆68Updated 4 months ago
Azmodey / pg_dba_scripts
PostgreSQL DBA scripts
☆62Updated 3 years ago
dalibo / pitrery
DEPRECATED. PostgreSQL Point In Time Recovery made easy
☆108Updated 2 years ago
markwkm / pg_top
Mirror of https://gitlab.com/pg_top/pg_top
☆112Updated 5 months ago
cybertec-postgresql / pg_permissions
A simple set of views to see ALL permissions in a PostgreSQL database
☆150Updated 5 months ago
darold / pgcluu
PostgreSQL Cluster performances monitoring and auditing tool
☆336Updated 2 weeks ago
postgrespro / pg_wait_sampling
Sampling based statistics of wait events
☆149Updated 3 months ago
postgrespro / pg_query_state
Tool for query progress monitoring in PostgreSQL
☆150Updated last week
gleu / pgstats
Collects PostgreSQL statistics, and either saves them in CSV files or print them on the stdout
☆117Updated last month
grayhemp / pgtoolkit
Tools for PostgreSQL maintenance
☆183Updated 8 years ago
OPMDG / check_pgactivity
Nagios remote agent
☆175Updated 2 months ago
postgres-ai / postgres-checkup
Postgres Health Check and SQL Performance Analysis. THIS IS A MIRROR OF https://gitlab.com/postgres-ai/postgres-checkup
☆169Updated 3 years ago
munakoiso / logerrors
☆32Updated 3 months ago
grayhemp / pgcookbook
PostgreSQL documentation project
☆234Updated 6 years ago
vitabaks / pgbackrest_auto
pgbackrest_auto: Automatic Restore and Validate for physical and logical database corruption (PostgreSQL)
☆66Updated 11 months ago
dalibo / ldap2pg
Manage PostgreSQL roles and privileges from YAML or LDAP
☆211Updated last month
tvondra / pg_check
a tool to verify integrity of PostgreSQL data files
☆48Updated 6 years ago
dataegret / pg_index_watch
Utility for automatical rebuild bloated indexes (a-la smart autovacuum to deal with index bloat) in PostgreSQL.
☆59Updated 4 months ago
pgaudit / pgaudit_analyze
PostgreSQL Audit Analyzer
☆42Updated 3 weeks ago
omniti-labs / pg_extractor
PG Extractor - Advanced PostgreSQL Dump Filter
☆162Updated 2 years ago