log
2 rows where body_bytes_sent = 318 sorted by request_time descending
This data as json, CSV (advanced)
Link | rowid | line | measure#nginx.service | request | status_code | request_id | remote_addr | forwarded_for | forwarded_proto | via | body_bytes_sent | referer | user_agent | request_time ▲ | upstream_response_time | upstream_connect_time | upstream_header_time |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
444 | 444 | 2021-08-05T19:18:44.529329+00:00 app[web.1]: measure#nginx.service=14.894 request="GET /favicon.ico HTTP/1.1" status_code=200 request_id=581f3ca8-90b9-4290-9ee9-256df22d70a6 remote_addr="10.1.12.255" forwarded_for="46.183.103.17,66.249.93.2, 108.162.229.233" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=318 referer="-" user_agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 Google Favicon" request_time="14.894" upstream_response_time="14.892" upstream_connect_time="0.000" upstream_header_time="14.892"; | 14.894 | GET /favicon.ico HTTP/1.1 | 200 | 581f3ca8-90b9-4290-9ee9-256df22d70a6 | 10.1.12.255 | 46.183.103.17,66.249.93.2, 108.162.229.233 | http | 1.1 vegur | 318 | - | Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 Google Favicon | 14.894 | 14.892 | 0.0 | 14.892 |
425 | 425 | 2021-08-05T19:18:11.711215+00:00 app[web.1]: measure#nginx.service=4.430 request="GET /favicon.ico HTTP/1.1" status_code=200 request_id=cf2e3b51-48a7-49e1-a894-6a2daad9fa09 remote_addr="10.1.12.255" forwarded_for="74.102.98.235, 172.70.110.129" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=318 referer="-" user_agent="com.slack.slackmdm/21.07.20 (iPhone; iOS 14.7.1; Scale/3.00)" request_time="4.430" upstream_response_time="4.428" upstream_connect_time="0.000" upstream_header_time="4.428"; | 4.43 | GET /favicon.ico HTTP/1.1 | 200 | cf2e3b51-48a7-49e1-a894-6a2daad9fa09 | 10.1.12.255 | 74.102.98.235, 172.70.110.129 | http | 1.1 vegur | 318 | - | com.slack.slackmdm/21.07.20 (iPhone; iOS 14.7.1; Scale/3.00) | 4.43 | 4.428 | 0.0 | 4.428 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "log" ( [line] TEXT, [measure#nginx.service] FLOAT, [request] TEXT, [status_code] INTEGER, [request_id] TEXT, [remote_addr] TEXT, [forwarded_for] TEXT, [forwarded_proto] TEXT, [via] TEXT, [body_bytes_sent] INTEGER, [referer] TEXT, [user_agent] TEXT, [request_time] FLOAT, [upstream_response_time] FLOAT, [upstream_connect_time] FLOAT, [upstream_header_time] FLOAT );