Pgwatch2 :: DBs to monitor

Active metrics listing

archiver [ver: 9.4]
backends [ver: 9.0,9.2,9.4,9.6,10]
backup_age_pgbackrest [ver: 9.1]
backup_age_walg [ver: 9.1]
bgwriter [ver: 9.0,9.2]
blocking_locks [ver: 9.2]
buffercache_by_db [ver: 9.2]
buffercache_by_type [ver: 9.2]
change_events [ver: 9.0]
configuration_hashes [ver: 9.0]
cpu_load [ver: 9.0]
database_conflicts [ver: 9.2]
db_size [ver: 9.0]
db_stats [ver: 9.0,9.1,9.2,9.3,10,12]
db_stats_aurora [ver: 9.6,10]
get_backup_age_pgbackrest [ver: 9.1]
get_backup_age_walg [ver: 9.1]
get_load_average [ver: 9.1]
get_load_average_copy [ver: 9.0]
get_load_average_windows [ver: 9.0]
get_psutil_cpu [ver: 9.1]
get_psutil_disk [ver: 9.1]
get_psutil_disk_io_total [ver: 9.1]
get_psutil_mem [ver: 9.1]
get_smart_health_per_device [ver: 9.1]
get_stat_activity [ver: 9.0]
get_stat_replication [ver: 9.2]
get_stat_statements [ver: 9.2,9.4]
get_table_bloat_approx [ver: 9.5]
get_table_bloat_approx_sql [ver: 9.0,12]
get_vmstat [ver: 9.1]
get_wal_size [ver: 9.0,10]
index_hashes [ver: 9.0]
index_stats [ver: 9.0,9.1,10]
kpi [ver: 9.0,9.2,9.6,10]
locks [ver: 9.0]
locks_mode [ver: 9.0]
logical_subscriptions [ver: 10]
pgbouncer_stats [ver: 0]
pgpool_stats [ver: 3.0]
privilege_changes [ver: 9.0]
psutil_cpu [ver: 9.1]
psutil_disk [ver: 9.1]
psutil_disk_io_total [ver: 9.1]
psutil_mem [ver: 9.1]
reco_add_index [ver: 9.1]
reco_add_index_ext_qualstats_2.0 [ver: 9.1]
reco_default_public_schema [ver: 9.1]
reco_disabled_triggers [ver: 9.0]
reco_drop_index [ver: 9.0,9.4]
recommendations [ver: 9.0]
reco_nested_views [ver: 9.1]
reco_partial_index_candidates [ver: 9.0]
reco_sprocs_wo_search_path [ver: 9.1]
reco_superusers [ver: 9.1]
replication [ver: 9.2,10]
replication_slots [ver: 9.4,10]
server_log_event_counts [ver: 9.0]
settings [ver: 9.0]
show_plans_realtime [ver: 9.0,10]
smart_health_per_disk [ver: 9.1]
sproc_hashes [ver: 9.0]
sproc_stats [ver: 9.0]
stat_activity_realtime [ver: 9.0,9.2,9.6,10]
stat_ssl [ver: 9.5]
stat_statements [ver: 9.2,9.4,13]
stat_statements_calls [ver: 9.2,13]
stat_statements_no_query_text [ver: 9.2,9.4,13]
table_bloat_approx_stattuple [ver: 9.5]
table_bloat_approx_summary [ver: 9.5,10]
table_bloat_approx_summary_sql [ver: 9.0,12]
table_hashes [ver: 9.0,9.3]
table_io_stats [ver: 9.0,10]
table_stats [ver: 9.0,9.0,9.1,9.1,9.2,10]
vmstat [ver: 9.1]
wal [ver: 9.2,10]
wal_receiver [ver: 9.2,10]
wal_size [ver: 9.0,10]

ID	Unique name	DB type	DB host	DB port	DB dbname	DB name inclusion pattern	DB name exclusion pattern	DB user	DB password	Password encryption	Auto-create helpers?	SSL Mode	Root CA	Client cert	Client key	Group	Preset metrics config	Custom metrics config	Standby preset config	Standby custom config	Host config	Custom tags	Statement timeout [seconds]	Master mode only?	Last modified	Enabled?
1	booker																show \| copy		show \| copy						2021-06-16 17:42:14+00:00
2	defender																show \| copy		show \| copy						2021-06-16 17:43:16+00:00
3	profiler																show \| copy		show \| copy						2021-06-16 17:44:00+00:00
4	hangfire																show \| copy		show \| copy						2021-06-16 17:44:38+00:00
																	show \| copy		show \| copy

Databases under monitoring

Bulk database management

Active metrics listing

Metrics data cleanup (postgres)