Top Hot Tables
top_hot_tablesIdentify the most frequently accessed tables in StarRocks by querying audit-log visit counts, with optional filters for database, table name, and time range.
Instructions
Get top hot tables by audit-log visit count
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db | No | Optional database/schema filter. Matches information_schema.tables.table_schema exactly. | |
| table | No | Optional table name substring filter. Matches information_schema.tables.table_name with LIKE. | |
| top_n | No | Number of hot tables to return. Defaults to 20 and is capped at 100. | |
| max_start_time_ms | No | Optional maximum audit-log timestamp as Unix epoch milliseconds. Applied only when min_start_time_ms is also set. | |
| min_start_time_ms | No | Optional minimum audit-log timestamp as Unix epoch milliseconds. Applied only when max_start_time_ms is also set. |