log
16 rows where remote_addr = "10.1.17.204" sorted by forwarded_proto
This data as json, CSV (advanced)
Suggested facets: request, status_code, body_bytes_sent, user_agent
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30 | 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 |
34 | 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 |
38 | 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 |
56 | 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 |
74 | 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 |
106 | 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 | 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 |
232 | 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 |
269 | 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 |
303 | 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 |
328 | 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 |
333 | 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 |
349 | 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 | 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 |
383 | 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 |
453 | 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 |
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 );