Checking for Failed Segments
The gp_pgdatabase_invalid view can be used to check for down segments.
gp_pgdatabase_invalid
This view shows information about segments that are marked as down in the system catalog. This view is accessible to all users.
| Column | Description |
|---|---|
| pgdbidbid | The segment dbid. Every segment has a unique dbid. |
| pgdbiisprimary | Is the segment currently acting as the primary (active) segment? (t or f) |
| pgdbicontent | The content id of this segment. A primary and mirror will have the same content id. |
| pgdbivalid | Is this segment up and valid? (t or f) |
| pgdbidefinedprimary | Was this segment assigned the role of primary at system initialization time? (t or f) |