Checking for Failed Segments

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

Checking for Failed Segments

The gp_pgdatabase_invalid view can be used to check for down segments.


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)