You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

48 lines
1.4 KiB

6 years ago
apt install pg-activity pgtop
sudo su - postgres
pg_activity
6 years ago
pg_top
# Consider:
#
# Analysis, on pg server:
# pg-activity
# pgtop
#
# Analysis, separate server. See powa/ dir.
6 years ago
# PoWa:
# postgresql-10-powa -- Workload analyzer
# postgresql-10-pg-qualstats
# postgresql-10-pg-stat-kcache
6 years ago
# postgresql-10-hypopg - PostgreSQL extension adding support for hypothetical indexes.
#
6 years ago
# pgbadger - Fast PostgreSQL log analysis report
# pgcluu - PostgreSQL performance monitoring and auditing tool
#
# postgresql-10-pgaudit
#
6 years ago
# Administration, separate server:
# pgadmin -- web admin
# tora (workstation) -- graphical toolkit for database developers and administrators. Ancient version in Debian, no postgres.
# pgmodeler - PostgreSQL database modeler GUI interface
# Report generation:
# openrpt - graphical SQL report writer, designer and rendering engine
# Backups:
# autopostgresqlbackup - Automated tool to make periodic backups of PostgreSQL databases
# backupninja - lightweight, extensible meta-backup system
# barman - Backup and Recovery Manager for PostgreSQL
# pgbackrest - Reliable PostgreSQL Backup & Restore
# pg-backup-ctl - backup and recover PostgreSQL using log archiving
# Misc
# pspg - PostgreSQL pager
# pgcli -- command line
##############################################################################
6 years ago
# XXX
log_timezone = 'Navajo'
##############################################################################