socket_stats_* tables store statistical metrics about socket usage for a Greenplum Database instance. There are three system tables, all having the same columns:
These tables are in place for future use and are not currently populated.
socket_stats_nowis an external table whose data files are stored in
socket_stats_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 has been cleared from
socket_stats_nowbut has not yet been committed to
socket_stats_history. It typically only contains a few minutes worth of data.
socket_stats_historyis 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.
||int||Total sockets used in the system.|
||int||Number of TCP sockets in use.|
||int||Number of TCP sockets orphaned.|
||int||Number of TCP sockets in Time-Wait.|
||int||Number of TCP sockets allocated.|
||int||Amount of memory consumed by TCP sockets.|
||int||Number of UDP sockets in use.|
||int||Amount of memory consumed by UDP sockets.|
||int||Number of RAW sockets in use.|
||int||Number of FRAG sockets in use.|
||int||Amount of memory consumed by FRAG sockets.|
Parent topic: The gpperfmon Database