;------------------------------------- ; pg_stats_reporter configuration file ;------------------------------------- ;------------------------------------- ; global setting section ;------------------------------------- [global_setting] install_directory = /var/www log_page_size = 1000 ;------------------------------------- ; repository DB setting section ;------------------------------------- [sample] ;------------------------------------- ; database connection ;------------------------------------- host = localhost port = 5432 dbname = postgres username = postgres ;password = ;------------------------------------- ; report setting ;------------------------------------- ; --- Language Setting --- language = auto ; --- Report Overview --- overview = true ; Report Overview ; -- Alerts -- alerts = true ; Alerts ; --- Statistics --- ; -- Databases Statistics -- databases_statistics = true ; Databases Statistics transactions = true ; Transactions database_size = true ; Database Size recovery_conflicts = true ; Recovery Conflicts ; -- Instance Statistics -- write_ahead_logs = true ; Write Ahead Logs backend_states_overview = true ; Backend States Overview backend_states = true ; Backend States ; --- OS Resources --- ; -- CPU and Memory -- cpu_usage = true ; CPU Usage load_average = true ; Load Average memory_usage = true ; Memory Usage ; -- Disks -- disk_usage_per_tablespace = true ; Disk Usage per Tablespace disk_usage_per_table = true ; Disk Usage per Table io_usage = true ; I/O Usage ; --- Activities --- ; -- Notable Tables -- heavily_updated_tables = true ; Heavily Updated Tables heavily_accessed_tables = true ; Heavily Accessed Tables low_density_tables = true ; Low Density Tables table_fragmentations = true ; Table Fragmentations ; -- Query Activity -- functions = true ; Functions statements = true ; Statements plans = true ; Plans ; -- Long Transactions -- long_transactions = true ; Long Transactions ; -- Lock Conflicts -- lock_conflicts = true ; Lock Conflicts ; --- Maintenance --- ; -- Checkpoints -- checkpoints = true ; Checkpoints ; -- Autovacuums -- autovacuum_overview = true ; Overview autovacuum_io_summary = true ; I/O Summary analyze_overview = true ; Analyze Overview modified_rows = true ; Modified Rows cancellations = true ; Cancellations ; -- Replication -- replication_overview = true ; Overview replication_delays = true ; Delays ; --- Miscellaneous --- ; -- Tables and Indexes -- tables = true ; Tables indexes = true ; Indexes ; -- Settings -- runtime_params = true ; Run-time parameters ; -- Profiles -- profiles = false ; Profiles