tcp_stats_* tables store statistical metrics about TCP communications for a Greenplum Database instance.
These tables are in place for future use and are not currently populated.
There are three system tables, all having the same columns:
tcp_stats_nowis an external table whose data files are stored in
tcp_stats_tailis an external table whose data files are stored in
$MASTER_DATA_DIRECTORY/gpperfmon/data. This is a transitional table for TCP statistical data that has been cleared from
tcp_stats_nowbut has not yet been committed to
tcp_stats_history. It typically only contains a few minutes worth of data.
tcp_stats_historyis a regular table that stores historical TCP statistical data. 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.
||bigint||Number of TCP segments received.|
||bigint||Number of TCP segments sent.|
||bigint||Number of TCP segments retransmitted.|
||int||Number of active TCP connections.|
||int||Number of passive TCP connections.|
||int||Number of failed TCP connection attempts.|
||int||Number of TCP connections established.|
||int||Number of TCP connection resets received.|
||int||Number of TCP connection resets sent.|