16 rows where remote_addr = "10.1.7.41"

View and edit SQL

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

remote_addr

  • 10.1.7.41 · 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
62 2021-08-05T19:10:20.745582+00:00 app[web.1]: measure#nginx.service=0.193 request="GET /search/?q=postgresql&tag=http&year=2009 HTTP/1.1" status_code=200 request_id=93f5785a-cefe-456e-982d-2e8415841260 remote_addr="10.1.7.41" forwarded_for="114.119.145.210, 162.158.167.226" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7565 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.193" upstream_response_time="0.192" upstream_connect_time="0.000" upstream_header_time="0.192"; 0.193 GET /search/?q=postgresql&tag=http&year=2009 HTTP/1.1 200 93f5785a-cefe-456e-982d-2e8415841260 10.1.7.41 114.119.145.210, 162.158.167.226 http 1.1 vegur 7565 - 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.193 0.192 0.0 0.192
71 2021-08-05T19:10:37.795816+00:00 app[web.1]: measure#nginx.service=0.221 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=86676758-1ef2-438f-8e27-87dd41a310bb remote_addr="10.1.7.41" forwarded_for="213.219.145.12, 162.158.92.97" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101 Firefox/90.0" request_time="0.221" upstream_response_time="0.224" upstream_connect_time="0.000" upstream_header_time="0.216"; 0.221 GET /atom/everything/ HTTP/1.1 200 86676758-1ef2-438f-8e27-87dd41a310bb 10.1.7.41 213.219.145.12, 162.158.92.97 http 1.1 vegur 155913 - Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101 Firefox/90.0 0.221 0.224 0.0 0.216
101 2021-08-05T19:11:14.471730+00:00 app[web.1]: measure#nginx.service=0.116 request="GET /2021/Jul/10/behind-the-scenes-aws-lambda/ HTTP/1.1" status_code=200 request_id=606a4e1f-e5ff-4710-b488-68a679e247a6 remote_addr="10.1.7.41" forwarded_for="54.36.148.177, 141.101.105.235" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=4200 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="0.116" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; 0.116 GET /2021/Jul/10/behind-the-scenes-aws-lambda/ HTTP/1.1 200 606a4e1f-e5ff-4710-b488-68a679e247a6 10.1.7.41 54.36.148.177, 141.101.105.235 http 1.1 vegur 4200 - Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) 0.116 0.12 0.0 0.12
107 2021-08-05T19:11:25.996627+00:00 app[web.1]: measure#nginx.service=4.064 request="GET /search/?tag=fonts&tag=firefox35&tag=canvas&tag=tracemonkey&tag=html5&tag=textshadow&tag=mozilla&type=blogmark HTTP/1.1" status_code=200 request_id=640a5a7b-fb9b-4da9-85fe-e8bfca3a1c21 remote_addr="10.1.7.41" forwarded_for="54.161.41.102, 172.70.34.57" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11653 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.064" upstream_response_time="4.064" upstream_connect_time="0.000" upstream_header_time="4.064"; 4.064 GET /search/?tag=fonts&tag=firefox35&tag=canvas&tag=tracemonkey&tag=html5&tag=textshadow&tag=mozilla&type=blogmark HTTP/1.1 200 640a5a7b-fb9b-4da9-85fe-e8bfca3a1c21 10.1.7.41 54.161.41.102, 172.70.34.57 http 1.1 vegur 11653 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.064 4.064 0.0 4.064
139 2021-08-05T19:12:12.365505+00:00 app[web.1]: measure#nginx.service=0.185 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=74ba1b14-7842-42a9-9da3-1e588eb8f639 remote_addr="10.1.7.41" forwarded_for="178.124.210.226, 162.158.202.241" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Tiny Tiny RSS/r10198.6d8f2221b (Unsupported) (http://tt-rss.org/)" request_time="0.185" upstream_response_time="0.184" upstream_connect_time="0.000" upstream_header_time="0.180"; 0.185 GET /atom/everything/ HTTP/1.1 200 74ba1b14-7842-42a9-9da3-1e588eb8f639 10.1.7.41 178.124.210.226, 162.158.202.241 http 1.1 vegur 155913 - Tiny Tiny RSS/r10198.6d8f2221b (Unsupported) (http://tt-rss.org/) 0.185 0.184 0.0 0.18
142 2021-08-05T19:12:17.724782+00:00 app[web.1]: measure#nginx.service=0.145 request="GET /search/?page=1&year=2009&tag=bebo HTTP/1.1" status_code=200 request_id=4e493fa3-affa-431a-b9bd-3f6e280ae625 remote_addr="10.1.7.41" forwarded_for="114.119.145.79, 172.70.142.234" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5514 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.145" upstream_response_time="0.144" upstream_connect_time="0.000" upstream_header_time="0.144"; 0.145 GET /search/?page=1&year=2009&tag=bebo HTTP/1.1 200 4e493fa3-affa-431a-b9bd-3f6e280ae625 10.1.7.41 114.119.145.79, 172.70.142.234 http 1.1 vegur 5514 - 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.145 0.144 0.0 0.144
165 2021-08-05T19:12:53.551512+00:00 app[web.1]: measure#nginx.service=2.295 request="GET /search/?tag=performance&tag=localstorage&tag=firefox&tag=video&tag=firefox35&tag=browsers&type=blogmark&month=6&year=2009 HTTP/1.1" status_code=200 request_id=e8e3dcf6-3ded-42a1-bfbb-3f61d4fca514 remote_addr="10.1.7.41" forwarded_for="54.161.41.102, 172.70.34.57" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12902 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.295" upstream_response_time="2.296" upstream_connect_time="0.000" upstream_header_time="2.296"; 2.295 GET /search/?tag=performance&tag=localstorage&tag=firefox&tag=video&tag=firefox35&tag=browsers&type=blogmark&month=6&year=2009 HTTP/1.1 200 e8e3dcf6-3ded-42a1-bfbb-3f61d4fca514 10.1.7.41 54.161.41.102, 172.70.34.57 http 1.1 vegur 12902 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.295 2.296 0.0 2.296
178 2021-08-05T19:13:24.245907+00:00 app[web.1]: measure#nginx.service=8.344 request="GET /search/?tag=firefox&tag=performance&tag=mozilla&tag=crossdomain&tag=textshadow&tag=audio HTTP/1.1" status_code=200 request_id=838d3b28-052c-4f84-860c-12ab5b33bbd7 remote_addr="10.1.7.41" forwarded_for="54.161.41.102, 172.70.34.45" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10214 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="8.344" upstream_response_time="8.344" upstream_connect_time="0.000" upstream_header_time="8.344"; 8.344 GET /search/?tag=firefox&tag=performance&tag=mozilla&tag=crossdomain&tag=textshadow&tag=audio HTTP/1.1 200 838d3b28-052c-4f84-860c-12ab5b33bbd7 10.1.7.41 54.161.41.102, 172.70.34.45 http 1.1 vegur 10214 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 8.344 8.344 0.0 8.344
237 2021-08-05T19:14:37.519495+00:00 app[web.1]: measure#nginx.service=2.377 request="GET /2021/Jul/23/the-tyranny-of-spreadsheets/ HTTP/1.1" status_code=200 request_id=3afae2a7-5d99-4b50-aba3-66bfbda42012 remote_addr="10.1.7.41" forwarded_for="95.130.216.20, 162.158.183.125" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=4266 referer="http://simonwillison.net/" user_agent="Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E)" request_time="2.377" upstream_response_time="2.376" upstream_connect_time="0.000" upstream_header_time="2.376"; 2.377 GET /2021/Jul/23/the-tyranny-of-spreadsheets/ HTTP/1.1 200 3afae2a7-5d99-4b50-aba3-66bfbda42012 10.1.7.41 95.130.216.20, 162.158.183.125 http 1.1 vegur 4266 http://simonwillison.net/ Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E) 2.377 2.376 0.0 2.376
267 2021-08-05T19:15:17.638144+00:00 app[web.1]: measure#nginx.service=0.581 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=d2a732d9-9cef-4178-912d-b798faca9618 remote_addr="10.1.7.41" forwarded_for="89.145.167.82, 141.101.104.186" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="FeedHQ/0.2 (https://github.com/feedhq/feedhq; 1 subscriber; https://github.com/feedhq/feedhq/wiki/fetcher; like FeedFetcher-Google)" request_time="0.581" upstream_response_time="0.580" upstream_connect_time="0.000" upstream_header_time="0.576"; 0.581 GET /atom/everything/ HTTP/1.1 200 d2a732d9-9cef-4178-912d-b798faca9618 10.1.7.41 89.145.167.82, 141.101.104.186 http 1.1 vegur 155913 - FeedHQ/0.2 (https://github.com/feedhq/feedhq; 1 subscriber; https://github.com/feedhq/feedhq/wiki/fetcher; like FeedFetcher-Google) 0.581 0.58 0.0 0.576
334 2021-08-05T19:16:04.826184+00:00 app[web.1]: measure#nginx.service=2.696 request="GET /2003/Oct/7/myVisa/ HTTP/1.1" status_code=200 request_id=788ac09e-232d-4583-b088-53c1dd935ad7 remote_addr="10.1.7.41" forwarded_for="85.206.162.216, 162.158.183.153" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10075 referer="https://simonwillison.net/2003/Oct/7/myVisa/" user_agent="Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36" request_time="2.696" upstream_response_time="2.696" upstream_connect_time="0.000" upstream_header_time="2.696"; 2.696 GET /2003/Oct/7/myVisa/ HTTP/1.1 200 788ac09e-232d-4583-b088-53c1dd935ad7 10.1.7.41 85.206.162.216, 162.158.183.153 http 1.1 vegur 10075 https://simonwillison.net/2003/Oct/7/myVisa/ Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36 2.696 2.696 0.0 2.696
357 2021-08-05T19:16:30.892621+00:00 app[web.1]: measure#nginx.service=0.165 request="GET /2009/Dec/23/ HTTP/1.1" status_code=200 request_id=cb40936e-a8b6-4983-8eef-e5c530dd5e31 remote_addr="10.1.7.41" forwarded_for="17.121.113.162, 108.162.215.71" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6867 referer="-" user_agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.1 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot)" request_time="0.165" upstream_response_time="0.164" upstream_connect_time="0.000" upstream_header_time="0.164"; 0.165 GET /2009/Dec/23/ HTTP/1.1 200 cb40936e-a8b6-4983-8eef-e5c530dd5e31 10.1.7.41 17.121.113.162, 108.162.215.71 http 1.1 vegur 6867 - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.1 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot) 0.165 0.164 0.0 0.164
401 2021-08-05T19:17:30.805095+00:00 app[web.1]: measure#nginx.service=0.268 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=3e364ce1-ce51-4cbd-a314-a539a6f31c31 remote_addr="10.1.7.41" forwarded_for="139.162.187.171, 162.158.92.97" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="http://simonwillison.net/atom/everything/" user_agent="Gofeed/1.0" request_time="0.268" upstream_response_time="0.268" upstream_connect_time="0.000" upstream_header_time="0.264"; 0.268 GET /atom/everything/ HTTP/1.1 200 3e364ce1-ce51-4cbd-a314-a539a6f31c31 10.1.7.41 139.162.187.171, 162.158.92.97 http 1.1 vegur 155913 http://simonwillison.net/atom/everything/ Gofeed/1.0 0.268 0.268 0.0 0.264
402 2021-08-05T19:17:32.734200+00:00 app[web.1]: measure#nginx.service=2.282 request="GET /search/?tag=javascript&tag=json&tag=geolocation&tag=canvas&tag=firefox&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=897fe5c0-d05d-417a-82de-8a5c03caf398 remote_addr="10.1.7.41" forwarded_for="54.161.41.102, 172.70.35.36" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11050 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.282" upstream_response_time="2.280" upstream_connect_time="0.000" upstream_header_time="2.280"; 2.282 GET /search/?tag=javascript&tag=json&tag=geolocation&tag=canvas&tag=firefox&type=blogmark&year=2009 HTTP/1.1 200 897fe5c0-d05d-417a-82de-8a5c03caf398 10.1.7.41 54.161.41.102, 172.70.35.36 http 1.1 vegur 11050 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.282 2.28 0.0 2.28
405 2021-08-05T19:17:36.989712+00:00 app[web.1]: measure#nginx.service=3.488 request="GET /search/?tag=tracemonkey&tag=offlineresources&tag=canvas&tag=geolocation&tag=csstransforms&tag=audio&tag=localstorage&tag=dragndrop&type=blogmark HTTP/1.1" status_code=200 request_id=1463209b-1205-4a73-b917-dda3c50f48ac remote_addr="10.1.7.41" forwarded_for="54.161.41.102, 172.70.34.225" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13271 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.488" upstream_response_time="3.488" upstream_connect_time="0.000" upstream_header_time="3.488"; 3.488 GET /search/?tag=tracemonkey&tag=offlineresources&tag=canvas&tag=geolocation&tag=csstransforms&tag=audio&tag=localstorage&tag=dragndrop&type=blogmark HTTP/1.1 200 1463209b-1205-4a73-b917-dda3c50f48ac 10.1.7.41 54.161.41.102, 172.70.34.225 http 1.1 vegur 13271 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.488 3.488 0.0 3.488
450 2021-08-05T19:18:53.150609+00:00 app[web.1]: measure#nginx.service=11.058 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=e47d692a-32c2-469b-ab6f-ac5768dfdb5d remote_addr="10.1.7.41" forwarded_for="167.71.89.133, 172.70.110.171" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6; +feeder.co) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36" request_time="11.058" upstream_response_time="11.056" upstream_connect_time="0.000" upstream_header_time="11.052"; 11.058 GET /atom/entries/ HTTP/1.1 200 e47d692a-32c2-469b-ab6f-ac5768dfdb5d 10.1.7.41 167.71.89.133, 172.70.110.171 http 1.1 vegur 207454 - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6; +feeder.co) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36 11.058 11.056 0.0 11.052

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