Detailed Compression Statistics for Tables - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Detailed Compression Statistics for Tables

To see detailed compression statistics, including the percentage of a table that is compressed, use a SHOW STATISTICS VALUES request. An XML version is also available. For example:

show summary statistics values on cvis300;
 
 *** Text of DDL statement returned.
 *** Total elapsed time was 1 second.
 
---------------------------------------------------------------------------
COLLECT SUMMARY STATISTICS
                ON Albee.cvis300
            VALUES
(
 /** TableLevelSummary **/
 /* Version               */ 6,
 /* NumOfRecords          */ 1,
 /* Reserved              */ 0.000000,
 /* Reserved              */ 0.000000,
 /* CurrSysInsertCnt      */ -1,
 /* CurrSysDeleteCnt      */ -1,
 /* CurrSysInsDelResetTS  */ TIMESTAMP '9999-12-31 23:59:59-00:00',
 /* NumOfCurrSysUpdateCols*/ 0,
 /* SummaryRecord[1] */
 /* Temperature           */ 0,
 /* TimeStamp             */ TIMESTAMP '2014-11-05 23:00:38-00:00',
 /* NumOfAMPs             */ 4,
 /* OneAMPSampleEst       */ 2092,
 /* AllAMPSampleEst       */ 2048,
 /* RowCount              */ 2048,
 /* DelRowCount           */ 0,
 /* PhyRowCount           */ 2048,
 /* AvgRowsPerBlock       */ 0.992188,
 /* AvgBlockSize (bytes)  */ 9216.000000,
 /* BLCPctCompressed      */ 100.00,
 /* BLCBlkUcpuCost (ms)   */ 0.400000,
 /* BLCCompRatio          */ 86.000000,
 /* AvgRowSize            */ 120.000000,
 /* Reserved              */ 0.000000,
 /* Reserved              */ 0.000000,
 /* Reserved              */ 0.000000,
 /* StatsSkipCount        */ 0,
 /* SysInsertCnt          */ 0,
 /* SysDeleteCnt          */ 0,
 /* SysUpdateCnt          */ 0,
 /* SysInsDelLastResetTS  */ TIMESTAMP '9999-12-31 23:59:59-00:00'
);