SUMMARY_STAT_SYS_INDEXES

SUMMARY_STAT_SYS_INDEXES displays index status information about all the system catalogs in the pg_catalog, information_schema, and pg_toast schemas in openGauss.

Table 1 SUMMARY_STAT_SYS_INDEXES columns

Name	Type	Description
schemaname	name	Name of the schema that the index is in
relname	name	Name of the table for the index
indexrelname	name	Index name
idx_scan	numeric	Number of index scans initiated on the index
idx_tup_read	numeric	Number of index entries returned by scans on the index
idx_tup_fetch	numeric	Number of live table rows fetched by simple index scans using the index