EXPLAIN_OBJECT
FieldTypeDescription
EXPLAIN_REQUESTERstringExplain Requester
EXPLAIN_TIMEdatetimeExplain Time
SOURCE_NAMEstringSource Name
SOURCE_SCHEMAstringSource Schema
SOURCE_VERSIONstringSource Version
EXPLAIN_LEVELstringExplain Level
STMTNOintegerStmtno
SECTNOintegerSectno
OBJECT_SCHEMAstringObject Schema
OBJECT_NAMEstringObject Name
OBJECT_TYPEstringObject Type
CREATE_TIMEdatetimeCreate Time
STATISTICS_TIMEdatetimeStatistics Time
COLUMN_COUNTintegerColumn Count
ROW_COUNTbigintRow Count
WIDTHintegerWidth
PAGESbigintPages
DISTINCTstringDistinct
TABLESPACE_NAMEstringTablespace Name
OVERHEADdoubleOverhead
TRANSFER_RATEdoubleTransfer Rate
PREFETCHSIZEintegerPrefetchsize
EXTENTSIZEintegerExtentsize
CLUSTERdoubleCluster
NLEAFbigintNleaf
NLEVELSintegerNlevels
FULLKEYCARDbigintFullkeycard
OVERFLOWbigintOverflow
FIRSTKEYCARDbigintFirstkeycard
FIRST2KEYCARDbigintFirst2Keycard
FIRST3KEYCARDbigintFirst3Keycard
FIRST4KEYCARDbigintFirst4Keycard
SEQUENTIAL_PAGESbigintSequential Pages
DENSITYintegerDensity
STATS_SRCstringStats Src
AVERAGE_SEQUENCE_GAPdoubleAverage Sequence Gap
AVERAGE_SEQUENCE_FETCH_GAPdoubleAverage Sequence Fetch Gap
AVERAGE_SEQUENCE_PAGESdoubleAverage Sequence Pages
AVERAGE_SEQUENCE_FETCH_PAGESdoubleAverage Sequence Fetch Pages
AVERAGE_RANDOM_PAGESdoubleAverage Random Pages
AVERAGE_RANDOM_FETCH_PAGESdoubleAverage Random Fetch Pages
NUMRIDSbigintNumrids
NUMRIDS_DELETEDbigintNumrids Deleted
NUM_EMPTY_LEAFSbigintNum Empty Leafs
ACTIVE_BLOCKSbigintActive Blocks
NUM_DATA_PARTSintegerNum Data Parts
NULLKEYSstringNullkeys