统计对象大小函数性能比较(二)
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