Applies To:

Show Versions Show Versions

Manual Chapter: Facts Tables Reference
Manual Chapter
Table of Contents   |   << Previous Chapter

About fact tables

Fact tables contain fields that are specific to the collected statistics type.

Important:

The partition_number field is not documented in the following fact tables. Do not reference the partition_number field in any custom code that you write, because that field is subject to change.

Chassis statistics (perfmon_chassis_stat)

The perfmon_chassis_stat database table contains the temperature statistics of the chassis for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
temperature int unsigned YES Temperature of chassis gauge

CPU statistics (perfmon_cpu_stat)

The perfmon_cpu_stat database table contains the temperature and fan speed statistics for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
fan_speed smallint unsigned YES Speed of CPU fan gauge
temperature int unsigned YES Temperature of CPU fan gauge

CPU usage statistics (perfmon_cpu_info_stat)

The perfmon_cpu_info_stat database table contains statistics about the CPU usage for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
cpu_usage_ratio smallint unsigned YES Ratio of CPU usage to available CPU capacity gauge

Disk space statistics (perfmon_disk_space_stat)

The perfmon_disk_space_stat database table contains details about the disk space for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics. N/A
t timestamp NO Time of data sample N/A
block_size int unsigned YES Size of blocks on disk gauge
tot_blocks int unsigned YES Number of blocks on disk gauge
free_blocks int unsigned YES Number of unused blocks on disk gauge
block_ratio smallint unsigned YES Ratio of free blocks to available blocks gauge
tot_nodes int unsigned YES Number of disk nodes gauge
free_nodes int unsigned YES Number of free disk nodes gauge

GTM pool member statistics (perfmon_gtm_pool_member_stat)

The perfmon_gtm_pool_member_stat database table contains performance for each managed Global Traffic Manager™ (GTM™) pool member.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
preferred int unsigned YES Rate of requests per second successfully processed by the configured preferred load balancing method counter
alternate int unsigned YES Rate of requests per second successfully processed by the configured alternate load balancing method counter
drop int unsigned YES Rate of requests per second that were not successfully processed, and were returned to the requesting DNS server counter
fallback int unsigned YES Rate of requests per second that were successfully processed by the configured fall-back load balancing method counter

GTM pool statistics (perfmon_gtm_pool_stat)

The perfmon_gtm_pool_stat database table contains performance statistics for each managed Global Traffic Manager™ (GTM™) pool.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
preferred int unsigned YES Rate of requests per second successfully processed by the configured preferred load balancing method counter
dropped int unsigned YES Rate of requests per second that were not successfully processed, and were returned to the requesting DNS server counter
fallback int unsigned YES Rate of requests per second that were successfully processed by the configured fall-back load balancing method counter

GTM virtual server statistics (perfmon_gtm_vs_stat)

The perfmon_gtm_vs_stat database table contains performance and capacity statistics for each managed Global Traffic Manager™ (GTM™) virtual server.

Field Type Null Value Allowed? Description Query type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
cpu int unsigned YES Current amount of CPU used by this GTM virtual server gauge
mem int unsigned YES Current amount of memory used by this GTM server gauge
bits_in int unsigned YES Current amount of throughput received, measured in bits per second gauge
bits_out int unsigned YES Current amount of throughput sent, measured in bits per second gauge
conn bigint unsigned YES Current number of connections, measured per second gauge

GTM wide IP statistics (perfmon_gtm_wideip_stat)

This perfmon_gtm_wideip_stat database table contains performance statistics for each managed Global Traffic Manager™ (GTM™) wide IP.

Field Type Null value allowed? Description Query type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
preferred int unsigned YES Rate of requests per second successfully processed by the configured preferred load balancing method counter
alt int unsigned YES Rate of requests per second successfully processed by the configured alternate load balancing method counter
dropped int unsigned YES Rate of requests per second that were not successfully processed, and were returned to the requesting DNS server counter
fallback int unsigned YES Rate of requests per second that were successfully processed by the configured fall-back load balancing method counter

HTTP traffic statistics (perfmon_http_stat)

The perfmon_http_stat database table contains HTTP-related traffic statistics for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
http_cookie_persist_inserts bigint unsigned YES Rate of successful attempts to insert HTTP headers for cookie persistence (set-cookie header insertions) counter
http_resp_2xx_cnt bigint unsigned YES Rate of server-side responses in range of 200 to 206 (successful responses) counter
http_resp_3xx_cnt bigint unsigned YES Rate of server-side responses in range of 300 to 307 (redirection responses) counter
http_resp_4xx_cnt bigint unsigned YES Rate of server-side responses in range of 400 to 417 (client errors) counter
http_resp_5xx_cnt bigint unsigned YES Rate of server-side responses in range of 500 to 505 (server errors) counter
http_number_reqs bigint unsigned YES Rate of HTTP requests counter
http_get_reqs bigint unsigned YES Rate of HTTP GET requests counter
http_post_reqs bigint unsigned YES Rate of HTTP POST requests counter
http_v9_reqs bigint unsigned YES Rate of version 9 requests counter
http_v10_reqs bigint unsigned YES Rate of version 10 requests counter
http_max_keepalive_req bigint unsigned YES Maximum number of requests made in a connection gauge
http_resp_bucket_1k bigint unsigned YES Rate of responses under 1K counter
http_resp_bucket_4k bigint unsigned YES Rate of responses between 1K and 4K counter
http_resp_bucket_16k bigint unsigned YES Rate of responses between 4K and 16K counter
http_resp_bucket_32k bigint unsigned YES Rate of responses between 16K and 32K counter
http_resp_bucket_64k bigint unsigned YES This field is deprecated; use larger buckets counter
http_idle_conn_splices bigint unsigned YES Rate of response bytes before compression is applied counter
http_idle_conns bigint unsigned YES Rate of idle HTTP connections at the time of query counter
http_precompress_bytes bigint unsigned YES Rate of response bytes before compression is applied counter
http_postcompress_bytes bigint unsigned YES Rate of response bytes after compression is applied counter
http_null_compress_bytes bigint unsigned YES Rate of bytes subjected to NULL compression for license enforcement counter
http_html_precompress_bytes bigint unsigned YES Rate of bytes for HTML MIME types before compression is applied counter
http_html_postcompress_bytes bigint unsigned YES Rate of bytes for HTML MIME types after compression is applied counter
http_css_precompress_bytes bigint unsigned YES Rate of bytes for CSS MIME types before compression is applied counter
http_css_postcompress_bytes bigint unsigned YES Rate of bytes for CSS MIME types after compression is applied counter
http_js_precompress_bytes bigint unsigned YES Rate of bytes for JS MIME types before compression is applied counter
http_js_postcompress_bytes bigint unsigned YES Rate of bytes for JS MIME types after compression is applied counter
http_xml_precompress_bytes bigint unsigned YES Rate of bytes for XML MIME types before compression is applied counter
http_xml_postcompress_bytes bigint unsigned YES Rate of bytes for XML MIME types after compression is applied counter
http_sgml_precompress_bytes bigint unsigned YES Rate of bytes for SGML MIME types before compression is applied counter
http_sgml_postcompress_bytes bigint unsigned YES Rate of bytes for SGML MIME types after compression is applied counter
http_plain_precompress_bytes bigint unsigned YES Rate of bytes for plain MIME types before compression is applied counter
http_plain_postcompress_bytes bigint unsigned YES Rate of bytes for plain MIME types after compression is applied counter
http_octet_precompress_bytes bigint unsigned YES Rate of bytes for octet MIME types before compression is applied counter
http_octet_postcompress_bytes bigint unsigned YES Rate of bytes for octet MIME types after compression is applied counter
http_image_precompress_bytes bigint unsigned YES Rate of bytes for image MIME types before compression is applied counter
http_image_postcompress_bytes bigint unsigned YES Rate of bytes for image MIME types after compression is applied counter
http_video_precompress_bytes bigint unsigned YES Rate of bytes for video MIME types before compression is applied counter
http_video_postcompress_bytes bigint unsigned YES Rate of bytes for video MIME types after compression is applied counter
http_audio_precompress_bytes bigint unsigned YES Rate of bytes for audio MIME types before compression is applied counter
http_audio_postcompress_bytes bigint unsigned YES Rate of bytes for audio MIME types after compression is applied counter
http_other_precompress_bytes bigint unsigned YES Rate of bytes for other MIME types before compression is applied counter
http_other_postcompress_bytes bigint unsigned YES Rate of bytes for other MIME types after compression is applied counter
http_ramcache_hits bigint unsigned YES Rate of RAM cache hits counter
http_ramcache_misses bigint unsigned YES Rate of RAM cache misses counter
http_ramcache_misses_all bigint unsigned YES Rate of RAM cache misses, including data that could not be cached counter
http_ramcache_hit_bytes bigint unsigned YES Rate of RAM cache hits, reported in bytes counter
http_ramcache_miss_bytes bigint unsigned YES Rate of RAM cache misses, excluding data that could not be cached, reported in bytes counter
http_ramcache_miss_bytes_all bigint unsigned YES Rate of all RAM cache misses, reported in bytes counter
http_ramcache_size bigint unsigned YES Maximum available RAM cache available, reported in megabytes gauge
http_ramcache_count bigint unsigned YES Rate of items stored in RAM cache counter
http_ramcache_evictions bigint unsigned YES Rate of items removed from RAM cache to free memory for new items counter

Memory usage and connection statistics (perfmon_global_stat)

The perfmon_global_stat database table contains aggregated server-side and client-side statistics about memory usage and connections for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
client_tot_byte_in bigint unsigned YES Rate of client-side bytes received counter
client_tot_bytes_out bigint unsigned YES Rate of client-side bytes sent counter
client_pkts_in bigint unsigned YES Rate of client-side packets received counter
client_pkts_out bigint unsigned YES Rate of client-side packets sent counter
client_maxconns bigint unsigned YES Maximum number of client-side connections reported since statistics collection was set or reset for the device gauge
client_tot_conns bigint unsigned YES Rate of client-side connections per second counter
client_cur_conns bigint unsigned YES Current number of client-side connections gauge
server_tot_bytes_in bigint unsigned YES Rate of server-side bytes received counter
server_tot_bytes_out bigint unsigned YES Rate of server-side bytes sent counter
server_pkts_in bigint unsigned YES Rate of server-side packets received counter
server_pkts_out bigint unsigned YES Rate of server-side packets sent counter
server_maxconns bigint unsigned YES Maximum number of concurrent server-side connections reported since statistics collection was set or reset for the device gauge
server_cur_conns bigint unsigned YES Current number of active server-side connections gauge
server_tot_conns bigint unsigned YES Rate of server-side connections counter
mem bigint unsigned YES Available memory gauge
mem_used bigint unsigned YES Memory in use gauge
mem_ratio smallint unsigned YES Ratio of available memory to memory in use gauge
dropped bigint unsigned YES Rate of dropped packets counter
err_in bigint unsigned YES Rate of errors received counter
err_out bigint unsigned YES Rate of errors sent counter

LTM node statistics (perfmon_node_stat)

The perfmon_node_stat database table contains statistics for traffic and connections to Local Traffic Manager™ (LTM®) node objects for each managed device.

Field Type Null value allowed? Description Query type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
server_tot_bytes_in bigint unsigned YES Total number of server-side bytes received by the specified node address since statistics collection was set or reset for the device counter
server_tot_bytes_out bigint unsigned YES Rate of server-side bytes sent by the specified node address counter
server_pkts_in bigint unsigned YES Rate of server-side packets received by the specified node address counter
server_pkts_out bigint unsigned YES Rate of server-side packets sent by the specified node address counter
server_maxconns bigint unsigned YES Maximum number of concurrent server-side connections to the specified node address since statistics collection was set or reset for the device gauge
server_tot_conns bigint unsigned YES Rate of server-side connections to the specified node address counter
server_cur_conns bigint unsigned YES Current number of active server-side connections to the specified node address gauge

LTM pool member statistics (perfmon_pool_member_stat)

The perfmon_pool_member_stat database table contains traffic and connection statistics for Local Traffic Manager™ (LTM®) pool members for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
server_tot_bytes_in bigint unsigned YES Rate of server-side bytes received by the specified pool counter
server_tot_bytes_out bigint unsigned YES Rater of server-side bytes sent by the specified pool counter
server_pkts_in bigint unsigned YES Rate of server-side packets received from the specified pool counter
server_pkts_out bigint unsigned YES Rate of server-side packets sent from the specified pool counter
server_maxconns bigint unsigned YES Maximum number of concurrent server-side connections to the specified pool reported since statistics collection was set or reset for the device gauge
server_tot_conns bigint unsigned YES Rate of server-side connections to the specified pool counter
server_cur_conns bigint unsigned YES Current number of server-side connections to the specified pool gauge

LTM pool statistics (perfmon_pool_stat)

The perfmon_pool_stat database table contains statistics for traffic and connections to Local Traffic Manager™ (LTM®) pools for each managed device.

Field Type Null value allowed? Description Query type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
server_tot_bytes_in bigint unsigned YES Rate of server-side bytes received by the specified pool counter
server_tot_bytes_out bigint unsigned YES Rate of server-side bytes sent by the specified pool counter
server_pkts_in bigint unsigned YES Rate of server-side packets received from the specified pool counter
server_pkts_out bigint unsigned YES Rate of server-side packets sent from the specified pool counter
server_maxconns bigint unsigned YES Maximum number of server-side connections to the specified pool reported since statistics collection was set or reset for the device gauge
server_tot_conns bigint unsigned YES Rate of server-side connections to the specified pool reported counter
server_cur_conns bigint unsigned YES Current number of active server-side connections to the specified pool gauge

TCP connection statistics (perfmon_tcp_stat)

The perfmon_tcp_stat database table contains TCP connection statistics for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
open int unsigned YES Rate of current open TCP connections counter
closewait int unsigned YES Rate of current TCP connections in CLOSE-WAIT/LAST-ACK state counter
finwait int unsigned YES Rate of current connections in FIN-WAIT/CLOSING state counter
timewait int unsigned YES Rate of current connections in TIME-WAIT state counter
accept bigint unsigned YES Rate of TCP connections accepted counter
acceptfails bigint unsigned YES Rate of TCP connections not accepted counter
conn bigint unsigned YES Rate of TCP connections established counter
connfail bigint unsigned YES Rate of TCP connection failures counter
expires bigint unsigned YES Rate of TCP connections that expired due to idle timeout counter
abandons bigint unsigned YES Rate of TCP connections abandoned due to retries and Keep-Alive attempts counter
rxrst bigint unsigned YES Rate of received RST packets counter
rxbadsum bigint unsigned YES Rate of bad checksum packets counter
rxbadseg bigint unsigned YES Rate of malformed segments counter
rxcookie bigint unsigned YES Rate of received SYN-cookies counter
rxbadcookie bigint unsigned YES Rate of bad SYN-cookies counter
syncacheover bigint unsigned YES Rate of SYN-cache overflow counter
txrexmits bigint unsigned YES Rate of retransmitted segments counter

Threshold state (perfmon_threshold_state)

The perfmon_threshold_state database table contains the current threshold state of each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
stat_column_name varchar(256) NO Identifies the individual statistics to which this threshold applies threshold
collection interval int unsigned NO Interval at which this statistic is collected threshold
status enum ? NO Status of the statistic collection (enabled,?disabled,? profile_change) threshold
min_threshold bigint unsigned YES Minimum value of threshold threshold
threshold_state enum? NO State of the threshold range ( BELOW_MIN_THRESHOLD,?ABOVE_MAX_THRESHOLD,?WITHIN_THRESHOLD) threshold
threshold_exceeded_since timestamp YES Current database has exceeded threshold since this time threshold
last_alert_fired timestamp YES Time that the last alert was triggered for this out-of-threshold event threshold

UDP connection statistics (perfmon_udp_stat)

The perfmon_udp_stat database table contains UDP connection statistics for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
open int unsigned YES Rate of current open UDP connections counter
accept bigint unsigned YES Rte of accepted UDP connections counter
acceptfails bigint unsigned YES Rate of UDP connections that failed because they were not accepted counter
conn bigint unsigned YES Rate of established UDP connections counter
connfail bigint unsigned YES Rate of failed UDP connections counter
expires bigint unsigned YES Rate of expired connections due to idle timeout counter
rdxgram bigint unsigned YES Rate of datagrams received counter
rxbaddgram bigint unsigned YES Rate of malformed datagrams counter
rxunreach bigint unsigned YES Rate of received ICMP messages counter
rxnosum bigint unsigned YES Rate of UDP connections with no checksum counter
txdgram bigint unsigned YES Rate of transmitted datagram packets counter

LTM virtual server statistics (perfmon_vip_stat)

The perfmon_vip_stat database table contains statistics about the connection statistics of Local Traffic Manager™ (LTM®) virtual servers configured for each managed device.

Field Type Null Value Allowed? Description Query Type (if applicable)
perfmon_device_object_uid int unsigned NO Used to identify the device and object as the foreign key on? perfmon_device_object.uid N/A
insert_order int unsigned NO Used to calculate delta values for counter statistics N/A
t timestamp NO Time of data sample N/A
client_tot_byte_in bigint unsigned YES Rate of client-side bytes received by the specified virtual server counter
client_tot_bytes_out bigint unsigned YES Rate of client-side bytes sent from the specified virtual server counter
client_pkts_in bigint unsigned YES Rate of client-side packets received by the specified virtual server counter
client_pkts_out bigint unsigned YES Rate of client-side packets sent from the specified virtual server counter
client_maxconns bigint unsigned YES Maximum client-side connections to the specified virtual server gauge
client_tot_conns bigint unsigned YES Rate of client-side connections to the specified virtual server counter
client_cur_conns bigint unsigned YES Current number of client-side connections to the specified virtual server gauge
Table of Contents   |   << Previous Chapter

Was this resource helpful in solving your issue?




NOTE: Please do not provide personal information.



Incorrect answer. Please try again: Please enter the words to the right: Please enter the numbers you hear:

Additional Comments (optional)