log

2 rows where body_bytes_sent = 5882 sorted by request_time descending

✎ View and edit SQL

This data as json, CSV (advanced)

status_code ✖

body_bytes_sent ✖

  • 5882 · 2 ✖
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
223 223 2021-08-05T19:14:18.163742+00:00 app[web.1]: measure#nginx.service=4.494 request="GET /search/?q=django&tag=grahamdumpleton&year=2008 HTTP/1.1" status_code=200 request_id=609b918c-da29-49c2-b257-a5cb0a00adcb remote_addr="10.1.55.92" forwarded_for="114.119.137.91, 172.70.143.119" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5882 referer="-" user_agent="Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)" request_time="4.494" upstream_response_time="4.496" upstream_connect_time="0.000" upstream_header_time="4.496"; 4.494 GET /search/?q=django&tag=grahamdumpleton&year=2008 HTTP/1.1 200 609b918c-da29-49c2-b257-a5cb0a00adcb 10.1.55.92 114.119.137.91, 172.70.143.119 http 1.1 vegur 5882 - Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot) 4.494 4.496 0.0 4.496
429 429 2021-08-05T19:18:14.262866+00:00 app[web.1]: measure#nginx.service=3.164 request="GET /search/?q=javascript&year=2008&tag=erlang HTTP/1.1" status_code=200 request_id=9cca56df-1939-4b54-9a35-590a118f1042 remote_addr="10.1.7.130" forwarded_for="114.119.151.153, 172.70.143.4" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5882 referer="-" user_agent="Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)" request_time="3.164" upstream_response_time="3.164" upstream_connect_time="0.000" upstream_header_time="3.164"; 3.164 GET /search/?q=javascript&year=2008&tag=erlang HTTP/1.1 200 9cca56df-1939-4b54-9a35-590a118f1042 10.1.7.130 114.119.151.153, 172.70.143.4 http 1.1 vegur 5882 - Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot) 3.164 3.164 0.0 3.164

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);