View table statistics

Limitations

• This feature is available only for Hologres V1.3 and later versions.

  Note

  If your instance is earlier than V1.3, see Troubleshoot common upgrade preparation failures or join the Hologres DingTalk group for help. For more information, see How do I get more online support?.

• By default, table statistics are retained for 30 days.

• You must have the required permissions to view table statistics. Otherwise, you can view only the information that is related to your own account. For more information, see View and analyze table statistics.

View table statistics

1. Go to the HoloWeb development page. For more information, see Connect to HoloWeb.

2. In the top navigation bar of the HoloWeb page, click Diagnostics and Optimization.

3. On the Diagnostics and Optimization page, choose Metadata Warehouse Analysis > Table Statistics.

4. Configure filter conditions.

   On the Table Statistics page, you can configure the following parameters.

   Parameter	Required	Description
   Instance	Yes	The instance to view statistics for. The current instance is selected by default.
   Database	Yes	The database to view statistics for. The current database is selected by default.
   Schema	No	The schema to view statistics for.
   Type	No	The type of table to view statistics for.
   Table	No	The name of the table to view statistics for.
   Table Owner	No	The owner of the table. Use this parameter to filter results by owner.
   List Limit	Yes	The maximum number of rows to return, up to 2,000.
   Collection Time	Yes	The collection time range for the statistics. By default, the most recent day is selected.

5. Click Search to view the list of tables that meet the filter conditions.

   • View the default columns.

     By default, a list of columns is displayed. For a description of each column, see hg_table_info view.

     The default list includes columns such as Table Name, Database, Type, Schema, Is Partition, Parent Table, and Owner.

   • View other columns.

     If you need other columns, click Customize Columns in the upper-right corner of the Tables. In the dialog box that appears, select more columns and then click OK.

     Other columns include Total Read Count, Total Write Count, Collect Time, Partition Spec, Last Ddl Time, Last Access Time, Comment, Cold File Count, Table Id, Create Time, Last Modify Time, View Def, Cold Storage Size, and Table Meta.

   • Download the list.

     To analyze the data further, click Download in the upper-right corner of the Tables to save the data as a local file.