The table pgx_stat_freeze_results logs statistics about aggressive freeze for tuples. If an aggressive freeze for tuples is performed, that information will be added as an accumulation. The cumulative information is summarized for the time period specified by the pgx_stat_vacuum_freeze.monitoring_interval parameter, and the information for the time period specified by the pgx_stat_vacuum_freeze.log_retention_period parameter is kept. For the information about the pgx_stat_vacuum_freeze.monitoring_interval and pgx_stat_vacuum_freeze.log_retention_period parameters, refer to "Parameters for scheduling aggressive freeze for tuples".
You can gather information to determine how long the aggressive freeze for tuples process is taking, and help estimate the aggressive freeze for tuples schedule.
Column | Type | Description |
|---|---|---|
measurement_start_time | timestamp with time zone | Start time of the measurement |
measurement_end_time | timestamp with time zone | End time of the measurement |
vacuum_count | bigint | Number of times the freeze operation was performed |
autovacuum | boolean | true for autovacuum driven vacuum |
scan_pages | bigint | Accumulation of pages scanned during freezing |
frozen_pages | bigint | Accumulation of frozen pages |
frozen_tuples | bigint | Accumulation of frozen tuples |
total_frozen_wal_records | bigint | Accumulation of the number of WAL records produced by freezing |
frozen_full_page_image_wal_records | bigint | Accumulation of the number of WAL full-page images produced by freezing |
wal_total_bytes | numeric | Accumulation, in bytes, of WAL generated by freezing |
total_elapsed_time | double precision | Accumulation of freezing time. Units are milliseconds |
sleep_times | double precision | Accumulation of time spent sleeping during freezing. Units are milliseconds |
