SUMMARY_STAT_USER_INDEXES

SUMMARY_STAT_USER_INDEXES displays the status information about the index of user-defined ordinary tables in all databases in MogDB.

Table 1 SUMMARY_STAT_USER_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