设为首页 加入收藏

TOP

统计对象大小函数性能比较(二)
2015-07-24 11:12:20 来源: 作者: 【 】 浏览:8
Tags:统计 对象 大小 函数 性能 比较
e20141224 | gt | 2162688 gt | rt_ok_1_prt_event_time20141225 | gt | 2162688 gt | rt_ok_1_prt_event_time20141226 | gt | 2162688 gt | rt_ok_1_prt_event_time20141227 | gt | 2162688 gt | rt_ok_1_prt_event_time20141228 | gt | 2162688 gt | rt_ok_1_prt_event_time20141229 | gt | 2162688 gt | rt_ok_1_prt_event_time20141230 | gt | 2162688 gt | rt_ok_1_prt_event_time20141231 | gt | 2162688 (18 rows) Time: 414.039 ms gtgpdb=# select a.schemaname ,a.tablename ,a.tableowner,pg_total_relation_size(a.schemaname||'.'||a.tablename) size from pg_tables a where a.tablename like 'manager_table'; schemaname | tablename | tableowner | size ------------+---------------+------------+--------- gpmg | manager_table | gpadmin | 1736704 (1 row) Time: 330.197 ms gtgpdb=# select * from gp_toolkit.gp_size_of_table_disk t where sotdtablename like 'manager_table'; sotdoid | sotdsize | sotdtoastsize | sotdadditionalsize | sotdschemaname | sotdtablename ---------+----------+---------------+--------------------+----------------+--------------- 1441033 | 327680 | 0 | 0 | gpmg | manager_table (1 row) Time: 26882.409 ms gtgpdb=# select * from gp_toolkit.gp_size_of_table_disk t where sotdtablename like 'manager_table'; sotdoid | sotdsize | sotdtoastsize | sotdadditionalsize | sotdschemaname | sotdtablename ---------+----------+---------------+--------------------+----------------+--------------- 1441033 | 327680 | 0 | 0 | gpmg | manager_table (1 row) Time: 25308.524 ms gtgpdb=# vacuum analyze gpmg.manager_table; VACUUM Time: 2734.580 ms gtgpdb=# select * from gp_toolkit.gp_size_of_table_disk t where sotdtablename like 'manager_table'; sotdoid | sotdsize | sotdtoastsize | sotdadditionalsize | sotdschemaname | sotdtablename ---------+----------+---------------+--------------------+----------------+--------------- 1441033 | 327680 | 0 | 0 | gpmg | manager_table (1 row) Time: 25073.932 ms gtgpdb=# select * from gp_toolkit.gp_size_of_table_disk t where sotdtablename like 'manager_table'; sotdoid | sotdsize | sotdtoastsize | sotdadditionalsize | sotdschemaname | sotdtablename ---------+----------+---------------+--------------------+----------------+--------------- 1441033 | 327680 | 0 | 0 | gpmg | manager_table (1 row) Time: 25596.315 ms gtgpdb=# select a.schemaname ,a.tablename ,a.tableowner,pg_total_relation_size(a.schemaname||'.'||a.tablename) size from pg_tables a where a.tablename like 'manager_table'; schemaname | tablename | tableowner | size ------------+---------------+------------+--------- gpmg | manager_table | gpadmin | 1736704 (1 row) Time: 28.949 ms gtgpdb=# select a.schemaname ,a.tablename ,a.tableowner,pg_total_relation_size(a.schemaname||'.'||a.tablename) size from pg_tables a where a.tablename like 'manager_table'; schemaname | tablename | tableowner | size ------------+---------------+------------+--------- gpmg | manager_table | gpadmin | 1736704 (1 row) Time: 21.122 ms gtgpdb=# select a.schemaname ,a.tablename ,a.tableowner,pg_relation_size(a.schemaname||'.'||a.tablename) size from pg_tables a where a.tablename like 'manager_table'; schemaname | tablename | tableowner | size ------------+---------------+------------+-------- gpmg | manager_table | gpadmin | 327680 (1 row) Time: 313.303 ms gtgpdb=# select a.schemaname ,a.tablename ,a.tableowner,pg_rel
首页 上一页 1 2 3 下一页 尾页 2/3/3
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇ASM磁盘组异机迁移 下一篇innodbnext-keylock解析

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·数据库:推荐几款 Re (2025-12-25 12:17:11)
·如何最简单、通俗地 (2025-12-25 12:17:09)
·什么是Redis?为什么 (2025-12-25 12:17:06)
·对于一个想入坑Linux (2025-12-25 11:49:07)
·Linux 怎么读? (2025-12-25 11:49:04)