summary_hosts Table
The following table describes the schema of the summary_hosts_in and summary_hosts_ex SQL tables. The table fields are identical apart from the ip field - this field represent the IPv4 or IPv6 address of an internal host (summary_hosts_in) or an external host (summary_hosts_ex).
A host is internal if it is on the LANLocal area network side of the appliance and external when on the WANWide Area Network side.
| Field | Type | Description |
|---|---|---|
|
ip |
binary string |
A string representation of the internal or external IPv4 or IPv6 address of the host. |
|
bytes_in |
unsigned 64-bit integer |
The number of inbound (WAN -> LAN) bytes recorded for this flowthe network traffic between network objects over the sample period. |
|
bytes_out |
unsigned 64-bit integer |
The number of outbound (LAN -> WAN) bytes recorded for this flow over the sample period. |
|
packets_in |
unsigned 64-bit integer |
The number of inbound (WAN -> LAN) packets recorded for this flow over the sample period. |
|
packets_out |
unsigned 64-bit integer |
The number of outbound (LAN -> WAN) packets recorded for this flow over the sample period. |
|
intervals_in |
unsigned 24-bit integer |
The number of 10 second intervals there was inbound (WAN -> LAN) traffic observed for this flow during the sample period (bps). |
|
intervals_out |
unsigned 24-bit integer |
The number of 10 second intervals there was outbound (LAN -> WAN) traffic observed for this flow during the sample period (bps). |
|
timestamp |
unsigned 32-bit integer |
A UNIX timestamp (number of seconds since epoch - 1st Jan 1970) that represents the start of the sample period. |
|
max_tput_in |
unsigned 64-bit integer |
The maximum inbound (WAN -> LAN) throughput observed for this flow during the sample period. |
|
max_tput_out |
unsigned 64-bit integer |
The maximum outbound (LAN -> WAN) throughput observed for this flow during the sample period. |
|
rtt |
unsigned 32-bit integer |
Round Trip Time in milliseconds. A measure if the time a packet takes to leave a device, cross a network and return.1 |
|
network_delay |
unsigned 32-bit integer |
A normalized measure of the time taken for transaction data to traverse the network.1 |
|
network_jitter |
unsigned 32-bit integer |
A normalized measure of the network_delay variability.1 |
|
server_delay |
unsigned 32-bit integer |
A normalized measure of the time taken for a server to respond to a transaction request.1 |
|
bytes_lost_in |
unsigned 64-bit integer |
The number of bytes lost due to retransmissions (WAN -> LAN).1 |
|
bytes_lost_out |
unsigned 64-bit integer |
The number of bytes lost due to retransmissions (LAN -> WAN).1 |
For more information refer to Using Application Performance reports.