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 (18 rows) Time: 103713.791 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: 35004.159 ms gtgpdb=# 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 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 '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_tim