network_interface_*
The network_interface_* tables are in place for future use and are not populated in current Greengage DB versions.
The network_interface_* tables of the gpperfmon database store statistical metrics about communications over each active network interface for a Greengage DB instance.
There are three tables with the same columns:
-
network_interface_nowis an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data. -
network_interface_tailis an external table whose data files are stored in $MASTER_DATA_DIRECTORY/gpperfmon/data. This is a transitional table for statistical interface metrics that have been cleared fromnetwork_interface_nowbut have not yet been committed tonetwork_interface_history. This table is for internal use only. -
network_interface_historyis a regular table that stores statistical interface metrics. It is partitioned into monthly partitions. Partitions are automatically added in one-month increments as needed.
| Column | Type | Description |
|---|---|---|
ctime |
timestamp(0) without time zone |
The time the row was created |
hostname |
varchar(64) |
Segment or master hostname associated with these statistics |
interface_name |
varchar(64) |
Name of the interface. For example: |
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 |
Number of packets transmitted |
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 |