9.1. CSV format

  1. The statistics may be consulted either from the unix socket or from the HTTP
  2. page. Both means provide a CSV format whose fields follow. The first line
  3. begins with a sharp ('#') and has one word per comma-delimited field which
  4. represents the title of the column. All other lines starting at the second one
  5. use a classical CSV format using a comma as the delimiter, and the double quote
  6. ('"') as an optional text delimiter, but only if the enclosed text is ambiguous
  7. (if it contains a quote or a comma). The double-quote character ('"') in the
  8. text is doubled ('""'), which is the format that most tools recognize. Please
  9. do not insert any column before these ones in order not to break tools which
  10. use hard-coded column positions.
  11.  
  12. In brackets after each field name are the types which may have a value for
  13. that field. The types are L (Listeners), F (Frontends), B (Backends), and
  14. S (Servers).
  15.  
  16.   0. pxname [LFBS]: proxy name
  17.   1. svname [LFBS]: service name (FRONTEND for frontend, BACKEND for backend,
  18.      any name for server/listener)
  19.   2. qcur [..BS]: current queued requests. For the backend this reports the
  20.      number queued without a server assigned.
  21.   3. qmax [..BS]: max value of qcur
  22.   4. scur [LFBS]: current sessions
  23.   5. smax [LFBS]: max sessions
  24.   6. slim [LFBS]: configured session limit
  25.   7. stot [LFBS]: cumulative number of sessions
  26.   8. bin [LFBS]: bytes in
  27.   9. bout [LFBS]: bytes out
  28.  10. dreq [LFB.]: requests denied because of security concerns.
  29.      - For tcp this is because of a matched tcp-request content rule.
  30.      - For http this is because of a matched http-request or tarpit rule.
  31.  11. dresp [LFBS]: responses denied because of security concerns.
  32.      - For http this is because of a matched http-request rule, or
  33.        "option checkcache".
  34.  12. ereq [LF..]: request errors. Some of the possible causes are:
  35.      - early termination from the client, before the request has been sent.
  36.      - read error from the client
  37.      - client timeout
  38.      - client closed connection
  39.      - various bad requests from the client.
  40.      - request was tarpitted.
  41.  13. econ [..BS]: number of requests that encountered an error trying to
  42.      connect to a backend server. The backend stat is the sum of the stat
  43.      for all servers of that backend, plus any connection errors not
  44.      associated with a particular server (such as the backend having no
  45.      active servers).
  46.  14. eresp [..BS]: response errors. srv_abrt will be counted here also.
  47.      Some other errors are:
  48.      - write error on the client socket (won't be counted for the server stat)
  49.      - failure applying filters to the response.
  50.  15. wretr [..BS]: number of times a connection to a server was retried.
  51.  16. wredis [..BS]: number of times a request was redispatched to another
  52.      server. The server value counts the number of times that server was
  53.      switched away from.
  54.  17. status [LFBS]: status (UP/DOWN/NOLB/MAINT/MAINT(via)/MAINT(resolution)...)
  55.  18. weight [..BS]: total weight (backend), server weight (server)
  56.  19. act [..BS]: number of active servers (backend), server is active (server)
  57.  20. bck [..BS]: number of backup servers (backend), server is backup (server)
  58.  21. chkfail [...S]: number of failed checks. (Only counts checks failed when
  59.      the server is up.)
  60.  22. chkdown [..BS]: number of UP->DOWN transitions. The backend counter counts
  61.      transitions to the whole backend being down, rather than the sum of the
  62.      counters for each server.
  63.  23. lastchg [..BS]: number of seconds since the last UP<->DOWN transition
  64.  24. downtime [..BS]: total downtime (in seconds). The value for the backend
  65.      is the downtime for the whole backend, not the sum of the server downtime.
  66.  25. qlimit [...S]: configured maxqueue for the server, or nothing in the
  67.      value is 0 (default, meaning no limit)
  68.  26. pid [LFBS]: process id (0 for first instance, 1 for second, ...)
  69.  27. iid [LFBS]: unique proxy id
  70.  28. sid [L..S]: server id (unique inside a proxy)
  71.  29. throttle [...S]: current throttle percentage for the server, when
  72.      slowstart is active, or no value if not in slowstart.
  73.  30. lbtot [..BS]: total number of times a server was selected, either for new
  74.      sessions, or when re-dispatching. The server counter is the number
  75.      of times that server was selected.
  76.  31. tracked [...S]: id of proxy/server if tracking is enabled.
  77.  32. type [LFBS]: (0=frontend, 1=backend, 2=server, 3=socket/listener)
  78.  33. rate [.FBS]: number of sessions per second over last elapsed second
  79.  34. rate_lim [.F..]: configured limit on new sessions per second
  80.  35. rate_max [.FBS]: max number of new sessions per second
  81.  36. check_status [...S]: status of last health check, one of:
  82.         UNK     -> unknown
  83.         INI     -> initializing
  84.         SOCKERR -> socket error
  85.         L4OK    -> check passed on layer 4, no upper layers testing enabled
  86.         L4TOUT  -> layer 1-4 timeout
  87.         L4CON   -> layer 1-4 connection problem, for example
  88.                    "Connection refused" (tcp rst) or "No route to host" (icmp)
  89.         L6OK    -> check passed on layer 6
  90.         L6TOUT  -> layer 6 (SSL) timeout
  91.         L6RSP   -> layer 6 invalid response - protocol error
  92.         L7OK    -> check passed on layer 7
  93.         L7OKC   -> check conditionally passed on layer 7, for example 404 with
  94.                    disable-on-404
  95.         L7TOUT  -> layer 7 (HTTP/SMTP) timeout
  96.         L7RSP   -> layer 7 invalid response - protocol error
  97.         L7STS   -> layer 7 response error, for example HTTP 5xx
  98.      Notice: If a check is currently running, the last known status will be
  99.      reported, prefixed with "* ". e. g. "* L7OK".
  100.  37. check_code [...S]: layer5-7 code, if available
  101.  38. check_duration [...S]: time in ms took to finish last health check
  102.  39. hrsp_1xx [.FBS]: http responses with 1xx code
  103.  40. hrsp_2xx [.FBS]: http responses with 2xx code
  104.  41. hrsp_3xx [.FBS]: http responses with 3xx code
  105.  42. hrsp_4xx [.FBS]: http responses with 4xx code
  106.  43. hrsp_5xx [.FBS]: http responses with 5xx code
  107.  44. hrsp_other [.FBS]: http responses with other codes (protocol error)
  108.  45. hanafail [...S]: failed health checks details
  109.  46. req_rate [.F..]: HTTP requests per second over last elapsed second
  110.  47. req_rate_max [.F..]: max number of HTTP requests per second observed
  111.  48. req_tot [.FB.]: total number of HTTP requests received
  112.  49. cli_abrt [..BS]: number of data transfers aborted by the client
  113.  50. srv_abrt [..BS]: number of data transfers aborted by the server
  114.      (inc. in eresp)
  115.  51. comp_in [.FB.]: number of HTTP response bytes fed to the compressor
  116.  52. comp_out [.FB.]: number of HTTP response bytes emitted by the compressor
  117.  53. comp_byp [.FB.]: number of bytes that bypassed the HTTP compressor
  118.      (CPU/BW limit)
  119.  54. comp_rsp [.FB.]: number of HTTP responses that were compressed
  120.  55. lastsess [..BS]: number of seconds since last session assigned to
  121.      server/backend
  122.  56. last_chk [...S]: last health check contents or textual error
  123.  57. last_agt [...S]: last agent check contents or textual error
  124.  58. qtime [..BS]: the average queue time in ms over the 1024 last requests
  125.  59. ctime [..BS]: the average connect time in ms over the 1024 last requests
  126.  60. rtime [..BS]: the average response time in ms over the 1024 last requests
  127.      (0 for TCP)
  128.  61. ttime [..BS]: the average total session time in ms over the 1024 last
  129.      requests
  130.  62. agent_status [...S]: status of last agent check, one of:
  131.         UNK     -> unknown
  132.         INI     -> initializing
  133.         SOCKERR -> socket error
  134.         L4OK    -> check passed on layer 4, no upper layers testing enabled
  135.         L4TOUT  -> layer 1-4 timeout
  136.         L4CON   -> layer 1-4 connection problem, for example
  137.                    "Connection refused" (tcp rst) or "No route to host" (icmp)
  138.         L7OK    -> agent reported "up"
  139.         L7STS   -> agent reported "fail", "stop", or "down"
  140.  63. agent_code [...S]: numeric code reported by agent if any (unused for now)
  141.  64. agent_duration [...S]: time in ms taken to finish last check
  142.  65. check_desc [...S]: short human-readable description of check_status
  143.  66. agent_desc [...S]: short human-readable description of agent_status
  144.  67. check_rise [...S]: server's "rise" parameter used by checks
  145.  68. check_fall [...S]: server's "fall" parameter used by checks
  146.  69. check_health [...S]: server's health check value between 0 and rise+fall-1
  147.  70. agent_rise [...S]: agent's "rise" parameter, normally 1
  148.  71. agent_fall [...S]: agent's "fall" parameter, normally 1
  149.  72. agent_health [...S]: agent's health parameter, between 0 and rise+fall-1
  150.  73. addr [L..S]: address:port or "unix". IPv6 has brackets around the address.
  151.  74: cookie [..BS]: server's cookie value or backend's cookie name
  152.  75: mode [LFBS]: proxy mode (tcp, http, health, unknown)
  153.  76: algo [..B.]: load balancing algorithm
  154.  77: conn_rate [.F..]: number of connections over the last elapsed second
  155.  78: conn_rate_max [.F..]: highest known conn_rate
  156.  79: conn_tot [.F..]: cumulative number of connections
  157.  80: intercepted [.FB.]: cum. number of intercepted requests (monitor, stats)
  158.  81: dcon [LF..]: requests denied by "tcp-request connection" rules
  159.  82: dses [LF..]: requests denied by "tcp-request session" rules
  160.  83: wrew [LFBS]: cumulative number of failed header rewriting warnings
  161.  84: connect [..BS]: cumulative number of connection establishment attempts
  162.  85: reuse [..BS]: cumulative number of connection reuses
  163.  86: cache_lookups [.FB.]: cumulative number of cache lookups
  164.  87: cache_hits [.FB.]: cumulative number of cache hits
  165.  88: srv_icur [...S]: current number of idle connections available for reuse
  166.  89: src_ilim [...S]: limit on the number of available idle connections
  167.  90. qtime_max [..BS]: the maximum observed queue time in ms
  168.  91. ctime_max [..BS]: the maximum observed connect time in ms
  169.  92. rtime_max [..BS]: the maximum observed response time in ms (0 for TCP)
  170.  93. ttime_max [..BS]: the maximum observed total session time in ms