Checking for Failed Segments

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.

Table 1. gp_pgdatabase_invalid view
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)