27 rows where remote_addr = "10.1.94.69" sorted by request_time descending

View and edit SQL

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

upstream_response_time

remote_addr

  • 10.1.94.69 · 27
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
480 2021-08-05T19:19:43.766503+00:00 app[web.1]: measure#nginx.service=19.408 request="GET /search/?page=1&year=2019&tag=genetics&month=9 HTTP/1.1" status_code=200 request_id=ddac726d-e5d9-4d02-9c0f-5aa214bbe766 remote_addr="10.1.94.69" forwarded_for="114.119.147.73, 172.70.143.12" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8505 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="19.408" upstream_response_time="19.408" upstream_connect_time="0.000" upstream_header_time="19.408"; 19.408 GET /search/?page=1&year=2019&tag=genetics&month=9 HTTP/1.1 200 ddac726d-e5d9-4d02-9c0f-5aa214bbe766 10.1.94.69 114.119.147.73, 172.70.143.12 http 1.1 vegur 8505 - 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) 19.408 19.408 0.0 19.408
441 2021-08-05T19:18:43.670499+00:00 app[web.1]: measure#nginx.service=18.878 request="GET /search/?tag=cassandra&tag=digg&tag=nosql HTTP/1.1" status_code=200 request_id=47bf3ddf-0b88-4e51-8f22-f1131304b056 remote_addr="10.1.94.69" forwarded_for="13.66.139.0, 162.158.107.218" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5385 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="18.878" upstream_response_time="18.876" upstream_connect_time="0.000" upstream_header_time="18.876"; 18.878 GET /search/?tag=cassandra&tag=digg&tag=nosql HTTP/1.1 200 47bf3ddf-0b88-4e51-8f22-f1131304b056 10.1.94.69 13.66.139.0, 162.158.107.218 http 1.1 vegur 5385 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 18.878 18.876 0.0 18.876
462 2021-08-05T19:19:15.597358+00:00 app[web.1]: measure#nginx.service=16.844 request="GET /tags/yelp/ HTTP/1.1" status_code=200 request_id=6a44e4f1-98c8-4126-8210-9624e343b8e9 remote_addr="10.1.94.69" forwarded_for="54.36.148.58, 141.101.104.51" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8121 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="16.844" upstream_response_time="16.844" upstream_connect_time="0.000" upstream_header_time="16.844"; 16.844 GET /tags/yelp/ HTTP/1.1 200 6a44e4f1-98c8-4126-8210-9624e343b8e9 10.1.94.69 54.36.148.58, 141.101.104.51 http 1.1 vegur 8121 - Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) 16.844 16.844 0.0 16.844
202 2021-08-05T19:13:51.542130+00:00 app[web.1]: measure#nginx.service=11.483 request="GET /search/?tag=fonts&tag=audio&tag=textshadow&tag=geolocation&tag=firefox&tag=csstransforms&tag=mozilla&tag=javascript&tag=browsers&tag=tracemonkey&year=2009&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=976b2e5c-6d2a-4159-81ab-76b083218fd7 remote_addr="10.1.94.69" forwarded_for="54.161.41.102, 172.70.35.80" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16818 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="11.483" upstream_response_time="11.484" upstream_connect_time="0.000" upstream_header_time="11.484"; 11.483 GET /search/?tag=fonts&tag=audio&tag=textshadow&tag=geolocation&tag=firefox&tag=csstransforms&tag=mozilla&tag=javascript&tag=browsers&tag=tracemonkey&year=2009&type=blogmark&month=6 HTTP/1.1 200 976b2e5c-6d2a-4159-81ab-76b083218fd7 10.1.94.69 54.161.41.102, 172.70.35.80 http 1.1 vegur 16818 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 11.483 11.484 0.0 11.484
430 2021-08-05T19:18:16.569723+00:00 app[web.1]: measure#nginx.service=9.085 request="GET /search/?tag=fonts&tag=firefox35&tag=localstorage&tag=audio&tag=csstransforms&tag=json&tag=crossdomain&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=14947da4-de3c-4e7f-9a77-afa53ccc9af5 remote_addr="10.1.94.69" forwarded_for="54.161.41.102, 172.70.34.177" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12676 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="9.085" upstream_response_time="9.084" upstream_connect_time="0.000" upstream_header_time="9.084"; 9.085 GET /search/?tag=fonts&tag=firefox35&tag=localstorage&tag=audio&tag=csstransforms&tag=json&tag=crossdomain&type=blogmark&month=6 HTTP/1.1 200 14947da4-de3c-4e7f-9a77-afa53ccc9af5 10.1.94.69 54.161.41.102, 172.70.34.177 http 1.1 vegur 12676 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 9.085 9.084 0.0 9.084
70 2021-08-05T19:10:36.253328+00:00 app[web.1]: measure#nginx.service=6.948 request="GET /search/?tag=offlineresources&tag=audio&tag=javascript&tag=json&tag=html5&tag=csstransforms&tag=geolocation&tag=fonts&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=2dd78fe0-7464-4d88-8e74-081a59abe77a remote_addr="10.1.94.69" forwarded_for="54.161.41.102, 172.70.34.67" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13898 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="6.948" upstream_response_time="6.948" upstream_connect_time="0.000" upstream_header_time="6.948"; 6.948 GET /search/?tag=offlineresources&tag=audio&tag=javascript&tag=json&tag=html5&tag=csstransforms&tag=geolocation&tag=fonts&type=blogmark&year=2009 HTTP/1.1 200 2dd78fe0-7464-4d88-8e74-081a59abe77a 10.1.94.69 54.161.41.102, 172.70.34.67 http 1.1 vegur 13898 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 6.948 6.948 0.0 6.948
419 2021-08-05T19:17:57.445236+00:00 app[web.1]: measure#nginx.service=4.244 request="GET /search/?tag=audio&tag=localstorage&tag=video&tag=html5&tag=json&tag=crossdomain HTTP/1.1" status_code=200 request_id=c3cd7362-a276-4908-be76-ddeb81c05c33 remote_addr="10.1.94.69" forwarded_for="54.161.41.102, 172.70.35.16" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=9926 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.244" upstream_response_time="4.244" upstream_connect_time="0.000" upstream_header_time="4.244"; 4.244 GET /search/?tag=audio&tag=localstorage&tag=video&tag=html5&tag=json&tag=crossdomain HTTP/1.1 200 c3cd7362-a276-4908-be76-ddeb81c05c33 10.1.94.69 54.161.41.102, 172.70.35.16 http 1.1 vegur 9926 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.244 4.244 0.0 4.244
393 2021-08-05T19:17:22.531422+00:00 app[web.1]: measure#nginx.service=3.763 request="GET /search/?tag=javascript&tag=dragndrop&tag=mozilla&tag=json&tag=localstorage&tag=firefox&tag=tracemonkey&tag=webworkers&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=66e0f7f4-2dcd-4852-b25f-70363b56a6c8 remote_addr="10.1.94.69" forwarded_for="54.161.41.102, 172.70.34.185" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13935 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.763" upstream_response_time="3.760" upstream_connect_time="0.000" upstream_header_time="3.760"; 3.763 GET /search/?tag=javascript&tag=dragndrop&tag=mozilla&tag=json&tag=localstorage&tag=firefox&tag=tracemonkey&tag=webworkers&year=2009&type=blogmark HTTP/1.1 200 66e0f7f4-2dcd-4852-b25f-70363b56a6c8 10.1.94.69 54.161.41.102, 172.70.34.185 http 1.1 vegur 13935 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.763 3.76 0.0 3.76
249 2021-08-05T19:14:58.767246+00:00 app[web.1]: measure#nginx.service=3.626 request="GET /search/?tag=html5&tag=textshadow&tag=fonts&tag=json&tag=crossdomain&tag=performance&tag=firefox&type=blogmark&year=2009&month=6 HTTP/1.1" status_code=200 request_id=5fb3331f-0766-4981-b9c4-459747f9eccb remote_addr="10.1.94.69" forwarded_for="54.161.41.102, 172.70.34.199" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13541 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.626" upstream_response_time="3.624" upstream_connect_time="0.000" upstream_header_time="3.624"; 3.626 GET /search/?tag=html5&tag=textshadow&tag=fonts&tag=json&tag=crossdomain&tag=performance&tag=firefox&type=blogmark&year=2009&month=6 HTTP/1.1 200 5fb3331f-0766-4981-b9c4-459747f9eccb 10.1.94.69 54.161.41.102, 172.70.34.199 http 1.1 vegur 13541 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.626 3.624 0.0 3.624
435 2021-08-05T19:18:20.076993+00:00 app[web.1]: measure#nginx.service=2.602 request="GET /search/?tag=mozilla&tag=tracemonkey&tag=localstorage&tag=json&tag=video&tag=crossdomain&type=blogmark&month=6&year=2009 HTTP/1.1" status_code=200 request_id=a78d28d7-8d4c-4003-ba87-e255e3be0454 remote_addr="10.1.94.69" forwarded_for="54.161.41.102, 172.70.34.47" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12830 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.602" upstream_response_time="2.604" upstream_connect_time="0.000" upstream_header_time="2.604"; 2.602 GET /search/?tag=mozilla&tag=tracemonkey&tag=localstorage&tag=json&tag=video&tag=crossdomain&type=blogmark&month=6&year=2009 HTTP/1.1 200 a78d28d7-8d4c-4003-ba87-e255e3be0454 10.1.94.69 54.161.41.102, 172.70.34.47 http 1.1 vegur 12830 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.602 2.604 0.0 2.604
85 2021-08-05T19:10:49.347841+00:00 app[web.1]: measure#nginx.service=2.025 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=scaling HTTP/1.1" status_code=200 request_id=b3d9c972-a9b2-4237-94cc-fd68e6582358 remote_addr="10.1.94.69" forwarded_for="167.114.100.201, 172.70.126.162" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6595 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.025" upstream_response_time="2.028" upstream_connect_time="0.000" upstream_header_time="2.028"; 2.025 GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=scaling HTTP/1.1 200 b3d9c972-a9b2-4237-94cc-fd68e6582358 10.1.94.69 167.114.100.201, 172.70.126.162 http 1.1 vegur 6595 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.025 2.028 0.0 2.028
57 2021-08-05T19:10:16.159569+00:00 app[web.1]: measure#nginx.service=1.732 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=hashtables HTTP/1.1" status_code=200 request_id=fd353f2d-e631-482b-8a0b-e0983e573064 remote_addr="10.1.94.69" forwarded_for="167.114.100.201, 172.70.126.232" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6649 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="1.732" upstream_response_time="1.732" upstream_connect_time="0.000" upstream_header_time="1.732"; 1.732 GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=hashtables HTTP/1.1 200 fd353f2d-e631-482b-8a0b-e0983e573064 10.1.94.69 167.114.100.201, 172.70.126.232 http 1.1 vegur 6649 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 1.732 1.732 0.0 1.732
6 2021-08-05T19:08:57.327840+00:00 app[web.1]: measure#nginx.service=1.625 request="GET /search/?page=3&tag=programming&tag=frontend&type=entry HTTP/1.1" status_code=404 request_id=6787c84f-1d25-405c-b659-39f87fc97ea2 remote_addr="10.1.94.69" forwarded_for="207.46.13.87, 108.162.246.91" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=179 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.625" upstream_response_time="1.628" upstream_connect_time="0.000" upstream_header_time="1.628"; 1.625 GET /search/?page=3&tag=programming&tag=frontend&type=entry HTTP/1.1 404 6787c84f-1d25-405c-b659-39f87fc97ea2 10.1.94.69 207.46.13.87, 108.162.246.91 http 1.1 vegur 179 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 1.625 1.628 0.0 1.628
136 2021-08-05T19:12:09.142208+00:00 app[web.1]: measure#nginx.service=1.464 request="GET /search/?tag=zeppelins&year=2008&page=1&month=10 HTTP/1.1" status_code=200 request_id=277b6160-32f4-4fa2-bb16-fb1794b216d6 remote_addr="10.1.94.69" forwarded_for="114.119.150.252, 172.70.143.124" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6271 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="1.464" upstream_response_time="1.464" upstream_connect_time="0.000" upstream_header_time="1.464"; 1.464 GET /search/?tag=zeppelins&year=2008&page=1&month=10 HTTP/1.1 200 277b6160-32f4-4fa2-bb16-fb1794b216d6 10.1.94.69 114.119.150.252, 172.70.143.124 http 1.1 vegur 6271 - 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) 1.464 1.464 0.0 1.464
395 2021-08-05T19:17:28.865009+00:00 app[web.1]: measure#nginx.service=1.448 request="GET /search/?tag=json&tag=csstransforms&tag=html5&tag=video&tag=browsers&tag=audio&year=2009&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=573e4dbe-35f8-4fdc-8eaf-7926bbc1c0f4 remote_addr="10.1.94.69" forwarded_for="54.161.41.102, 172.70.34.233" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12470 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.448" upstream_response_time="1.448" upstream_connect_time="0.000" upstream_header_time="1.448"; 1.448 GET /search/?tag=json&tag=csstransforms&tag=html5&tag=video&tag=browsers&tag=audio&year=2009&type=blogmark&month=6 HTTP/1.1 200 573e4dbe-35f8-4fdc-8eaf-7926bbc1c0f4 10.1.94.69 54.161.41.102, 172.70.34.233 http 1.1 vegur 12470 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.448 1.448 0.0 1.448
46 2021-08-05T19:09:55.837905+00:00 app[web.1]: measure#nginx.service=1.197 request="GET /search/?type=blogmark&tag=browserplus&year=2010&month=2 HTTP/1.1" status_code=200 request_id=ab032f98-8ded-4e93-a5bd-e26d00e6ca8f remote_addr="10.1.94.69" forwarded_for="114.119.157.236, 172.70.142.224" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7195 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="1.197" upstream_response_time="1.196" upstream_connect_time="0.000" upstream_header_time="1.196"; 1.197 GET /search/?type=blogmark&tag=browserplus&year=2010&month=2 HTTP/1.1 200 ab032f98-8ded-4e93-a5bd-e26d00e6ca8f 10.1.94.69 114.119.157.236, 172.70.142.224 http 1.1 vegur 7195 - 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) 1.197 1.196 0.0 1.196
316 2021-08-05T19:15:54.187893+00:00 app[web.1]: measure#nginx.service=1.158 request="GET /2011 HTTP/1.1" status_code=301 request_id=e3efaac0-27eb-4b9c-b5fe-4c2cb73b2cc3 remote_addr="10.1.94.69" forwarded_for="34.147.114.27, 141.101.76.170" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="1.158" upstream_response_time="1.160" upstream_connect_time="0.000" upstream_header_time="1.160"; 1.158 GET /2011 HTTP/1.1 301 e3efaac0-27eb-4b9c-b5fe-4c2cb73b2cc3 10.1.94.69 34.147.114.27, 141.101.76.170 http 1.1 vegur 0 - newspaper/0.2.8 1.158 1.16 0.0 1.16
404 2021-08-05T19:17:35.236062+00:00 app[web.1]: measure#nginx.service=0.495 request="GET /search/?page=1&type=blogmark&year=2010&tag=orm HTTP/1.1" status_code=200 request_id=9c287af4-b181-4956-9467-5b825d1bdbbe remote_addr="10.1.94.69" forwarded_for="114.119.140.219, 172.70.147.171" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12374 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.495" upstream_response_time="0.496" upstream_connect_time="0.000" upstream_header_time="0.496"; 0.495 GET /search/?page=1&type=blogmark&year=2010&tag=orm HTTP/1.1 200 9c287af4-b181-4956-9467-5b825d1bdbbe 10.1.94.69 114.119.140.219, 172.70.147.171 http 1.1 vegur 12374 - 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.495 0.496 0.0 0.496
157 2021-08-05T19:12:41.135397+00:00 app[web.1]: measure#nginx.service=0.355 request="GET / HTTP/1.1" status_code=200 request_id=582151c7-90b7-4ba6-9cc6-a6ede8b08c83 remote_addr="10.1.94.69" forwarded_for="147.182.164.48, 172.70.110.201" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=108583 referer="-" user_agent="NewsBlur Page 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.355" upstream_response_time="0.352" upstream_connect_time="0.000" upstream_header_time="0.352"; 0.355 GET / HTTP/1.1 200 582151c7-90b7-4ba6-9cc6-a6ede8b08c83 10.1.94.69 147.182.164.48, 172.70.110.201 http 1.1 vegur 108583 - NewsBlur Page 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.355 0.352 0.0 0.352
304 2021-08-05T19:15:52.017176+00:00 app[web.1]: measure#nginx.service=0.287 request="GET /2018 HTTP/1.1" status_code=301 request_id=8998a739-b882-4b7a-9221-48ef42fc0cee remote_addr="10.1.94.69" forwarded_for="34.147.114.27, 172.69.54.15" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.287" upstream_response_time="0.288" upstream_connect_time="0.000" upstream_header_time="0.288"; 0.287 GET /2018 HTTP/1.1 301 8998a739-b882-4b7a-9221-48ef42fc0cee 10.1.94.69 34.147.114.27, 172.69.54.15 http 1.1 vegur 0 - newspaper/0.2.8 0.287 0.288 0.0 0.288
50 2021-08-05T19:10:04.140686+00:00 app[web.1]: measure#nginx.service=0.280 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=c60fcf28-bd06-4e23-b553-916faa31a01d remote_addr="10.1.94.69" forwarded_for="45.76.85.19, 172.68.110.14" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="UniversalFeedParser/5.2.1 +https://code.google.com/p/feedparser/" request_time="0.280" upstream_response_time="0.280" upstream_connect_time="0.000" upstream_header_time="0.272"; 0.28 GET /atom/everything/ HTTP/1.1 200 c60fcf28-bd06-4e23-b553-916faa31a01d 10.1.94.69 45.76.85.19, 172.68.110.14 http 1.1 vegur 155913 - UniversalFeedParser/5.2.1 +https://code.google.com/p/feedparser/ 0.28 0.28 0.0 0.272
123 2021-08-05T19:11:47.285191+00:00 app[web.1]: measure#nginx.service=0.267 request="GET /search/?page=1&tag=scaling&year=2009 HTTP/1.1" status_code=200 request_id=0b9d7ab9-8761-41b7-a6f3-cb55d26461c5 remote_addr="10.1.94.69" forwarded_for="114.119.140.64, 172.70.143.104" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=25358 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.267" upstream_response_time="0.268" upstream_connect_time="0.000" upstream_header_time="0.268"; 0.267 GET /search/?page=1&tag=scaling&year=2009 HTTP/1.1 200 0b9d7ab9-8761-41b7-a6f3-cb55d26461c5 10.1.94.69 114.119.140.64, 172.70.143.104 http 1.1 vegur 25358 - 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.267 0.268 0.0 0.268
348 2021-08-05T19:16:20.017522+00:00 app[web.1]: measure#nginx.service=0.237 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=cf42bf71-fe5e-47f8-a33e-1144aaca77c7 remote_addr="10.1.94.69" forwarded_for="69.131.73.116, 162.158.186.202" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="https://simonwillison.net/atom/everything/" user_agent="FreshRSS/1.18.0 (Linux; https://freshrss.org)" request_time="0.237" upstream_response_time="0.236" upstream_connect_time="0.000" upstream_header_time="0.232"; 0.237 GET /atom/everything/ HTTP/1.1 200 cf42bf71-fe5e-47f8-a33e-1144aaca77c7 10.1.94.69 69.131.73.116, 162.158.186.202 http 1.1 vegur 155913 https://simonwillison.net/atom/everything/ FreshRSS/1.18.0 (Linux; https://freshrss.org) 0.237 0.236 0.0 0.232
229 2021-08-05T19:14:25.176877+00:00 app[web.1]: measure#nginx.service=0.209 request="GET /search/?page=1&tag=github&month=11 HTTP/1.1" status_code=200 request_id=2e2f9705-6895-4cc7-9bb8-87e1e9c285db remote_addr="10.1.94.69" forwarded_for="114.119.157.236, 172.70.147.2" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=18442 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.209" upstream_response_time="0.208" upstream_connect_time="0.000" upstream_header_time="0.208"; 0.209 GET /search/?page=1&tag=github&month=11 HTTP/1.1 200 2e2f9705-6895-4cc7-9bb8-87e1e9c285db 10.1.94.69 114.119.157.236, 172.70.147.2 http 1.1 vegur 18442 - 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.209 0.208 0.0 0.208
39 2021-08-05T19:09:48.067805+00:00 app[web.1]: measure#nginx.service=0.205 request="GET /search/?year=2010&month=1&tag=osx HTTP/1.1" status_code=200 request_id=cd566e13-465a-4219-b55b-61b6b8a8c610 remote_addr="10.1.94.69" forwarded_for="114.119.131.203, 172.70.143.3" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6860 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.205" upstream_response_time="0.208" upstream_connect_time="0.000" upstream_header_time="0.208"; 0.205 GET /search/?year=2010&month=1&tag=osx HTTP/1.1 200 cd566e13-465a-4219-b55b-61b6b8a8c610 10.1.94.69 114.119.131.203, 172.70.143.3 http 1.1 vegur 6860 - 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.205 0.208 0.0 0.208
89 2021-08-05T19:10:53.832858+00:00 app[web.1]: measure#nginx.service=0.132 request="GET /search/?q%3Dpostgresql&page=1&type=blogmark&year=2009&tag=facebook HTTP/1.1" status_code=200 request_id=605906b8-67d8-4041-825d-3414a346da5d remote_addr="10.1.94.69" forwarded_for="114.119.154.59, 172.70.142.222" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=19251 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.132" upstream_response_time="0.132" upstream_connect_time="0.000" upstream_header_time="0.132"; 0.132 GET /search/?q%3Dpostgresql&page=1&type=blogmark&year=2009&tag=facebook HTTP/1.1 200 605906b8-67d8-4041-825d-3414a346da5d 10.1.94.69 114.119.154.59, 172.70.142.222 http 1.1 vegur 19251 - 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.132 0.132 0.0 0.132
20 2021-08-05T19:09:12.214395+00:00 app[web.1]: measure#nginx.service=0.125 request="GET /search/?page=1&tag=dmigrations&month=9&type=entry HTTP/1.1" status_code=200 request_id=3c1bb05c-d3af-4d38-823a-bdf46207d092 remote_addr="10.1.94.69" forwarded_for="114.119.138.140, 172.70.142.159" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6695 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.125" upstream_response_time="0.124" upstream_connect_time="0.000" upstream_header_time="0.124"; 0.125 GET /search/?page=1&tag=dmigrations&month=9&type=entry HTTP/1.1 200 3c1bb05c-d3af-4d38-823a-bdf46207d092 10.1.94.69 114.119.138.140, 172.70.142.159 http 1.1 vegur 6695 - 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.125 0.124 0.0 0.124

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