17 rows where remote_addr = "10.1.3.226"

View and edit SQL

Suggested facets: request, body_bytes_sent, referer, user_agent

remote_addr

  • 10.1.3.226 · 17
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
31 2021-08-05T19:09:32.833352+00:00 app[web.1]: measure#nginx.service=0.328 request="GET /search/?year=2008&month=6&tag=basecamp HTTP/1.1" status_code=200 request_id=b74ef974-52f8-49ce-92d7-92e76b287165 remote_addr="10.1.3.226" forwarded_for="114.119.152.149, 162.158.166.166" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6280 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.328" upstream_response_time="0.328" upstream_connect_time="0.000" upstream_header_time="0.328"; 0.328 GET /search/?year=2008&month=6&tag=basecamp HTTP/1.1 200 b74ef974-52f8-49ce-92d7-92e76b287165 10.1.3.226 114.119.152.149, 162.158.166.166 http 1.1 vegur 6280 - 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.328 0.328 0.0 0.328
44 2021-08-05T19:09:55.625157+00:00 app[web.1]: measure#nginx.service=6.484 request="GET /search/?tag=json&tag=localstorage&tag=firefox35&tag=video&tag=fonts&tag=geolocation&tag=textshadow&tag=firefox&tag=offlineresources&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=c8f6d3e5-98b5-42c4-bd4a-6c944274ee0c remote_addr="10.1.3.226" forwarded_for="54.161.41.102, 172.70.34.101" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14624 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="6.484" upstream_response_time="6.484" upstream_connect_time="0.000" upstream_header_time="6.484"; 6.484 GET /search/?tag=json&tag=localstorage&tag=firefox35&tag=video&tag=fonts&tag=geolocation&tag=textshadow&tag=firefox&tag=offlineresources&type=blogmark&month=6 HTTP/1.1 200 c8f6d3e5-98b5-42c4-bd4a-6c944274ee0c 10.1.3.226 54.161.41.102, 172.70.34.101 http 1.1 vegur 14624 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 6.484 6.484 0.0 6.484
65 2021-08-05T19:10:25.897948+00:00 app[web.1]: measure#nginx.service=2.962 request="GET /search/?tag=firefox&tag=localstorage&tag=crossdomain&tag=dragndrop&tag=video&tag=html5&tag=tracemonkey&tag=performance&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=ea41354b-6201-4cad-9567-9416d318bff8 remote_addr="10.1.3.226" forwarded_for="54.161.41.102, 172.70.35.74" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13972 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.962" upstream_response_time="2.960" upstream_connect_time="0.000" upstream_header_time="2.960"; 2.962 GET /search/?tag=firefox&tag=localstorage&tag=crossdomain&tag=dragndrop&tag=video&tag=html5&tag=tracemonkey&tag=performance&year=2009&type=blogmark HTTP/1.1 200 ea41354b-6201-4cad-9567-9416d318bff8 10.1.3.226 54.161.41.102, 172.70.35.74 http 1.1 vegur 13972 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.962 2.96 0.0 2.96
154 2021-08-05T19:12:38.291955+00:00 app[web.1]: measure#nginx.service=0.279 request="GET /search/?tag=async&tag=perlbal HTTP/1.1" status_code=200 request_id=02f1c764-66be-4ca2-ade9-6f7d691489b4 remote_addr="10.1.3.226" forwarded_for="158.69.243.99, 172.70.126.134" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5776 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.279" upstream_response_time="0.280" upstream_connect_time="0.000" upstream_header_time="0.280"; 0.279 GET /search/?tag=async&tag=perlbal HTTP/1.1 200 02f1c764-66be-4ca2-ade9-6f7d691489b4 10.1.3.226 158.69.243.99, 172.70.126.134 http 1.1 vegur 5776 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.279 0.28 0.0 0.28
197 2021-08-05T19:13:42.914062+00:00 app[web.1]: measure#nginx.service=2.464 request="GET / HTTP/1.1" status_code=200 request_id=0b2bedbe-f9bf-4ccb-80a5-6360fccf3bd8 remote_addr="10.1.3.226" forwarded_for="34.71.236.85, 172.70.130.27" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=108602 referer="http://simonwillison.net/" user_agent="Go-http-client/2.0" request_time="2.464" upstream_response_time="2.464" upstream_connect_time="0.000" upstream_header_time="2.464"; 2.464 GET / HTTP/1.1 200 0b2bedbe-f9bf-4ccb-80a5-6360fccf3bd8 10.1.3.226 34.71.236.85, 172.70.130.27 http 1.1 vegur 108602 http://simonwillison.net/ Go-http-client/2.0 2.464 2.464 0.0 2.464
224 2021-08-05T19:14:18.551893+00:00 app[web.1]: measure#nginx.service=1.980 request="GET /tags/projects/ HTTP/1.1" status_code=200 request_id=812b6003-2ed8-4984-b31f-9172da409c7d remote_addr="10.1.3.226" forwarded_for="207.46.13.87, 108.162.245.224" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=33823 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.980" upstream_response_time="1.980" upstream_connect_time="0.000" upstream_header_time="1.980"; 1.98 GET /tags/projects/ HTTP/1.1 200 812b6003-2ed8-4984-b31f-9172da409c7d 10.1.3.226 207.46.13.87, 108.162.245.224 http 1.1 vegur 33823 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 1.98 1.98 0.0 1.98
255 2021-08-05T19:15:08.573089+00:00 app[web.1]: measure#nginx.service=6.698 request="GET /search/?tag=firefox35&tag=audio&tag=fonts&tag=webworkers&tag=dragndrop&tag=canvas&tag=offlineresources&month=6 HTTP/1.1" status_code=200 request_id=8f496ff4-b1c1-4a22-8908-d02b958ccb1a remote_addr="10.1.3.226" forwarded_for="54.161.41.102, 172.70.34.29" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11822 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="6.698" upstream_response_time="6.700" upstream_connect_time="0.000" upstream_header_time="6.700"; 6.698 GET /search/?tag=firefox35&tag=audio&tag=fonts&tag=webworkers&tag=dragndrop&tag=canvas&tag=offlineresources&month=6 HTTP/1.1 200 8f496ff4-b1c1-4a22-8908-d02b958ccb1a 10.1.3.226 54.161.41.102, 172.70.34.29 http 1.1 vegur 11822 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 6.698 6.7 0.0 6.7
256 2021-08-05T19:15:08.816829+00:00 app[web.1]: measure#nginx.service=1.890 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=b75dea83-7ccb-4e34-a848-a37542d48a43 remote_addr="10.1.3.226" forwarded_for="2a00:23c7:9f0e:ca00:2105:5019:4eb8:8810, 162.158.92.96" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:89.0) Gecko/20100101 Firefox/89.0" request_time="1.890" upstream_response_time="1.892" upstream_connect_time="0.000" upstream_header_time="1.888"; 1.89 GET /atom/everything/ HTTP/1.1 200 b75dea83-7ccb-4e34-a848-a37542d48a43 10.1.3.226 2a00:23c7:9f0e:ca00:2105:5019:4eb8:8810, 162.158.92.96 http 1.1 vegur 155913 - Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:89.0) Gecko/20100101 Firefox/89.0 1.89 1.892 0.0 1.888
274 2021-08-05T19:15:25.162779+00:00 app[web.1]: measure#nginx.service=0.230 request="GET /search/?tag=ssh&tag=douglasbowman&year=2005 HTTP/1.1" status_code=200 request_id=89776c18-3dc3-40ce-8c58-e856f0dfcca5 remote_addr="10.1.3.226" forwarded_for="13.66.139.0, 108.162.246.8" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5654 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.230" upstream_response_time="0.228" upstream_connect_time="0.000" upstream_header_time="0.228"; 0.23 GET /search/?tag=ssh&tag=douglasbowman&year=2005 HTTP/1.1 200 89776c18-3dc3-40ce-8c58-e856f0dfcca5 10.1.3.226 13.66.139.0, 108.162.246.8 http 1.1 vegur 5654 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 0.23 0.228 0.0 0.228
337 2021-08-05T19:16:14.618817+00:00 app[web.1]: measure#nginx.service=9.135 request="GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=yarivsadan HTTP/1.1" status_code=200 request_id=c4c8d024-60d0-48d4-9a6f-9627c8d95c29 remote_addr="10.1.3.226" forwarded_for="167.114.100.201, 172.70.126.94" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6758 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="9.135" upstream_response_time="9.132" upstream_connect_time="0.000" upstream_header_time="9.132"; 9.135 GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=yarivsadan HTTP/1.1 200 c4c8d024-60d0-48d4-9a6f-9627c8d95c29 10.1.3.226 167.114.100.201, 172.70.126.94 http 1.1 vegur 6758 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 9.135 9.132 0.0 9.132
356 2021-08-05T19:16:28.723575+00:00 app[web.1]: measure#nginx.service=0.293 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=6fc278c6-7bb9-47f8-a992-9b4249f88aff remote_addr="10.1.3.226" forwarded_for="167.71.26.162, 172.70.114.104" 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.293" upstream_response_time="0.296" upstream_connect_time="0.000" upstream_header_time="0.288"; 0.293 GET /atom/everything/ HTTP/1.1 200 6fc278c6-7bb9-47f8-a992-9b4249f88aff 10.1.3.226 167.71.26.162, 172.70.114.104 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.293 0.296 0.0 0.288
399 2021-08-05T19:17:29.717055+00:00 app[web.1]: measure#nginx.service=0.118 request="GET /search/?tag=flickrplaces&year=2008&page=1&month=1 HTTP/1.1" status_code=200 request_id=2aa2e65e-0573-40f6-99e8-d8396ee7cb42 remote_addr="10.1.3.226" forwarded_for="114.119.144.85, 172.70.147.75" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7172 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.118" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; 0.118 GET /search/?tag=flickrplaces&year=2008&page=1&month=1 HTTP/1.1 200 2aa2e65e-0573-40f6-99e8-d8396ee7cb42 10.1.3.226 114.119.144.85, 172.70.147.75 http 1.1 vegur 7172 - 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.118 0.12 0.0 0.12
412 2021-08-05T19:17:50.127633+00:00 app[web.1]: measure#nginx.service=3.110 request="GET /search/?tag=browsers&tag=dragndrop&tag=video&tag=localstorage&tag=json&tag=textshadow&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=42ad2eb7-0994-4c31-a155-95e11b13e20a remote_addr="10.1.3.226" forwarded_for="54.161.41.102, 172.70.34.123" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11949 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.110" upstream_response_time="3.112" upstream_connect_time="0.000" upstream_header_time="3.112"; 3.11 GET /search/?tag=browsers&tag=dragndrop&tag=video&tag=localstorage&tag=json&tag=textshadow&year=2009&type=blogmark HTTP/1.1 200 42ad2eb7-0994-4c31-a155-95e11b13e20a 10.1.3.226 54.161.41.102, 172.70.34.123 http 1.1 vegur 11949 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.11 3.112 0.0 3.112
455 2021-08-05T19:19:01.764423+00:00 app[web.1]: measure#nginx.service=12.689 request="GET /search/?tag=audio&tag=webworkers&tag=dragndrop&tag=json&tag=html5&tag=csstransforms&tag=tracemonkey&tag=crossdomain&type=blogmark&year=2009&month=6 HTTP/1.1" status_code=200 request_id=49b44b46-a797-45fe-9ab1-23b9bea35266 remote_addr="10.1.3.226" forwarded_for="54.161.41.102, 172.70.34.131" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14732 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="12.689" upstream_response_time="12.688" upstream_connect_time="0.000" upstream_header_time="12.688"; 12.689 GET /search/?tag=audio&tag=webworkers&tag=dragndrop&tag=json&tag=html5&tag=csstransforms&tag=tracemonkey&tag=crossdomain&type=blogmark&year=2009&month=6 HTTP/1.1 200 49b44b46-a797-45fe-9ab1-23b9bea35266 10.1.3.226 54.161.41.102, 172.70.34.131 http 1.1 vegur 14732 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 12.689 12.688 0.0 12.688
459 2021-08-05T19:19:14.954421+00:00 app[web.1]: measure#nginx.service=20.716 request="GET /search/?q=javascript&type=blogmark&month=1&tag=bayeux HTTP/1.1" status_code=200 request_id=f8d7cc1f-fc7c-4eeb-8a6f-697691402263 remote_addr="10.1.3.226" forwarded_for="114.119.155.233, 172.70.147.164" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8006 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="20.716" upstream_response_time="20.716" upstream_connect_time="0.000" upstream_header_time="20.716"; 20.716 GET /search/?q=javascript&type=blogmark&month=1&tag=bayeux HTTP/1.1 200 f8d7cc1f-fc7c-4eeb-8a6f-697691402263 10.1.3.226 114.119.155.233, 172.70.147.164 http 1.1 vegur 8006 - 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) 20.716 20.716 0.0 20.716
471 2021-08-05T19:19:20.720129+00:00 app[web.1]: measure#nginx.service=13.586 request="GET /2021/Jul/17/standing-out/?utm_source=hackernewsletter&utm_medium=email&utm_term=fav HTTP/1.1" status_code=200 request_id=57762b18-c286-41dc-a579-6c33e5bfb176 remote_addr="10.1.3.226" forwarded_for="73.129.8.119, 172.70.34.145" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8317 referer="-" user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0" request_time="13.586" upstream_response_time="13.588" upstream_connect_time="0.000" upstream_header_time="13.588"; 13.586 GET /2021/Jul/17/standing-out/?utm_source=hackernewsletter&utm_medium=email&utm_term=fav HTTP/1.1 200 57762b18-c286-41dc-a579-6c33e5bfb176 10.1.3.226 73.129.8.119, 172.70.34.145 http 1.1 vegur 8317 - Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0 13.586 13.588 0.0 13.588
477 2021-08-05T19:19:42.249234+00:00 app[web.1]: measure#nginx.service=23.170 request="GET /search/?tag=textshadow&tag=geolocation&tag=csstransforms&tag=crossdomain&tag=audio&tag=fonts&tag=video&tag=json&tag=offlineresources&type=blogmark HTTP/1.1" status_code=200 request_id=f2918b7a-cd88-447a-ab3c-3cd5530c19a0 remote_addr="10.1.3.226" forwarded_for="54.161.41.102, 172.70.35.40" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13779 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="23.170" upstream_response_time="23.168" upstream_connect_time="0.000" upstream_header_time="23.168"; 23.17 GET /search/?tag=textshadow&tag=geolocation&tag=csstransforms&tag=crossdomain&tag=audio&tag=fonts&tag=video&tag=json&tag=offlineresources&type=blogmark HTTP/1.1 200 f2918b7a-cd88-447a-ab3c-3cd5530c19a0 10.1.3.226 54.161.41.102, 172.70.35.40 http 1.1 vegur 13779 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 23.17 23.168 0.0 23.168

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