network_interface_*

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

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.