9.1. CSV format



The statistics may be consulted either from the unix socket or from the HTTP page. Both means provide a CSV format whose fields follow. The first line begins with a sharp (‘#’) and has one word per comma-delimited field which represents the title of the column. All other lines starting at the second one use a classical CSV format using a comma as the delimiter, and the double quote (‘”‘) as an optional text delimiter, but only if the enclosed text is ambiguous (if it contains a quote or a comma).

The double-quote character (‘”‘) in the text is doubled (‘””‘), which is the format that most tools recognize. Please do not insert any column before these ones in order not to break tools which use hard-coded column positions.

In brackets after each field name are the types which may have a value for that field. The types are L (Listeners), F (Frontends), B (Backends), and S (Servers).

  1. pxname [LFBS] proxy name
  2. svname [LFBS] service name (FRONTEND for frontend, BACKEND for backend, any name for server/listener)
  3. qcur [..BS] current queued requests. For the backend this reports the number queued without a server assigned.
  4. qmax [..BS] max value of qcur
  5. scur [LFBS] current sessions
  6. smax [LFBS] max sessions
  7. slim [LFBS] configured session limit
  8. stot [LFBS] cumulative number of connections
  9. bin [LFBS] bytes in
  10. bout [LFBS] bytes out
  11. dreq [LFB.] requests denied because of security concerns.
    • For tcp this is because of a matched tcp-request content rule.
    • For http this is because of a matched http-request or tarpit rule.
  12. dresp [LFBS] responses denied because of security concerns.
  13. For http this is because of a matched http-request rule, or “option checkcache”.
  14. ereq [LF..] request errors. Some of the possible causes are:
    • early termination from the client, before the request has been sent.
    • read error from the client
    • client timeout
    • client closed connection
    • various bad requests from the client.
    • request was tarpitted.
  15. econ [..BS] number of requests that encountered an error trying to connect to a backend server. The backend stat is the sum of the stat for all servers of that backend, plus any connection errors not associated with a particular server (such as the backend having no active servers).
  16. eresp [..BS] response errors. srv_abrt will be counted here also.
    Some other errors are:

    • write error on the client socket (won’t be counted for the server stat)
    • failure applying filters to the response.
  17. wretr [..BS] number of times a connection to a server was retried.
  18. wredis [..BS] number of times a request was redispatched to another server. The server value counts the number of times that server was switched away from.
  19. status [LFBS] status (UP/DOWN/NOLB/MAINT/MAINT(via)…)
  20. weight [..BS] server weight (server), total weight (backend)
  21. act [..BS] server is active (server), number of active servers (backend)
  22. bck [..BS] server is backup (server), number of backup servers (backend)
  23. chkfail […S] number of failed checks. (Only counts checks failed when the server is up.)
  24. chkdown [..BS] number of UP->DOWN transitions. The backend counter counts transitions to the whole backend being down, rather than the sum of the counters for each server.
  25. lastchg [..BS] number of seconds since the last UP<->DOWN transition
  26. downtime [..BS] total downtime (in seconds). The value for the backend is the downtime for the whole backend, not the sum of the server downtime.
  27. qlimit […S] configured maxqueue for the server, or nothing in the value is 0 (default, meaning no limit)
  28. pid [LFBS] process id (0 for first instance, 1 for second, …)
  29. iid [LFBS] unique proxy id
  30. sid [L..S] server id (unique inside a proxy)
  31. throttle […S] current throttle percentage for the server, when slowstart is active, or no value if not in slowstart.
  32. lbtot [..BS] total number of times a server was selected, either for new sessions, or when re-dispatching. The server counter is the number of times that server was selected.
  33. tracked […S] id of proxy/server if tracking is enabled.
  34. type [LFBS] (0=frontend, 1=backend, 2=server, 3=socket/listener)
  35. rate [.FBS] number of sessions per second over last elapsed second
  36. rate_lim [.F..] configured limit on new sessions per second
  37. rate_max [.FBS] max number of new sessions per second
  38. check_status […S] status of last health check, one of:
    • UNK -> unknown
    • INI -> initializing
    • SOCKERR -> socket error
    • L4OK -> check passed on layer 4, no upper layers testing enabled
    • L4TMOUT -> layer 1-4 timeout
    • L4CON -> layer 1-4 connection problem, for example “Connection refused” (tcp rst) or “No route to host” (icmp)
    • L6OK -> check passed on layer 6
    • L6TOUT -> layer 6 (SSL) timeout
    • L6RSP -> layer 6 invalid response – protocol error
    • L7OK -> check passed on layer 7
    • L7OKC -> check conditionally passed on layer 7, for example 404 with disable-on-404
    • L7TOUT -> layer 7 (HTTP/SMTP) timeout
    • L7RSP -> layer 7 invalid response – protocol error
    • L7STS -> layer 7 response error, for example HTTP 5xx
  39. check_code […S] layer5-7 code, if available
  40. check_duration […S] time in ms took to finish last health check
  41. hrsp_1xx [.FBS] http responses with 1xx code
  42. hrsp_2xx [.FBS] http responses with 2xx code
  43. hrsp_3xx [.FBS] http responses with 3xx code
  44. hrsp_4xx [.FBS] http responses with 4xx code
  45. hrsp_5xx [.FBS] http responses with 5xx code
  46. hrsp_other [.FBS] http responses with other codes (protocol error)
  47. hanafail […S] failed health checks details
  48. req_rate [.F..] HTTP requests per second over last elapsed second
  49. req_rate_max [.F..] max number of HTTP requests per second observed
  50. req_tot [.F..] total number of HTTP requests received
  51. cli_abrt [..BS] number of data transfers aborted by the client
  52. srv_abrt [..BS] number of data transfers aborted by the server (inc. in eresp)
  53. comp_in [.FB.] number of HTTP response bytes fed to the compressor
  54. comp_out [.FB.] number of HTTP response bytes emitted by the compressor
  55. comp_byp [.FB.] number of bytes that bypassed the HTTP compressor (CPU/BW limit)
  56. comp_rsp [.FB.] number of HTTP responses that were compressed
  57. lastsess [..BS] number of seconds since last session assigned to server/backend
  58. last_chk […S] last health check contents or textual error
  59. last_agt […S] last agent check contents or textual error
  60. qtime [..BS] the average queue time in ms over the 1024 last requests
  61. ctime [..BS] the average connect time in ms over the 1024 last requests
  62. rtime [..BS] the average response time in ms over the 1024 last requests (0 for TCP)
  63. ttime [..BS] the average total session time in ms over the 1024 last requests
Share Button

Leave a Reply