List of tables in the GPPERFMON database

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)