log
16 rows where remote_addr = "10.1.7.41" sorted by remote_addr
This data as json, CSV (advanced)
Suggested facets: request, forwarded_for, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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
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 );