socket_*
The socket_* tables are in place for future use and are not populated in current Greengage DB versions.
The socket_* tables of the gpperfmon database store statistical metrics about socket usage by a Greengage DB cluster.
There are three tables with the same columns:
-
socket_nowis an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data. -
socket_tailis an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data. This is a transitional table for socket statistical metrics that have been cleared fromsocket_nowbut have not yet been committed tosocket_history. This table is for internal use only. -
socket_historyis a regular table that stores historical socket statistical metrics. It is partitioned into monthly partitions. Partitions are automatically added in two-month increments as needed.
| Column | Type | Description |
|---|---|---|
ctime |
timestamp(0) without time zone |
The time the row was created |
hostname |
varchar(64) |
Segment or master hostname associated with these socket statistics |
total_sockets_used |
int |
Total sockets used in the system |
tcp_sockets_inuse |
int |
Number of TCP sockets in use |
tcp_sockets_orphan |
int |
Number of TCP sockets orphaned |
tcp_sockets_timewait |
int |
Number of TCP sockets in |
tcp_sockets_alloc |
int |
Number of TCP sockets allocated |
tcp_sockets_memusage_inbytes |
int |
Amount of memory consumed by TCP sockets |
udp_sockets_inuse |
int |
Number of UDP sockets in use |
udp_sockets_memusage_inbytes |
int |
Amount of memory consumed by UDP sockets |
raw_sockets_inuse |
int |
Number of RAW sockets in use |
frag_sockets_inuse |
int |
Number of FRAG sockets in use |
frag_sockets_memusage_inbytes |
int |
Amount of memory consumed by FRAG sockets |