This version of the Pivotal Greenplum documentation is no longer actively maintained. Click here to view the most up-to-date version of the Greenplum 4.x documentation.
The socket_* tables store statistical metrics about socket usage for a Greenplum Database instance. There are three system tables, all having the same columns:
Deprecated. These tables are not currently populated and will be removed in a future release.
There are three system tables, all having the same columns:
- socket_now is an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data.
- socket_tail is an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data. This is a transitional table for socket statistical metrics that has been cleared from socket_now but has not yet been committed to socket_history. It typically only contains a few minutes worth of data.
- socket_history is a regular table that stores historical socket statistical metrics. It is pre-partitioned into monthly partitions. Partitions are automatically added in two month increments as needed. Administrators must drop old partitions for the months that are no longer needed.
|ctime||timestamp(0) with no time zone||Time this record was created.|
|hostname||varchar(64)||The hostname associated with this measurement.|
|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 Time-Wait.|
|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.|