HomeMogDBMogDB StackUqbar
v2.0

Documentation:v2.0

Supported Versions:

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
Copyright © 2011-2024 www.enmotech.com All rights reserved.