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. |
| transmit_compressed_packets | int | Number of packets transmitted in compressed format. |