Note: using pg_catalog.pg_exttable, you can see details about external table. gpperfmon=# \dt pg_exttable List of relations Schema | Name | Type | Owner | Storage ------------+-------------+-------+---------+--------- pg_catalog | pg_exttable | table | gpadmin | heap (1 row) gpperfmon=# \d pg_exttable Table "pg_catalog.pg_exttable" Column | Type | Modifiers -----------------+---------+----------- reloid | oid | not null location | text[] | fmttype | "char" | fmtopts | text | command | text | rejectlimit | integer | rejectlimittype | "char" | fmterrtbl | oid | encoding | integer | writable | boolean | Indexes: "pg_exttable_reloid_index" UNIQUE, btree (reloid) gpperfmon=# gpperfmon=# select * from pg_exttable; reloid | location | fmttype | fmtopts | command | rejectlimit | rejectlimitt ype | fmterrtbl | encoding | writable --------+----------------+---------+------------------------------------------------+------------------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------+-------------+------------- ----+-----------+----------+---------- 16413 | {ALL_SEGMENTS} | t | delimiter ' ' null '\N' escape '\' | echo $GP_SEGMENT_ID | | | | 6 | f 16436 | {MASTER_ONLY} | t | delimiter ' ' null '\N' escape '\' | echo $GP_SEGMENT_ID | | | | 6 | f 16462 | {ALL_SEGMENTS} | c | delimiter ',' null '' escape '"' quote '"' | cat $GP_SEG_DATADIR/pg_log/*.csv | | | | 6 | f 16485 | {MASTER_ONLY} | c | delimiter ',' null '' escape '"' quote '"' | cat $GP_SEG_DATADIR/pg_log/*.csv | | | | 6 | f 16612 | {ALL_SEGMENTS} | c | delimiter ',' null '' escape '"' quote '"' | python -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk _free_info_local('token','$GP_SEG_DATADIR'); print '%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3])" | | | | 6 | f 33625 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/system_now.dat 2> /dev/null || true | | | | 6 | f 33648 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/system_tail.dat 2> /dev/null || true | | | | 6 | f 33671 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_system_tail.dat 2> /dev/null || true | | | | 6 | f 33762 | {MASTER_ONLY} | c | delimiter '|' null 'null' escape '"' quote '"' | python $GPHOME/sbin/gpmon_catqrynow.py 2> /dev/null || true | | | | 6 | f 33785 | {MASTER_ONLY} | c | delimiter '|' null 'null' escape '"' quote '"' | cat gpperfmon/data/queries_now.dat 2> /dev/null || true | | | | 6 | f 33808 | {MASTER_ONLY} | c | delimiter '|' null 'null' escape '"' quote '"' | cat gpperfmon/data/queries_tail.dat 2> /dev/null || true | | | | 6 | f 33831 | {MASTER_ONLY} | c | delimiter '|' null 'null' escape '"' quote '"' | cat gpperfmon/data/_queries_tail.dat 2> /dev/null || true | | | | 6 | f 33930 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/iterators_now.dat 2> /dev/null || true | | | | 6 | f 33953 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/iterators_tail.dat 2> /dev/null || true | | | | 6 | f 33976 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_iterators_tail.dat 2> /dev/null || true | | | | 6 | f 34059 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/database_now.dat 2> /dev/null || true | | | | 6 | f 34082 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/database_tail.dat 2> /dev/null || true | | | | 6 | f 34105 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_database_tail.dat 2> /dev/null || true | | | | 6 | f 34128 | {MASTER_ONLY} | c | delimiter '|' null '' escape '"' quote '"' | python -c "import socket, os; print socket.gethostname() + \"|\" + os.g etcwd()" | | | | 6 | f 34221 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/segment_now.dat 2> /dev/null || true | | | | 6 | f 34244 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/segment_tail.dat 2> /dev/null || true | | | | 6 | f 34267 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_segment_tail.dat 2> /dev/null || true | | | | 6 | f 34360 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_emcconnect_tail.dat 2> /dev/null || true | | | | 6 | f 34447 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/snmp/snmp.host.*.txt 2> /dev/null || true | | | | 6 | f 34530 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/filerep_now.dat 2> /dev/null || true | | | | 6 | f 34553 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/filerep_tail.dat 2> /dev/null || true | | | | 6 | f 34576 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_filerep_tail.dat 2> /dev/null || true | | | | 6 | f 34663 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/diskspace_now.dat 2> /dev/null || true | | | | 6 | f 34686 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/diskspace_tail.dat 2> /dev/null || true | | | | 6 | f 34709 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_diskspace_tail.dat 2> /dev/null || true | | | | 6 | f 34792 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/network_interface_now.dat 2> /dev/null || true | | | | 6 | f 34815 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/network_interface_tail.dat 2> /dev/null || true | | | | 6 | f 34838 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_network_interface_tail.dat 2> /dev/null || true | | | | 6 | f 34921 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/socket_now.dat 2> /dev/null || true | | | | 6 | f 34944 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/socket_tail.dat 2> /dev/null || true | | | | 6 | f 34967 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_socket_tail.dat 2> /dev/null || true | | | | 6 | f 35050 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/udp_now.dat 2> /dev/null || true | | | | 6 | f 35073 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/udp_tail.dat 2> /dev/null || true | | | | 6 | f 35096 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_udp_tail.dat 2> /dev/null || true | | | | 6 | f 35179 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/tcp_now.dat 2> /dev/null || true | | | | 6 | f 35202 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/tcp_tail.dat 2> /dev/null || true | | | | 6 | f 35225 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_tcp_tail.dat 2> /dev/null || true | | | | 6 | f 35308 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/tcp_extended_now.dat 2> /dev/null || true | | | | 6 | f 35331 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/tcp_extended_tail.dat 2> /dev/null || true | | | | 6 | f 35354 | {MASTER_ONLY} | t | delimiter '|' null 'null' escape '\' | cat gpperfmon/data/_tcp_extended_tail.dat 2> /dev/null || true | | | | 6 | f (45 rows) |
|
|