The 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_now is an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data.
    • socket_stats_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_stats_now but has not yet been committed to socket_stats_history. It typically only contains a few minutes worth of data.
    • socket_stats_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.
    ColumnTypeDescription
    total_sockets_usedintTotal sockets used in the system.
    tcp_sockets_inuseintNumber of TCP sockets in use.
    tcp_sockets_orphanintNumber of TCP sockets orphaned.
    tcp_sockets_timewaitintNumber of TCP sockets in Time-Wait.
    tcp_sockets_allocintNumber of TCP sockets allocated.
    tcp_sockets_memusage_inbytesintAmount of memory consumed by TCP sockets.
    udp_sockets_inuseintNumber of UDP sockets in use.
    udp_sockets_memusage_inbytesintAmount of memory consumed by UDP sockets.
    raw_sockets_inuseintNumber of RAW sockets in use.
    frag_sockets_inuseintNumber of FRAG sockets in use.
    frag_sockets_memusage_inbytesintAmount of memory consumed by FRAG sockets.

    Parent topic: The gpperfmon Database