We have migrated to new Google sites!
Post date: Oct 11, 2012 2:31:6 AM
gpperfmon=# \dt
List of relations
Schema | Name | Type | Owner | Storage
--------+--------------------------------------+-------+---------+---------
public | database_history | table | gpadmin | heap
public | database_history_1_prt_1 | table | gpadmin | heap
public | database_history_1_prt_r1414760380 | table | gpadmin | heap
public | database_history_1_prt_r1845545702 | table | gpadmin | heap
public | database_history_1_prt_r1981397895 | table | gpadmin | heap
public | database_history_1_prt_r785090635 | table | gpadmin | heap
public | database_history_1_prt_r979571749 | table | gpadmin | heap
public | diskspace_history | table | gpadmin | heap
public | diskspace_history_1_prt_1 | table | gpadmin | heap
public | diskspace_history_1_prt_r1420850340 | table | gpadmin | heap
public | diskspace_history_1_prt_r1646040179 | table | gpadmin | heap
public | diskspace_history_1_prt_r247082178 | table | gpadmin | heap
public | diskspace_history_1_prt_r784375007 | table | gpadmin | heap
public | diskspace_history_1_prt_r811823566 | table | gpadmin | heap
public | emcconnect_history | table | gpadmin | heap
public | emcconnect_history_1_prt_1 | table | gpadmin | heap
public | emcconnect_history_1_prt_r1111007269 | table | gpadmin | heap
public | emcconnect_history_1_prt_r1390325210 | table | gpadmin | heap
public | emcconnect_history_1_prt_r1654433443 | table | gpadmin | heap
public | emcconnect_history_1_prt_r1666485216 | table | gpadmin | heap
public | emcconnect_history_1_prt_r23967049 | table | gpadmin | heap
public | filerep_history | table | gpadmin | heap
public | filerep_history_1_prt_1 | table | gpadmin | heap
public | filerep_history_1_prt_r1233546293 | table | gpadmin | heap
public | filerep_history_1_prt_r1268024315 | table | gpadmin | heap
public | filerep_history_1_prt_r1382437234 | table | gpadmin | heap
public | filerep_history_1_prt_r1592304 | table | gpadmin | heap
public | filerep_history_1_prt_r1928470995 | table | gpadmin | heap
public | geometry_columns | table | gpadmin | heap
public | health_history | table | gpadmin | heap
public | health_history_1_prt_1 | table | gpadmin | heap
public | health_history_1_prt_r1176952984 | table | gpadmin | heap
public | health_history_1_prt_r1466404014 | table | gpadmin | heap
public | health_history_1_prt_r1756223207 | table | gpadmin | heap
public | health_history_1_prt_r1846446834 | table | gpadmin | heap
public | health_history_1_prt_r872843382 | table | gpadmin | heap
public | iterators_history | table | gpadmin | heap
public | iterators_history_1_prt_1 | table | gpadmin | heap
public | iterators_history_1_prt_r1931967214 | table | gpadmin | heap
public | iterators_history_1_prt_r238364912 | table | gpadmin | heap
public | iterators_history_1_prt_r339146825 | table | gpadmin | heap
public | iterators_history_1_prt_r506792999 | table | gpadmin | heap
public | iterators_history_1_prt_r825025944 | table | gpadmin | heap
public | network_interface_history | table | gpadmin | heap
public | network_interface_history_1_prt_1 | table | gpadmin | heap
public | queries_history | table | gpadmin | heap
public | queries_history_1_prt_1 | table | gpadmin | heap
public | queries_history_1_prt_r1754051102 | table | gpadmin | heap
public | queries_history_1_prt_r237885677 | table | gpadmin | heap
public | queries_history_1_prt_r447516013 | table | gpadmin | heap
public | queries_history_1_prt_r596721241 | table | gpadmin | heap
public | queries_history_1_prt_r826216205 | table | gpadmin | heap
public | segment_history | table | gpadmin | heap
public | segment_history_1_prt_1 | table | gpadmin | heap
public | segment_history_1_prt_r1731399079 | table | gpadmin | heap
public | segment_history_1_prt_r1782453606 | table | gpadmin | heap
public | segment_history_1_prt_r1847732898 | table | gpadmin | heap
public | segment_history_1_prt_r308964361 | table | gpadmin | heap
public | segment_history_1_prt_r806567465 | table | gpadmin | heap
public | socket_history | table | gpadmin | heap
public | socket_history_1_prt_1 | table | gpadmin | heap
public | spatial_ref_sys | table | gpadmin | heap
public | system_history | table | gpadmin | heap
public | system_history_1_prt_1 | table | gpadmin | heap
public | system_history_1_prt_r102872107 | table | gpadmin | heap
public | system_history_1_prt_r1125633769 | table | gpadmin | heap
public | system_history_1_prt_r1172462770 | table | gpadmin | heap
public | system_history_1_prt_r420771978 | table | gpadmin | heap
public | system_history_1_prt_r664921611 | table | gpadmin | heap
public | tcp_extended_history | table | gpadmin | heap
public | tcp_extended_history_1_prt_1 | table | gpadmin | heap
public | tcp_history | table | gpadmin | heap
public | tcp_history_1_prt_1 | table | gpadmin | heap
public | udp_history | table | gpadmin | heap
public | udp_history_1_prt_1 | table | gpadmin | heap
(75 rows)
gpperfmon=# \dxv
List of relations
Schema | Name | Type | Owner | Storage
--------+--------------------------+-------+---------+----------
public | _database_tail | table | gpadmin | external
public | _diskspace_tail | table | gpadmin | external
public | _emcconnect_tail | table | gpadmin | external
public | _filerep_tail | table | gpadmin | external
public | _iterators_tail | table | gpadmin | external
public | _network_interface_tail | table | gpadmin | external
public | _queries_tail | table | gpadmin | external
public | _segment_tail | table | gpadmin | external
public | _socket_tail | table | gpadmin | external
public | _system_tail | table | gpadmin | external
public | _tcp_extended_tail | table | gpadmin | external
public | _tcp_tail | table | gpadmin | external
public | _udp_tail | table | gpadmin | external
public | database_now | table | gpadmin | external
public | database_tail | table | gpadmin | external
public | diskspace_now | table | gpadmin | external
public | diskspace_tail | table | gpadmin | external
public | dynamic_memory_info | view | gpadmin | none
public | filerep_now | table | gpadmin | external
public | filerep_tail | table | gpadmin | external
public | health_now | table | gpadmin | external
public | iterators_history_rollup | view | gpadmin | none
public | iterators_now | table | gpadmin | external
public | iterators_now_rollup | view | gpadmin | none
public | iterators_tail | table | gpadmin | external
public | iterators_tail_rollup | view | gpadmin | none
public | master_data_dir | table | gpadmin | external
public | memory_info | view | gpadmin | none
public | network_interface_now | table | gpadmin | external
public | network_interface_tail | table | gpadmin | external
public | queries_now | table | gpadmin | external
public | queries_now_fast | table | gpadmin | external
public | queries_tail | table | gpadmin | external
public | segment_now | table | gpadmin | external
public | segment_tail | table | gpadmin | external
public | socket_now | table | gpadmin | external
public | socket_tail | table | gpadmin | external
public | system_now | table | gpadmin | external
public | system_tail | table | gpadmin | external
public | tcp_extended_now | table | gpadmin | external
public | tcp_extended_tail | table | gpadmin | external
public | tcp_now | table | gpadmin | external
public | tcp_tail | table | gpadmin | external
public | udp_now | table | gpadmin | external
public | udp_tail | table | gpadmin | external
(45 rows)