;------------------------------------- ; pg_stats_reporter configuration file ;------------------------------------- [repository1] ;------------------------------------- ; database connection ;------------------------------------- host = localhost port = 5432 dbname = postgres username = postgres password = ;------------------------------------- ; report setting ;------------------------------------- ; --- Language Setting --- language = auto ; --- Summary --- summary = true ; --- Database System --- ; -- Database Statistics -- database_statistics = true transaction_statistics = true database_size = true recovery_conflicts = true ; -- Instance Activity -- wal_statistics = true instance_processes_ratio = true instance_processes = true ; --- Operating System --- ; -- OS Resource Usage -- cpu_usage = true load_average = true io_usage = true memory_usage = true ; -- Disk Usage -- disk_usage_per_tablespace = true disk_usage_per_table = true ; --- SQL --- ; -- Notable Tables -- heavily_updated_tables = true heavily_accessed_tables = true low_density_tables = true fragmented_tables = true ; -- Query Activity -- functions = true statements = true ; -- Long Transactions -- long_transactions = true ; -- Lock Conflicts -- lock_conflicts = true ; --- Operation Activity --- ; -- Checkpoint Activity -- checkpoint_activity = true ; -- Autovacuum Activity -- basic_statistics = true io_statistics = true ; -- Replication Activity -- replication_activity = true ; --- Information --- ; -- Schema Information -- table = true index = true ; -- Setting Parameters -- parameter = true ; -- Profiles -- profiles = true [repository2] ;------------------------------------- ; database connection ;------------------------------------- host = localhost port = 5432 dbname = postgres username = postgres password = ;------------------------------------- ; report setting ;------------------------------------- ; --- Language Setting --- language = auto ; --- Summary --- summary = true ; --- Database System --- ; -- Database Statistics -- database_statistics = true transaction_statistics = true database_size = true recovery_conflicts = true ; -- Instance Activity -- wal_statistics = true instance_processes_ratio = true instance_processes = true ; --- Operating System --- ; -- OS Resource Usage -- cpu_usage = true load_average = true io_usage = true memory_usage = true ; -- Disk Usage -- disk_usage_per_tablespace = true disk_usage_per_table = true ; --- SQL --- ; -- Notable Tables -- heavily_updated_tables = true heavily_accessed_tables = true low_density_tables = true fragmented_tables = true ; -- Query Activity -- functions = true statements = true ; -- Long Transactions -- long_transactions = true ; -- Lock Conflicts -- lock_conflicts = true ; --- Operation Activity --- ; -- Checkpoint Activity -- checkpoint_activity = true ; -- Autovacuum Activity -- basic_statistics = true io_statistics = true ; -- Replication Activity -- replication_activity = true ; --- Information --- ; -- Schema Information -- table = true index = true ; -- Setting Parameters -- parameter = true ; -- Profiles -- profiles = false