socket_*

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.

Column	Type	Description
`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.