How to find details about external tables in GPDB

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)

Comments