Statistical object size function Performance comparison

gtgpdb=# SELECT * from Gp_toolkit.gp_size_of_table_disk t where sotdtablename like ' rt_ok% ';  sotdoid | Sotdsize | Sotdtoastsize | Sotdadditionalsize |             Sotdschemaname | Sotdtablename---------+-------------+---------------+--------------------+----------------+------------------           ---------------------1503170 |       0 |            1081344 | 1441792 | GT | RT_OK 1503197 |       32879790712 |            1081344 | 7634944 | GT |           rt_ok_1_prt_event_time20150105 1503225 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20150106 1503300 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20150107 1503351 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20150108 1503402 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20150109 1503453 |       0 |           1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20141220 1503504 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20141221 1503555 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20141222 1503606 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20141223 1503657 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20141224 1503708 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20141225 1503759 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20141226 1503810 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20141227 1503861 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20141228 1503912 |       0 |            1081344 | 1081344 | GT | Rt_ok_1_prt_event_time20141229 1503963 |       0 |            1081344 | 1081344 | GT |           rt_ok_1_prt_event_time20141230 1504014 |       0 |            1081344 | 1081344 | GT | rt_ok_1_prt_event_time20141231 (rows) time:103713.791 msgtgpdb=# 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:35004.159 msgtgpdb=# Select 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 ';               Error:syntax error at or near ' select ' line 1:select select A.schemaname, A.tablename, A.tableowner,pg_tot ... ^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:341.430 msgtgpdb=# Select A.schemaname, A.tablename, A.tableowner,pg_total_relation_size ( a.schemaname| | '. ' | | a.tablename) size from Pg_tables a where a.tablename like ' rt_ok% ';               SchemaName | TableName |    Tableowner | Size------------+---------------------------------------+------------+-------------GT | RT_OK |     GT | 2523136 GT | rt_ok_1_prt_event_time20150105 | GT | 33318650192 GT | rt_ok_1_prt_event_time20150106 |     GT | 2162688 GT | rt_ok_1_prt_event_time20150107 |     GT | 2162688 GT | rt_ok_1_prt_event_time20150108 |     GT | 2162688 GT        | rt_ok_1_prt_event_time20150109 |     GT | 2162688 GT | rt_ok_1_prt_event_time20141220 |     GT | 2162688 GT | rt_ok_1_prt_event_time20141221 |     GT | 2162688 GT | rt_ok_1_prt_event_time20141222 |     GT | 2162688 GT | rt_ok_1_prt_event_time20141223 |     GT | 2162688 GT | rt_ok_1_prt_event_time20141224 |     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 (rows) time:414.039 msgtgpdb=# 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 msgtgpdb=# 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 msgtgpdb=# 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 msgtgpdb=# vacuum analyze gpmg.manager_table; vacuumtime:2734.580 msgtgpdb=# 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 msgtgpdb=# 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 msgtgpdb=# 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 msgtgpdb=# 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 msgtgpdb=# 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 msgtgpdb=# 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)

The result is obvious whether the function can be used directly or directly, avoiding the use of the encapsulated view, even the system view.

-eof-

Statistical object size function Performance comparison