16 rows where remote_addr = "10.1.17.204" sorted by request_time descending

View and edit SQL

Suggested facets: request, status_code, user_agent

body_bytes_sent

remote_addr

  • 10.1.17.204 · 16
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
383 2021-08-05T19:17:08.636569+00:00 app[web.1]: measure#nginx.service=14.838 request="GET /search/?tag=tracemonkey&tag=firefox35&tag=video&tag=html5&tag=textshadow&tag=localstorage&tag=offlineresources&tag=browsers&month=6&year=2009 HTTP/1.1" status_code=200 request_id=4a3d7750-6101-4a9d-a2fa-ab6752e302cc remote_addr="10.1.17.204" forwarded_for="54.161.41.102, 172.70.34.15" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14054 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="14.838" upstream_response_time="14.840" upstream_connect_time="0.000" upstream_header_time="14.840"; 14.838 GET /search/?tag=tracemonkey&tag=firefox35&tag=video&tag=html5&tag=textshadow&tag=localstorage&tag=offlineresources&tag=browsers&month=6&year=2009 HTTP/1.1 200 4a3d7750-6101-4a9d-a2fa-ab6752e302cc 10.1.17.204 54.161.41.102, 172.70.34.15 http 1.1 vegur 14054 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 14.838 14.84 0.0 14.84
333 2021-08-05T19:16:04.693099+00:00 app[web.1]: measure#nginx.service=14.489 request="GET /search/?tag=textshadow&tag=offlineresources&tag=geolocation&tag=firefox&tag=tracemonkey&tag=audio&tag=webworkers&tag=canvas HTTP/1.1" status_code=200 request_id=fbf5b173-2123-49fe-81d9-458652d176a9 remote_addr="10.1.17.204" forwarded_for="54.161.41.102, 172.70.34.223" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12124 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="14.489" upstream_response_time="14.488" upstream_connect_time="0.000" upstream_header_time="14.488"; 14.489 GET /search/?tag=textshadow&tag=offlineresources&tag=geolocation&tag=firefox&tag=tracemonkey&tag=audio&tag=webworkers&tag=canvas HTTP/1.1 200 fbf5b173-2123-49fe-81d9-458652d176a9 10.1.17.204 54.161.41.102, 172.70.34.223 http 1.1 vegur 12124 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 14.489 14.488 0.0 14.488
453 2021-08-05T19:18:54.044727+00:00 app[web.1]: measure#nginx.service=13.893 request="GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=hashtables HTTP/1.1" status_code=200 request_id=2ea3056d-71b5-4643-822f-606514850dfe remote_addr="10.1.17.204" forwarded_for="167.114.100.201, 172.70.126.168" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6703 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="13.893" upstream_response_time="13.892" upstream_connect_time="0.000" upstream_header_time="13.892"; 13.893 GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=hashtables HTTP/1.1 200 2ea3056d-71b5-4643-822f-606514850dfe 10.1.17.204 167.114.100.201, 172.70.126.168 http 1.1 vegur 6703 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 13.893 13.892 0.0 13.892
30 2021-08-05T19:09:32.787665+00:00 app[web.1]: measure#nginx.service=7.406 request="GET /search/?tag=video&tag=firefox35&tag=json&tag=performance&tag=tracemonkey&tag=javascript&tag=localstorage&tag=browsers&tag=mozilla&type=blogmark&month=6&year=2009 HTTP/1.1" status_code=200 request_id=75657595-6577-49b1-9f7f-5d2239d6a026 remote_addr="10.1.17.204" forwarded_for="54.161.41.102, 172.70.34.41" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=15737 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="7.406" upstream_response_time="7.408" upstream_connect_time="0.000" upstream_header_time="7.408"; 7.406 GET /search/?tag=video&tag=firefox35&tag=json&tag=performance&tag=tracemonkey&tag=javascript&tag=localstorage&tag=browsers&tag=mozilla&type=blogmark&month=6&year=2009 HTTP/1.1 200 75657595-6577-49b1-9f7f-5d2239d6a026 10.1.17.204 54.161.41.102, 172.70.34.41 http 1.1 vegur 15737 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 7.406 7.408 0.0 7.408
328 2021-08-05T19:16:04.015131+00:00 app[web.1]: measure#nginx.service=7.357 request="GET /rss HTTP/1.1" status_code=404 request_id=05d13c50-697d-4461-9d4f-49fd293f4812 remote_addr="10.1.17.204" forwarded_for="34.147.114.27, 172.69.54.237" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=179 referer="-" user_agent="newspaper/0.2.8" request_time="7.357" upstream_response_time="7.356" upstream_connect_time="0.000" upstream_header_time="7.356"; 7.357 GET /rss HTTP/1.1 404 05d13c50-697d-4461-9d4f-49fd293f4812 10.1.17.204 34.147.114.27, 172.69.54.237 http 1.1 vegur 179 - newspaper/0.2.8 7.357 7.356 0.0 7.356
74 2021-08-05T19:10:41.533118+00:00 app[web.1]: measure#nginx.service=7.233 request="GET /search/?tag=html5&tag=browsers&tag=canvas&tag=fonts&tag=mozilla&tag=firefox&tag=json&tag=tracemonkey&tag=audio&type=blogmark HTTP/1.1" status_code=200 request_id=6ab11e0f-125b-4f1a-a2c2-a8a74d4fdb94 remote_addr="10.1.17.204" forwarded_for="54.161.41.102, 172.70.35.24" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12987 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="7.233" upstream_response_time="7.232" upstream_connect_time="0.000" upstream_header_time="7.232"; 7.233 GET /search/?tag=html5&tag=browsers&tag=canvas&tag=fonts&tag=mozilla&tag=firefox&tag=json&tag=tracemonkey&tag=audio&type=blogmark HTTP/1.1 200 6ab11e0f-125b-4f1a-a2c2-a8a74d4fdb94 10.1.17.204 54.161.41.102, 172.70.35.24 http 1.1 vegur 12987 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 7.233 7.232 0.0 7.232
349 2021-08-05T19:16:20.732525+00:00 app[web.1]: measure#nginx.service=5.529 request="GET /search/?tag=mozilla&tag=html5&tag=video&tag=geolocation&tag=audio&tag=json&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=f4d5d6ce-a73f-444a-970c-b18ad3097a9d remote_addr="10.1.17.204" forwarded_for="54.161.41.102, 172.70.34.43" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11564 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="5.529" upstream_response_time="5.528" upstream_connect_time="0.000" upstream_header_time="5.528"; 5.529 GET /search/?tag=mozilla&tag=html5&tag=video&tag=geolocation&tag=audio&tag=json&type=blogmark&year=2009 HTTP/1.1 200 f4d5d6ce-a73f-444a-970c-b18ad3097a9d 10.1.17.204 54.161.41.102, 172.70.34.43 http 1.1 vegur 11564 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 5.529 5.528 0.0 5.528
379 2021-08-05T19:17:04.502646+00:00 app[web.1]: measure#nginx.service=3.098 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=885ed3a0-a2c7-439a-9a79-98176847d8b7 remote_addr="10.1.17.204" forwarded_for="178.255.113.33, 162.158.134.87" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="NextCloud-News/1.0" request_time="3.098" upstream_response_time="3.096" upstream_connect_time="0.000" upstream_header_time="3.092"; 3.098 GET /atom/everything/ HTTP/1.1 200 885ed3a0-a2c7-439a-9a79-98176847d8b7 10.1.17.204 178.255.113.33, 162.158.134.87 http 1.1 vegur 155913 - NextCloud-News/1.0 3.098 3.096 0.0 3.092
38 2021-08-05T19:09:45.577451+00:00 app[web.1]: measure#nginx.service=3.017 request="GET /search/?tag=localstorage&tag=json&tag=canvas&tag=geolocation&tag=fonts&tag=offlineresources&tag=firefox35&tag=csstransforms&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=28419467-bb09-4a3b-91e3-2625bbc90ba4 remote_addr="10.1.17.204" forwarded_for="54.161.41.102, 172.70.34.143" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13883 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.017" upstream_response_time="3.016" upstream_connect_time="0.000" upstream_header_time="3.016"; 3.017 GET /search/?tag=localstorage&tag=json&tag=canvas&tag=geolocation&tag=fonts&tag=offlineresources&tag=firefox35&tag=csstransforms&type=blogmark&month=6 HTTP/1.1 200 28419467-bb09-4a3b-91e3-2625bbc90ba4 10.1.17.204 54.161.41.102, 172.70.34.143 http 1.1 vegur 13883 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.017 3.016 0.0 3.016
269 2021-08-05T19:15:19.296598+00:00 app[web.1]: measure#nginx.service=2.346 request="GET /search/?tag=async&tag=perlbal&tag=eventloop&tag=node HTTP/1.1" status_code=200 request_id=a6c80dcc-1120-40b8-bb5a-5b08a5b7176d remote_addr="10.1.17.204" forwarded_for="158.69.243.99, 172.70.126.68" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6601 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.346" upstream_response_time="2.347" upstream_connect_time="0.000" upstream_header_time="2.347"; 2.346 GET /search/?tag=async&tag=perlbal&tag=eventloop&tag=node HTTP/1.1 200 a6c80dcc-1120-40b8-bb5a-5b08a5b7176d 10.1.17.204 158.69.243.99, 172.70.126.68 http 1.1 vegur 6601 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.346 2.347 0.0 2.347
56 2021-08-05T19:10:16.110026+00:00 app[web.1]: measure#nginx.service=2.329 request="GET /search/?tag=mozilla&tag=video&tag=dragndrop&tag=crossdomain&tag=geolocation&tag=offlineresources&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=d0eab98c-ed43-4977-a32a-30d394971fa6 remote_addr="10.1.17.204" forwarded_for="54.161.41.102, 172.70.34.51" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12099 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.329" upstream_response_time="2.328" upstream_connect_time="0.000" upstream_header_time="2.328"; 2.329 GET /search/?tag=mozilla&tag=video&tag=dragndrop&tag=crossdomain&tag=geolocation&tag=offlineresources&type=blogmark&month=6 HTTP/1.1 200 d0eab98c-ed43-4977-a32a-30d394971fa6 10.1.17.204 54.161.41.102, 172.70.34.51 http 1.1 vegur 12099 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.329 2.328 0.0 2.328
34 2021-08-05T19:09:38.414636+00:00 app[web.1]: measure#nginx.service=1.955 request="GET /search/?tag=firefox35&tag=offlineresources&tag=mozilla&tag=csstransforms&tag=dragndrop&tag=canvas&tag=javascript&type=blogmark&month=6&year=2009 HTTP/1.1" status_code=200 request_id=cbff4482-9087-4703-bbb8-7357d7c59f6e remote_addr="10.1.17.204" forwarded_for="54.161.41.102, 172.70.34.153" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14170 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.955" upstream_response_time="1.956" upstream_connect_time="0.000" upstream_header_time="1.956"; 1.955 GET /search/?tag=firefox35&tag=offlineresources&tag=mozilla&tag=csstransforms&tag=dragndrop&tag=canvas&tag=javascript&type=blogmark&month=6&year=2009 HTTP/1.1 200 cbff4482-9087-4703-bbb8-7357d7c59f6e 10.1.17.204 54.161.41.102, 172.70.34.153 http 1.1 vegur 14170 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.955 1.956 0.0 1.956
303 2021-08-05T19:15:51.947931+00:00 app[web.1]: measure#nginx.service=0.415 request="GET /2008 HTTP/1.1" status_code=301 request_id=f4cc267d-75cb-4c86-a7f1-033d56ce3586 remote_addr="10.1.17.204" forwarded_for="34.147.114.27, 141.101.77.162" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.415" upstream_response_time="0.416" upstream_connect_time="0.000" upstream_header_time="0.416"; 0.415 GET /2008 HTTP/1.1 301 f4cc267d-75cb-4c86-a7f1-033d56ce3586 10.1.17.204 34.147.114.27, 141.101.77.162 http 1.1 vegur 0 - newspaper/0.2.8 0.415 0.416 0.0 0.416
232 2021-08-05T19:14:28.455994+00:00 app[web.1]: measure#nginx.service=0.279 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=710f5b89-211f-42bb-92cf-240f3bb5047a remote_addr="10.1.17.204" forwarded_for="79.147.57.124, 188.114.110.171" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) News Explorer/1.9" request_time="0.279" upstream_response_time="0.280" upstream_connect_time="0.000" upstream_header_time="0.272"; 0.279 GET /atom/everything/ HTTP/1.1 200 710f5b89-211f-42bb-92cf-240f3bb5047a 10.1.17.204 79.147.57.124, 188.114.110.171 http 1.1 vegur 155913 - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) News Explorer/1.9 0.279 0.28 0.0 0.272
106 2021-08-05T19:11:21.653819+00:00 app[web.1]: measure#nginx.service=0.272 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=20f1bb8e-0a06-4e91-a595-d1c958d7df6e remote_addr="10.1.17.204" forwarded_for="147.182.168.0, 172.70.110.145" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="NewsBlur Feed Fetcher - 555 subscribers - http://www.newsblur.com/site/5020414/simon-willisons-weblog (\x22Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.1 Safari/605.1.15\x22)" request_time="0.272" upstream_response_time="0.272" upstream_connect_time="0.000" upstream_header_time="0.268"; 0.272 GET /atom/everything/ HTTP/1.1 200 20f1bb8e-0a06-4e91-a595-d1c958d7df6e 10.1.17.204 147.182.168.0, 172.70.110.145 http 1.1 vegur 155913 - NewsBlur Feed Fetcher - 555 subscribers - http://www.newsblur.com/site/5020414/simon-willisons-weblog (\x22Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.1 Safari/605.1.15\x22) 0.272 0.272 0.0 0.268
160 2021-08-05T19:12:45.917045+00:00 app[web.1]: measure#nginx.service=0.160 request="GET /search/?q=django&tag=ljworld&type=blogmark&year=2008 HTTP/1.1" status_code=200 request_id=44744098-526c-4b85-802d-75d919bd40f9 remote_addr="10.1.17.204" forwarded_for="114.119.145.88, 162.158.167.213" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8304 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="0.160" upstream_response_time="0.160" upstream_connect_time="0.000" upstream_header_time="0.160"; 0.16 GET /search/?q=django&tag=ljworld&type=blogmark&year=2008 HTTP/1.1 200 44744098-526c-4b85-802d-75d919bd40f9 10.1.17.204 114.119.145.88, 162.158.167.213 http 1.1 vegur 8304 - 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) 0.16 0.16 0.0 0.16

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