List of tables in the GPPERFMON database

posted Apr 28, 2017, 4:41 PM by Sachchida Ojha
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)
Comments