The following table shows the mapping between request characteristics in the format string (log items) and table column names, and gives output examples.
Log Item | Column Name | Output Example |
---|---|---|
%h | remote_host | 153.65.52.112 |
%a | remote_IP | 153.65.52.112 |
%A | local_IP | 153.65.52.112 |
%t | request_time | [22/Jun/2012:17:27:02 -0700] |
%b | bytes_sent_CLF | 512 |
%B | bytes_sent | 455 |
%O | bytes_sent_including_header | 512 |
%I | bytes_received_including_header | 512 |
%p | canonical_server_port | 80 |
%{canonical}p | canonical_server_port | 80 |
%{local}p | actual_server_port | 80 |
%{remote}p | actual_client_port | 7777 |
%P | process_ID | 8311 |
%k | live_connections | 2 |
%D | request_duration_microseconds | 312 |
%T | request_duration_seconds | 0 |
%U | requested_URL | /index.html |
%l | remote_log_name | |
%u | remote_user | |
%f | requested_file | |
%{VARNAME}i | request:VARNAME | |
%{Referer}i | Referer | |
%{VARNAME}o | reply:VARNAME | |
%{VARNAME}n | note:VARNAME | |
%{VARNAME}e | env:VARNAME | |
%{VARNAME}C | cookie:VARNAME | |
%V | server_name | |
%v | canonical_server_name | |
%L | log_ID | |
%H | protocol | HTTP/1.1 |
%m | method | GET |
%q | query | |
%X | connection_status | X = Connection aborted before the response completed. + = Connection may be kept alive after the response is sent. - = Connection closes after the response is sent. |
%r | request_line | |
%>s | final_status | 404 |
%<s | original_request_status | |
%s | original_request_status | |
%R | handler |