20 rows where remote_addr = "10.1.14.97"

View and edit SQL

Suggested facets: request, status_code, body_bytes_sent, referer, user_agent

remote_addr

  • 10.1.14.97 · 20
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
15 2021-08-05T19:09:06.062159+00:00 app[web.1]: measure#nginx.service=2.767 request="GET /search/?tag=html5&tag=firefox35&tag=mozilla&tag=csstransforms&tag=crossdomain&tag=geolocation&tag=javascript&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=40cdaed4-aa21-4e2b-804e-edf056d27f54 remote_addr="10.1.14.97" forwarded_for="54.161.41.102, 172.70.34.63" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12921 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.767" upstream_response_time="2.768" upstream_connect_time="0.000" upstream_header_time="2.768"; 2.767 GET /search/?tag=html5&tag=firefox35&tag=mozilla&tag=csstransforms&tag=crossdomain&tag=geolocation&tag=javascript&type=blogmark&month=6 HTTP/1.1 200 40cdaed4-aa21-4e2b-804e-edf056d27f54 10.1.14.97 54.161.41.102, 172.70.34.63 http 1.1 vegur 12921 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.767 2.768 0.0 2.768
35 2021-08-05T19:09:39.228837+00:00 app[web.1]: measure#nginx.service=0.070 request="GET /search/?page=1&year=2008&tag=freebase&type=blogmark HTTP/1.1" status_code=200 request_id=2481137a-456c-4fb5-ae6e-fbbe6dc99065 remote_addr="10.1.14.97" forwarded_for="114.119.131.33, 172.70.143.2" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10213 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.070" upstream_response_time="0.072" upstream_connect_time="0.000" upstream_header_time="0.072"; 0.07 GET /search/?page=1&year=2008&tag=freebase&type=blogmark HTTP/1.1 200 2481137a-456c-4fb5-ae6e-fbbe6dc99065 10.1.14.97 114.119.131.33, 172.70.143.2 http 1.1 vegur 10213 - 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.07 0.072 0.0 0.072
55 2021-08-05T19:10:12.822022+00:00 app[web.1]: measure#nginx.service=2.088 request="GET /search/?tag=localstorage&tag=json&tag=firefox&tag=textshadow&tag=csstransforms&tag=crossdomain&tag=dragndrop&type=blogmark HTTP/1.1" status_code=200 request_id=efefa989-60a9-442d-9d42-ef679adafea4 remote_addr="10.1.14.97" forwarded_for="54.161.41.102, 172.70.34.235" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12095 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.088" upstream_response_time="2.088" upstream_connect_time="0.000" upstream_header_time="2.088"; 2.088 GET /search/?tag=localstorage&tag=json&tag=firefox&tag=textshadow&tag=csstransforms&tag=crossdomain&tag=dragndrop&type=blogmark HTTP/1.1 200 efefa989-60a9-442d-9d42-ef679adafea4 10.1.14.97 54.161.41.102, 172.70.34.235 http 1.1 vegur 12095 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.088 2.088 0.0 2.088
79 2021-08-05T19:10:43.610553+00:00 app[web.1]: measure#nginx.service=4.317 request="GET /search/?tag=performance&tag=canvas&tag=tracemonkey&tag=video&tag=dragndrop&tag=mozilla&month=6&year=2009 HTTP/1.1" status_code=200 request_id=05d4ebcb-6d1b-4d11-b3d1-a0557f73a8d8 remote_addr="10.1.14.97" forwarded_for="54.161.41.102, 172.70.34.241" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11893 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.317" upstream_response_time="4.316" upstream_connect_time="0.000" upstream_header_time="4.316"; 4.317 GET /search/?tag=performance&tag=canvas&tag=tracemonkey&tag=video&tag=dragndrop&tag=mozilla&month=6&year=2009 HTTP/1.1 200 05d4ebcb-6d1b-4d11-b3d1-a0557f73a8d8 10.1.14.97 54.161.41.102, 172.70.34.241 http 1.1 vegur 11893 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.317 4.316 0.0 4.316
81 2021-08-05T19:10:44.572808+00:00 app[web.1]: measure#nginx.service=0.232 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=0850950a-f011-47d4-970d-a04b0457282d remote_addr="10.1.14.97" forwarded_for="98.37.79.147, 172.69.35.27" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:92.0) Gecko/20100101 Firefox/92.0" request_time="0.232" upstream_response_time="0.232" upstream_connect_time="0.000" upstream_header_time="0.228"; 0.232 GET /atom/everything/ HTTP/1.1 200 0850950a-f011-47d4-970d-a04b0457282d 10.1.14.97 98.37.79.147, 172.69.35.27 http 1.1 vegur 155913 - Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:92.0) Gecko/20100101 Firefox/92.0 0.232 0.232 0.0 0.228
86 2021-08-05T19:10:51.228055+00:00 app[web.1]: measure#nginx.service=0.657 request="GET /search/?page=1&tag=xml&tag=json&tag=javascript HTTP/1.1" status_code=200 request_id=d836b69d-ea45-4c9e-a177-d6076ae0a85e remote_addr="10.1.14.97" forwarded_for="207.46.13.98, 108.162.245.222" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13640 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.657" upstream_response_time="0.660" upstream_connect_time="0.000" upstream_header_time="0.660"; 0.657 GET /search/?page=1&tag=xml&tag=json&tag=javascript HTTP/1.1 200 d836b69d-ea45-4c9e-a177-d6076ae0a85e 10.1.14.97 207.46.13.98, 108.162.245.222 http 1.1 vegur 13640 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 0.657 0.66 0.0 0.66
125 2021-08-05T19:11:51.836146+00:00 app[web.1]: measure#nginx.service=5.148 request="GET /search/?tag=firefox35&tag=mozilla&tag=audio&tag=geolocation&tag=javascript&tag=fonts&tag=offlineresources&tag=textshadow&tag=localstorage&type=blogmark HTTP/1.1" status_code=200 request_id=28f5c9ed-7666-4397-93bc-aedcf13c4dd2 remote_addr="10.1.14.97" forwarded_for="54.161.41.102, 172.70.34.221" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13959 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="5.148" upstream_response_time="5.148" upstream_connect_time="0.000" upstream_header_time="5.148"; 5.148 GET /search/?tag=firefox35&tag=mozilla&tag=audio&tag=geolocation&tag=javascript&tag=fonts&tag=offlineresources&tag=textshadow&tag=localstorage&type=blogmark HTTP/1.1 200 28f5c9ed-7666-4397-93bc-aedcf13c4dd2 10.1.14.97 54.161.41.102, 172.70.34.221 http 1.1 vegur 13959 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 5.148 5.148 0.0 5.148
155 2021-08-05T19:12:40.326403+00:00 app[web.1]: measure#nginx.service=0.287 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=47658064-8a64-4727-99c5-ba8297bfba34 remote_addr="10.1.14.97" forwarded_for="147.182.164.48, 162.158.62.147" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="NewsBlur Feed Fetcher - 555 subscribers - http://www.newsblur.com/site/790/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.287" upstream_response_time="0.284" upstream_connect_time="0.000" upstream_header_time="0.276"; 0.287 GET /atom/everything/ HTTP/1.1 200 47658064-8a64-4727-99c5-ba8297bfba34 10.1.14.97 147.182.164.48, 162.158.62.147 http 1.1 vegur 155913 - NewsBlur Feed Fetcher - 555 subscribers - http://www.newsblur.com/site/790/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.287 0.284 0.0 0.276
161 2021-08-05T19:12:51.728014+00:00 app[web.1]: measure#nginx.service=10.466 request="GET /search/?tag=geolocation&tag=audio&tag=csstransforms&tag=mozilla&tag=browsers&tag=firefox&tag=html5&tag=tracemonkey&tag=firefox35&tag=canvas&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=c1f4c293-10ce-4b42-85e2-c94daf85c6cb remote_addr="10.1.14.97" forwarded_for="54.161.41.102, 172.70.34.17" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=15389 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="10.466" upstream_response_time="10.468" upstream_connect_time="0.000" upstream_header_time="10.468"; 10.466 GET /search/?tag=geolocation&tag=audio&tag=csstransforms&tag=mozilla&tag=browsers&tag=firefox&tag=html5&tag=tracemonkey&tag=firefox35&tag=canvas&type=blogmark&month=6 HTTP/1.1 200 c1f4c293-10ce-4b42-85e2-c94daf85c6cb 10.1.14.97 54.161.41.102, 172.70.34.17 http 1.1 vegur 15389 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 10.466 10.468 0.0 10.468
194 2021-08-05T19:13:39.013356+00:00 app[web.1]: measure#nginx.service=0.362 request="GET / HTTP/1.1" status_code=200 request_id=a8039f6c-abda-47e2-a00b-aa791aa49710 remote_addr="10.1.14.97" forwarded_for="18.215.244.20, 172.70.34.138" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=108619 referer="-" user_agent="Buck/2.2; (+https://app.hypefactors.com/media-monitoring/about.html)" request_time="0.362" upstream_response_time="0.364" upstream_connect_time="0.000" upstream_header_time="0.364"; 0.362 GET / HTTP/1.1 200 a8039f6c-abda-47e2-a00b-aa791aa49710 10.1.14.97 18.215.244.20, 172.70.34.138 http 1.1 vegur 108619 - Buck/2.2; (+https://app.hypefactors.com/media-monitoring/about.html) 0.362 0.364 0.0 0.364
236 2021-08-05T19:14:37.395704+00:00 app[web.1]: measure#nginx.service=2.634 request="GET /search/?page=1&tag=safari&year=2010&month=2 HTTP/1.1" status_code=200 request_id=dd3cc574-bbb4-406a-ad14-704bb8c42b84 remote_addr="10.1.14.97" forwarded_for="114.119.157.22, 172.70.142.115" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7438 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="2.634" upstream_response_time="2.636" upstream_connect_time="0.000" upstream_header_time="2.636"; 2.634 GET /search/?page=1&tag=safari&year=2010&month=2 HTTP/1.1 200 dd3cc574-bbb4-406a-ad14-704bb8c42b84 10.1.14.97 114.119.157.22, 172.70.142.115 http 1.1 vegur 7438 - 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) 2.634 2.636 0.0 2.636
261 2021-08-05T19:15:12.436279+00:00 app[web.1]: measure#nginx.service=0.192 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=8e26764a-fba9-4163-81c7-ce01c4029266 remote_addr="10.1.14.97" forwarded_for="12.248.67.166, 172.69.71.73" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="NetNewsWire (RSS Reader; https://netnewswire.com/)" request_time="0.192" upstream_response_time="0.192" upstream_connect_time="0.000" upstream_header_time="0.184"; 0.192 GET /atom/everything/ HTTP/1.1 200 8e26764a-fba9-4163-81c7-ce01c4029266 10.1.14.97 12.248.67.166, 172.69.71.73 http 1.1 vegur 155913 - NetNewsWire (RSS Reader; https://netnewswire.com/) 0.192 0.192 0.0 0.184
263 2021-08-05T19:15:16.287887+00:00 app[web.1]: measure#nginx.service=0.099 request="GET /search/?page=1&type=blogmark&year=2020&month=9&tag=numpy HTTP/1.1" status_code=200 request_id=9da5a260-b0b1-46e1-9486-dcc876c78e62 remote_addr="10.1.14.97" forwarded_for="114.119.154.13, 172.70.142.239" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6304 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.099" upstream_response_time="0.100" upstream_connect_time="0.000" upstream_header_time="0.100"; 0.099 GET /search/?page=1&type=blogmark&year=2020&month=9&tag=numpy HTTP/1.1 200 9da5a260-b0b1-46e1-9486-dcc876c78e62 10.1.14.97 114.119.154.13, 172.70.142.239 http 1.1 vegur 6304 - 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.099 0.1 0.0 0.1
282 2021-08-05T19:15:34.738291+00:00 app[web.1]: measure#nginx.service=1.332 request="GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=rails HTTP/1.1" status_code=200 request_id=9920fc18-c414-4a6d-a0bc-b85705f1bc93 remote_addr="10.1.14.97" forwarded_for="167.114.100.201, 172.70.126.184" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6668 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="1.332" upstream_response_time="1.332" upstream_connect_time="0.000" upstream_header_time="1.332"; 1.332 GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=rails HTTP/1.1 200 9920fc18-c414-4a6d-a0bc-b85705f1bc93 10.1.14.97 167.114.100.201, 172.70.126.184 http 1.1 vegur 6668 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 1.332 1.332 0.0 1.332
286 2021-08-05T19:15:40.739325+00:00 app[web.1]: measure#nginx.service=0.066 request="GET /swn-entries HTTP/1.1" status_code=301 request_id=e74c87aa-4cba-4814-bc90-d9ba36a7dde0 remote_addr="10.1.14.97" forwarded_for="108.2.161.198, 172.70.110.183" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="NetNewsWire (RSS Reader; https://netnewswire.com/)" request_time="0.066" upstream_response_time="0.068" upstream_connect_time="0.000" upstream_header_time="0.064"; 0.066 GET /swn-entries HTTP/1.1 301 e74c87aa-4cba-4814-bc90-d9ba36a7dde0 10.1.14.97 108.2.161.198, 172.70.110.183 http 1.1 vegur 5 - NetNewsWire (RSS Reader; https://netnewswire.com/) 0.066 0.068 0.0 0.064
310 2021-08-05T19:15:52.786427+00:00 app[web.1]: measure#nginx.service=0.777 request="GET /2021 HTTP/1.1" status_code=301 request_id=80a9e842-b196-41f6-8420-033f94dca2bb remote_addr="10.1.14.97" forwarded_for="34.147.114.27, 172.69.54.166" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.777" upstream_response_time="0.776" upstream_connect_time="0.000" upstream_header_time="0.776"; 0.777 GET /2021 HTTP/1.1 301 80a9e842-b196-41f6-8420-033f94dca2bb 10.1.14.97 34.147.114.27, 172.69.54.166 http 1.1 vegur 0 - newspaper/0.2.8 0.777 0.776 0.0 0.776
442 2021-08-05T19:18:43.759765+00:00 app[web.1]: measure#nginx.service=15.400 request="GET /2021/Jul/28/baked-data/ HTTP/1.1" status_code=200 request_id=3343b7f9-5484-44bc-8748-37ec635bd94c remote_addr="10.1.14.97" forwarded_for="68.58.215.192, 172.70.130.249" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=20872 referer="https://news.ycombinator.com/" user_agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101 Firefox/91.0" request_time="15.400" upstream_response_time="15.400" upstream_connect_time="0.000" upstream_header_time="15.400"; 15.4 GET /2021/Jul/28/baked-data/ HTTP/1.1 200 3343b7f9-5484-44bc-8748-37ec635bd94c 10.1.14.97 68.58.215.192, 172.70.130.249 http 1.1 vegur 20872 https://news.ycombinator.com/ Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101 Firefox/91.0 15.4 15.4 0.0 15.4
452 2021-08-05T19:18:53.433688+00:00 app[web.1]: measure#nginx.service=10.790 request="GET /search/?page=1&type=blogmark&tag=cron&year=2009 HTTP/1.1" status_code=200 request_id=552e081d-5556-4122-af43-42355397e750 remote_addr="10.1.14.97" forwarded_for="114.119.141.146, 172.70.142.199" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5732 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="10.790" upstream_response_time="10.792" upstream_connect_time="0.000" upstream_header_time="10.792"; 10.79 GET /search/?page=1&type=blogmark&tag=cron&year=2009 HTTP/1.1 200 552e081d-5556-4122-af43-42355397e750 10.1.14.97 114.119.141.146, 172.70.142.199 http 1.1 vegur 5732 - 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) 10.79 10.792 0.0 10.792
461 2021-08-05T19:19:15.373123+00:00 app[web.1]: measure#nginx.service=20.028 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=bdd7d61d-caeb-4fe3-93ba-73aa03df9230 remote_addr="10.1.14.97" forwarded_for="94.130.182.203, 162.158.91.132" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app)" request_time="20.028" upstream_response_time="20.028" upstream_connect_time="0.000" upstream_header_time="20.024"; 20.028 GET /atom/links/ HTTP/1.1 200 bdd7d61d-caeb-4fe3-93ba-73aa03df9230 10.1.14.97 94.130.182.203, 162.158.91.132 http 1.1 vegur 16609 - Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app) 20.028 20.028 0.0 20.024
475 2021-08-05T19:19:24.618831+00:00 app[web.1]: measure#nginx.service=15.539 request="GET /search/?tag=textshadow&tag=offlineresources&tag=geolocation&tag=browsers&tag=firefox&tag=localstorage&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=023e5ef1-db57-447c-89cf-9f3293f74642 remote_addr="10.1.14.97" forwarded_for="54.161.41.102, 172.70.34.127" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12269 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="15.539" upstream_response_time="15.536" upstream_connect_time="0.000" upstream_header_time="15.536"; 15.539 GET /search/?tag=textshadow&tag=offlineresources&tag=geolocation&tag=browsers&tag=firefox&tag=localstorage&type=blogmark&month=6 HTTP/1.1 200 023e5ef1-db57-447c-89cf-9f3293f74642 10.1.14.97 54.161.41.102, 172.70.34.127 http 1.1 vegur 12269 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 15.539 15.536 0.0 15.536

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