[GitHub] [incubator-doris] EmmyMiao87 commented on issue #6370: Collect richer statistical information

[GitBox <gi...@apache.org>]

EmmyMiao87 commented on issue #6370:
URL: https://github.com/apache/incubator-doris/issues/6370#issuecomment-891860595


   # Show statistics
   
   + 展示表统计信息
   
     如果填写 table_name 则展示单表信息，如果不填则展示整个库的所有表的信息。	
   
     ```sql
     show table stats {db_name.table_name };
     ```
   
   	| table_name | row_count | data_size |
   	| :--------- | --------- | --------- |
   	| store      | 100000    | 1MB       |
   
   + 展示列统计信息
   
     ```sql
     show column stats table_name;
     ```
   
     | column_name | num_distinct_value | min  | max  | num_nulls | avg_col_len | max_col_len |
     | ----------- | ------------------ | ---- | ---- | --------- | ----------- | --- |
     | s_store_sk  | 10                 | 1    | 100  | 0         | 4           |4|
     | s_store_id  | -1                 | -1   | -1   | -1        | 4           |4|
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org