network_interface_*

network_interface_*

The network_interface_* tables store statistical metrics about communications over each active interface for a Greenplum Database instance.

Deprecated. These tables are not currently populated and will be removed in a future release.

There are three network_interface_* tables, all having the same columns:

  • network_interface_now is an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data.
  • network_interface_tail is an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data. This is a transitional table for statistical interface metrics that has been cleared from network_interface_now but has not yet been committed to network_interface_history. It typically only contains a few minutes worth of data.
  • network_interface_history is a regular table that stores statistical interface metrics. It is pre-partitioned into monthly partitions. Partitions are automatically added in one month increments as needed. Administrators must drop old partitions for the months that are no longer needed.
Column Type Description
ctime timestamp(0) without time zone Time this record was created.
hostname varchar(64) The hostname associated with this interface measurement.
interface_name varchar(64) Name of the interface. For example: eth0, eth1, lo.
bytes_received bigint Amount of data received in bytes.
packets_received bigint Number of packets received.
receive_errors bigint Number of errors encountered while data was being received.
receive_drops bigint Number of times packets were dropped while data was being received.
receive_fifo_errors bigint Number of times FIFO (first in first out) errors were encountered while data was being received.
receive_frame_errors bigint Number of frame errors while data was being received.
receive_compressed_packets int Number of packets received in compressed format.
receive_multicast_packets int Number of multicast packets received.
bytes_transmitted bigint Amount of data transmitted in bytes.
packets_transmitted bigint Amount of data transmitted in bytes.
packets_transmitted bigint Number of data packets transmitted in bytes.
transmit_errors bigint Number of errors encountered during data transmission.
transmit_drops bigint Number of times packets were dropped during data transmission.
transmit_fifo_errors bigint Number of times fifo errors were encountered during data transmission.
transmit_collision_errors bigint Number of times collision errors were encountered during data transmission.
transmit_carrier_errors bigint Number of times carrier errors were encountered during data transmission.
transmit_compressed_packets int Number of packets transmitted in compressed format.