gp_configuration_history
The gp_configuration_history table contains information about system changes related to fault detection and recovery operations.
The fts_probe process logs data to this table, as do certain related management utilities such as gprecoverseg and gpinitsystem.
For example, when you add a new segment and mirror segment to the system, records for these events are logged to gp_configuration_history.
This table is populated only on the master.
This table is defined in the pg_global tablespace, meaning it is globally shared across all databases in the system.
| Column | Type | References | Description |
|---|---|---|---|
time |
timestamp with time zone |
— |
Timestamp for the event recorded |
dbid |
smallint |
gp_segment_configuration.dbid |
System-assigned ID. The unique identifier of a segment (or master) instance |
desc |
text |
— |
Text description of the event |