-
Notifications
You must be signed in to change notification settings - Fork 1
Sampling Rates
no0p edited this page Oct 15, 2014
·
1 revision
These GUCs are for controlling the sample rates of various data.
| GUC | Description | Default Value |
|---|---|---|
| pgsampler.hearbeat_seconds | Seconds between sampling a heartbeat. | 1 |
| pgsampler.system_seconds | Seconds between sampling for stat_filesystems and stat_systems. | 10 |
| pgsampler.bgwriter_seconds | Seconds between sampling for stat_bgwriter. | 30 |
| pgsampler.relation_seconds | Seconds waited between sampling for stat_table, stat_index, statio_user_table, statio_user_index, and stat_function metrics. | 150 |
| pgsampler.guc_seconds | Seconds between sampling GUC values that do not require a restart. | 120 |
| pgsampler.activity_seconds | Seconds between sampling for stat_activity. | 5 |
| pgsampler.replication_seconds | Seconds between sampling for stat_replication. | 60 |
| pgsampler.statements_seconds | Seconds between sampling for stat_statements. | 86400 |
Note that restart_gucs, stat_class, databases, columns, indexes, and stat_column are only written at database restart time.