Returns statistical information about the TEXT indexes in the database.
Use sa_text_index_stats to view statistical information for each TEXT index in the database.
Column name |
Type |
Description |
---|---|---|
owner_id |
UNSIGNED INT |
ID of the owner of the table |
table_id |
UNSIGNED INT |
ID of the table |
index_id |
UNSIGNED INT |
ID of the TEXT index |
text_config_id |
UNSIGNED BIGINT |
ID of the text configuration referenced by the TEXT index |
owner_name |
CHAR(128) |
Name of the owner |
table_name |
CHAR(128) |
Name of the table |
index_name |
CHAR(128) |
Name of the TEXT index |
text_config_name |
CHAR(128) |
Name of the text configuration object |
doc_count |
UNSIGNED BIGINT |
Total number of indexed column values in the TEXT index |
doc_length |
UNSIGNED BIGINT |
Total length of data in the TEXT index |
pending_length |
UNSIGNED BIGINT |
Total length of the pending changes |
deleted_length |
UNSIGNED BIGINT |
Total length of the pending deletions |
last_refresh |
TIMESTAMP |
Date and time of the last refresh |
The pending_length, deleted_length, and last_refresh values are NULL for IMMEDIATE REFRESH TEXT indexes.