HomeMogDBMogDB StackUqbar
v2.0

Documentation:v2.0

Supported Versions:

GLOBAL_STATIO_ALL_INDEXES

GLOBAL_STATIO_ALL_INDEXES contains one row for each index in databases on each node, showing I/O statistics about specific indexes.

Table 1 GLOBAL_STATIO_ALL_INDEXES columns

Name Type Description
node_name name Node name
relid oid OID of the table that the index is created for
indexrelid oid OID of the index
schemaname name Name of the schema that the index is in
relname name Name of the table that the index is created for
indexrelname name Index name
idx_blks_read numeric Number of disk blocks read from the index
idx_blks_hit numeric Number of cache hits in the index
Copyright © 2011-2024 www.enmotech.com All rights reserved.