log
17 rows where remote_addr = "10.1.3.226" sorted by user_agent
This data as json, CSV (advanced)
Suggested facets: request, body_bytes_sent, referer, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
197 | 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 |
31 | 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 |
399 | 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 |
459 | 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 |
256 | 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 |
471 | 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 |
154 | 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 |
337 | 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 |
44 | 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 | 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 |
255 | 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 |
412 | 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 | 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 |
477 | 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 |
224 | 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 |
274 | 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 |
356 | 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 |
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 );