Release Notes
Product Introduction
- Overview
- Scenarios
- Product Architecture
- Instance Types
- Compatibility Notes
- Usage specification recommendations
Kernel Features
- Kernel Overview
- Kernel Version Release Notes
- Functionality Features
- Performance Features
Billing
Getting Started
- Creating an Instance
- Connect to Instances
User Guide
- Data Migration
- Data Subscription
- Instance Management
- Parameter Configuration
- Account Management
- Security Group
- Backup and Restoration
- Database Auditing
- Tag Management
Use Cases
Developer Guide
- Developer Guide (MySQL Compatibility Mode)
- Developer Guide (HBase Compatibility Mode)
Performance Tuning
- Performance Tuning Overview
- SQL Tuning
- DDL Tuning
Performance White Paper
API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Instance APIs
- Security Group APIs
- Task APIs
- Backup APIs
- Rollback APIs
- Parameter APIs
- Database APIs
- Data Types
- Error Codes
General Reference
- System Architecture
- SQL Reference
- Database Parameter Description
- TPC-H benchmark data model reference
- Error Code Information
Security and Compliance
FAQs
Agreements
Contact Us
Glossary

TDSTORE_SST_PROPS

Focus Mode

Font Size

Last updated: 2026-02-10 11:06:32

Function
INFORMATION_SCHEMA.TDSTORE_SST_PROPS is used to display the properties of SSTables in TDStore.
Field Description
Field Name
Type
Description
DB_TYPE
VARCHAR(193)
The SSTable belongs to the RocksDB type, supporting data_db, multi_raft_db, and monitor_info_db.
SST_NAME
VARCHAR(193)
The name of the SSTable.
COLUMN_FAMILY
INT
The corresponding ColumnFamily ID for the SSTable.
LEVEL
INT
The level of the SSTable.
MAX_KEY
VARCHAR(193)
The largest Key in the SSTable.
MIN_KEY
VARCHAR(193)
The smallest Key in the SSTable.
NUM_DATA_BLOCKS
BIGINT
The number of data blocks in the SSTable.
NUM_ENTRIES
BIGINT
The number of Entries in the SSTable.
NUM_DELETIONS
BIGINT
The number of deletions in the SSTable.
RAW_KEY_SIZE
BIGINT
The total size of keys in the SSTable before compression, in bytes.
RAW_VALUE_SIZE
BIGINT
The total size of Values in the SSTable before compression, in bytes.
DATA_BLOCK_SIZE
BIGINT
The total size of data blocks in the SSTable, in bytes.
INDEX_BLOCK_SIZE
BIGINT
The total size of index blocks in the SSTable, in bytes.
INDEX_PARTITIONS
INT
The number of index partitions in the SSTable.
TOP_LEVEL_INDEX_SIZE
BIGINT
The size of the top-level index in the SSTable, in bytes.
FILTER_BLOCK_SIZE
BIGINT
The total size of filter blocks in the SSTable, in bytes.
COMPRESSION_ALGO
VARCHAR(193)
The compression algorithm used by the SSTable.
CREATION_TIME
BIGINT
The creation time of the SSTable.
OLDEST_KEY_TIME
BIGINT
The creation time of the oldest Key in the SSTable.
FILTER_POLICY
VARCHAR(193)
The name of the Filter used by the SSTable.
NODE_NAME
VARCHAR(513)
Name of the SQLEngine node hosting the SSTable.
Examples
tdsql > select * from tdstore_sst_props\\G
*************************** 1. row ***************************
             DB_TYPE: data_db
            SST_NAME: 000019.sst
       COLUMN_FAMILY: 1
               LEVEL: 0
             MAX_KEY: 0000011E00000001
             MIN_KEY: 0000000100000001
     NUM_DATA_BLOCKS: 145
         NUM_ENTRIES: 54974
       NUM_DELETIONS: 794
        RAW_KEY_SIZE: 2256766
      RAW_VALUE_SIZE: 8356920
     DATA_BLOCK_SIZE: 9729222
    INDEX_BLOCK_SIZE: 5047
    INDEX_PARTITIONS: 0
TOP_LEVEL_INDEX_SIZE: 0
   FILTER_BLOCK_SIZE: 0
    COMPRESSION_ALGO: NULL
       CREATION_TIME: 1724913962
     OLDEST_KEY_TIME: 1724913362
       FILTER_POLICY: NULL
           NODE_NAME: node-1-001
*************************** 2. row ***************************
             DB_TYPE: data_db
            SST_NAME: 000020.sst
       COLUMN_FAMILY: 2
               LEVEL: 0
             MAX_KEY: 000027121E711E951C471E95091CAA1DAA1CAA1DB9091E95020B1E951E33091EB51DB91C7A1C47091E951CAA020B1D77091CAA1DB90000000004
             MIN_KEY: 000027121C8F1D321C471CF4091DB91DDD1E711E95091D321C7A1E710277091C471D771D771DDD091EF5020B1D32020B091E71020B1E951C47091C601D771CAA1E7108
     NUM_DATA_BLOCKS: 1
         NUM_ENTRIES: 6
       NUM_DELETIONS: 0
        RAW_KEY_SIZE: 477
      RAW_VALUE_SIZE: 278
     DATA_BLOCK_SIZE: 646
    INDEX_BLOCK_SIZE: 28
    INDEX_PARTITIONS: 0
TOP_LEVEL_INDEX_SIZE: 0
   FILTER_BLOCK_SIZE: 69
    COMPRESSION_ALGO: NULL
       CREATION_TIME: 1724913962
     OLDEST_KEY_TIME: 1724913362
       FILTER_POLICY: NULL
           NODE_NAME: node-1-001
*************************** 3. row ***************************
             DB_TYPE: data_db
            SST_NAME: 000011.sst
       COLUMN_FAMILY: 3
               LEVEL: 0
             MAX_KEY: 0000000000000003000000011D
             MIN_KEY: 00000000000000010100002711
     NUM_DATA_BLOCKS: 1
         NUM_ENTRIES: 165
       NUM_DELETIONS: 0
        RAW_KEY_SIZE: 3465
      RAW_VALUE_SIZE: 2310
     DATA_BLOCK_SIZE: 4481
    INDEX_BLOCK_SIZE: 28
    INDEX_PARTITIONS: 0
TOP_LEVEL_INDEX_SIZE: 0
   FILTER_BLOCK_SIZE: 0
    COMPRESSION_ALGO: NULL
       CREATION_TIME: 1724913353
     OLDEST_KEY_TIME: 3
       FILTER_POLICY: NULL
           NODE_NAME: node-1-001
3 rows in set (0.00 sec)

Help and Support

Was this page helpful?

You can also Contact sales or Submit a Ticket for help.

Help us improve! Rate your documentation experience in 5 mins.

Feedback

tencent cloud

TDSQL Boundless

TDSTORE_SST_PROPS

Function

Field Description

Examples

Help and Support

Field Name	Type	Description
DB_TYPE	VARCHAR(193)	The SSTable belongs to the RocksDB type, supporting `data_db`, `multi_raft_db`, and `monitor_info_db`.
SST_NAME	VARCHAR(193)	The name of the SSTable.
COLUMN_FAMILY	INT	The corresponding ColumnFamily ID for the SSTable.
LEVEL	INT	The level of the SSTable.
MAX_KEY	VARCHAR(193)	The largest Key in the SSTable.
MIN_KEY	VARCHAR(193)	The smallest Key in the SSTable.
NUM_DATA_BLOCKS	BIGINT	The number of data blocks in the SSTable.
NUM_ENTRIES	BIGINT	The number of Entries in the SSTable.
NUM_DELETIONS	BIGINT	The number of deletions in the SSTable.
RAW_KEY_SIZE	BIGINT	The total size of keys in the SSTable before compression, in bytes.
RAW_VALUE_SIZE	BIGINT	The total size of Values in the SSTable before compression, in bytes.
DATA_BLOCK_SIZE	BIGINT	The total size of data blocks in the SSTable, in bytes.
INDEX_BLOCK_SIZE	BIGINT	The total size of index blocks in the SSTable, in bytes.
INDEX_PARTITIONS	INT	The number of index partitions in the SSTable.
TOP_LEVEL_INDEX_SIZE	BIGINT	The size of the top-level index in the SSTable, in bytes.
FILTER_BLOCK_SIZE	BIGINT	The total size of filter blocks in the SSTable, in bytes.
COMPRESSION_ALGO	VARCHAR(193)	The compression algorithm used by the SSTable.
CREATION_TIME	BIGINT	The creation time of the SSTable.
OLDEST_KEY_TIME	BIGINT	The creation time of the oldest Key in the SSTable.
FILTER_POLICY	VARCHAR(193)	The name of the Filter used by the SSTable.
NODE_NAME	VARCHAR(513)	Name of the SQLEngine node hosting the SSTable.