GBase 8c 创建统计信息示例

最新推荐文章于 2024-09-15 08:03:51 发布

大壮十二

最新推荐文章于 2024-09-15 08:03:51 发布

阅读量153

点赞数 1

文章标签：数据库 database

本文链接：https://blog.csdn.net/qq_41614765/article/details/124434684

版权

CREATE TABLE tbl (                                                                        

    col1 int,                                                                             

    col2 int                                                                              

);                                                                                        



INSERT INTO tbl SELECT i/10000, i/100000                                                  

FROM generate_series (1,10000000) s(i);                                                   



ANALYZE tbl;                                     



select * from pg_stats where tablename = 'tbl' and attname = 'col1';

-[ RECORD 1 ]----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

schemaname             | public

tablename              | tbl

attname                | col1

inherited              | f

null_frac              | 0

avg_width              | 4

n_distinct             | 1000

most_common_vals       | {318,564,596,...}

most_common_freqs      | {0.00173333,0.0017,0.00166667,0.00156667,...}

histogram_bounds       | {0,8,20,30,39,...}

correlation            | 1

most_common_elems      |

most_common_elem_freqs |

elem_count_histogram   |