Document toolboxDocument toolbox

proxy.haproxy.all

Introduction

This union table collects system logs related to HAProxy.

Source tables

The information displayed is extracted from the following tables:

  • proxy.haproxy.clf

  • proxy.haproxy.http

  • proxy.haproxy.tcp

Table structure

This is the set of columns displayed by this union table, which is the result of the collection of columns present in all source tables:

Extra columns

Fields marked as Extra in the table below are not shown by default in data tables and need to be explicitly requested in the query. You can find them marked as Extra when you perform a query so they can be easily identified. Learn more about this in Selecting unrevealed columns.

Field

Type

Source field name

Extra fields

Field

Type

Source field name

Extra fields

eventdate

timestamp

 

 

environment

str

 

 

application

str

serverName

 

clone

str

 

 

source

str

 

 

message

str

 

 

server_date

str

serverdate

 

machine

str

 

 

pid

str

 

 

source_ip

str

 

 

source_ipv4

ip4

srcIp

 

source_port

str

srcPort

 

accept_date

str

 

 

frontend_name

str

 

 

backend_name

str

 

 

server_name

str

 

 

timers

str

 

 

bytes_read

str

 

 

termination_state

str

 

 

actconn_feconn_beconn_srvconn_retries

str

 

 

server_queue

str

 

 

backend_queue

str

 

 

tr

str

 

 

status_code

str

 

 

method

str

 

 

url

str

 

 

protocol

str

 

 

rawMessage

str

 

✓

hostchain

str

 

✓

tag

str

 

✓

Field transformations

Even though all source tables have several features in common, they have some particularities that make it necessary to undergo a set of transformations to harmonize them for the union table. The most common transformations comprise changes in the data type or the application of rules when several columns in the source table feed a single column in the union table. You can find below the detailed list of transformations in each source table.

proxy.haproxy.clf

Field in union table

Field in source table

Field transformation

Type

Extra fields

Field in union table

Field in source table

Field transformation

Type

Extra fields

eventdate

eventdate

 

timestamp

 

environment

environment

 

str

 

application

application

 

str

 

clone

clone

 

str

 

source

-

"clf"

str

 

message

message

 

str

 

server_date

server_date

 

str

 

machine

-

null('')

str

 

pid

-

null('')

str

 

source_ip

srcIp

str

 

source_ipv4

source_ipv4

 

ip4

 

source_port

source_port

 

str

 

accept_date

-

str

 

frontend_name

-

str

 

backend_name

-

str

 

server_name

-

str

 

timers

-

str

 

bytes_read

-

str

 

termination_state

-

str

 

actconn_feconn_beconn_srvconn_retries

-

str

 

server_queue

-

str

 

backend_queue

-

str

 

tr

-

str

 

status_code

-

str

 

method

-

str

 

url

-

str

 

protocol

-

str

 

rawSource

rawSource

 

str

✓

rawMessage

rawMessage

 

str

✓

hostchain

hostchain

 

str

✓

tag

tag

 

str

✓

proxy.haproxy.http

Field in union table

Field in source table

Field transformation

Type

Extra fields

Field in union table

Field in source table

Field transformation

Type

Extra fields

eventdate

eventdate

 

timestamp

 

environment

environment

 

str

 

application

application

 

str

 

clone

clone

 

str

 

source

-

str

 

message

message

 

str

 

server_date

server_date

 

str

 

machine

machine

 

str

 

pid

pid

 

str

 

source_ip

srcIp

str

 

source_ipv4

source_ipv4

 

ip4

 

source_port

source_port

 

str

 

accept_date

accept_date

 

str

 

frontend_name

frontend_name

 

str

 

backend_name

backend_name

 

str

 

server_name

server_name

 

str

 

timers

timers

 

str

 

bytes_read

bytes_read

 

str

 

termination_state

termination_state

 

str

 

actconn_feconn_beconn_srvconn_retries

actconn_feconn_beconn_srvconn_retries

 

str

 

server_queue

server_queue

 

str

 

backend_queue

backend_queue

 

str

 

tr

tr

 

str

 

status_code

status_code

 

str

 

method

method

 

str

 

url

url

 

str

 

protocol

protocol

 

str

 

rawSource

rawSource

 

str

✓

rawMessage

rawMessage

 

str

✓

hostchain

hostchain

 

str

✓

tag

tag

 

str

✓

proxy.haproxy.tcp

Field in union table

Field in source table

Field transformation

Type

Extra fields

Field in union table

Field in source table

Field transformation

Type

Extra fields

eventdate

eventdate

 

timestamp

 

environment

environment

 

str

 

application

application

 

str

 

clone

clone

 

str

 

source

-

str

 

message

message

 

str

 

server_date

server_date

 

str

 

machine

machine

 

str

 

pid

pid

 

str

 

source_ip

srcIp

str

 

source_ipv4

source_ipv4

 

ip4

 

source_port

source_port

 

str

 

accept_date

accept_date

 

str

 

frontend_name

frontend_name

 

str

 

backend_name

backend_name

 

str

 

server_name

server_name

 

str

 

timers

timers

 

str

 

bytes_read

bytes_read

 

str

 

termination_state

termination_state

 

str

 

actconn_feconn_beconn_srvconn_retries

actconn_feconn_beconn_srvconn_retries

 

str

 

server_queue

server_queue

 

str

 

backend_queue

backend_queue

 

str

 

tr

-

str

 

status_code

-

str

 

method

-

str

 

url

-

str

 

protocol

-

str

 

rawSource

rawSource

 

str

✓

rawMessage

rawMessage

 

str

✓

hostchain

hostchain

 

str

✓

tag

tag

 

str

✓