log
18 rows where remote_addr = "10.1.89.90" sorted by status_code
This data as json, CSV (advanced)
Suggested facets: request, status_code, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 2021-08-05T19:08:48.927408+00:00 app[web.1]: measure#nginx.service=2.950 request="GET /search/?year=2009&month=7&tag=jacobkaplanmoss HTTP/1.1" status_code=200 request_id=551c6338-6484-4026-834b-40de316e46ad remote_addr="10.1.89.90" forwarded_for="114.119.134.41, 172.70.142.66" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5782 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="2.950" upstream_response_time="2.952" upstream_connect_time="0.000" upstream_header_time="2.952"; | 2.95 | GET /search/?year=2009&month=7&tag=jacobkaplanmoss HTTP/1.1 | 200 | 551c6338-6484-4026-834b-40de316e46ad | 10.1.89.90 | 114.119.134.41, 172.70.142.66 | http | 1.1 vegur | 5782 | - | 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) | 2.95 | 2.952 | 0.0 | 2.952 |
83 | 83 | 2021-08-05T19:10:49.250763+00:00 app[web.1]: measure#nginx.service=2.560 request="GET /search/?tag=video&tag=dragndrop&tag=textshadow&tag=csstransforms&tag=browsers&tag=performance&type=blogmark&year=2009&month=6 HTTP/1.1" status_code=200 request_id=7da5a5f8-503d-40db-958e-bc84fdb5b61d remote_addr="10.1.89.90" forwarded_for="54.161.41.102, 172.70.34.165" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13046 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.560" upstream_response_time="2.560" upstream_connect_time="0.000" upstream_header_time="2.560"; | 2.56 | GET /search/?tag=video&tag=dragndrop&tag=textshadow&tag=csstransforms&tag=browsers&tag=performance&type=blogmark&year=2009&month=6 HTTP/1.1 | 200 | 7da5a5f8-503d-40db-958e-bc84fdb5b61d | 10.1.89.90 | 54.161.41.102, 172.70.34.165 | http | 1.1 vegur | 13046 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 2.56 | 2.56 | 0.0 | 2.56 |
110 | 110 | 2021-08-05T19:11:29.899127+00:00 app[web.1]: measure#nginx.service=3.879 request="GET /search/?tag=fonts&tag=crossdomain&tag=dragndrop&tag=audio&tag=javascript&year=2009 HTTP/1.1" status_code=200 request_id=bacfd51f-3b05-4ad4-8002-930d0d6953e6 remote_addr="10.1.89.90" forwarded_for="54.161.41.102, 172.70.34.181" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10283 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.879" upstream_response_time="3.876" upstream_connect_time="0.000" upstream_header_time="3.876"; | 3.879 | GET /search/?tag=fonts&tag=crossdomain&tag=dragndrop&tag=audio&tag=javascript&year=2009 HTTP/1.1 | 200 | bacfd51f-3b05-4ad4-8002-930d0d6953e6 | 10.1.89.90 | 54.161.41.102, 172.70.34.181 | http | 1.1 vegur | 10283 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 3.879 | 3.876 | 0.0 | 3.876 |
126 | 126 | 2021-08-05T19:11:53.092897+00:00 app[web.1]: measure#nginx.service=0.336 request="GET / HTTP/1.1" status_code=200 request_id=7bd2b591-e05d-4101-b096-23180cd85c97 remote_addr="10.1.89.90" forwarded_for="167.71.44.60, 162.158.89.140" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=108564 referer="-" user_agent="request.js" request_time="0.336" upstream_response_time="0.336" upstream_connect_time="0.000" upstream_header_time="0.336"; | 0.336 | GET / HTTP/1.1 | 200 | 7bd2b591-e05d-4101-b096-23180cd85c97 | 10.1.89.90 | 167.71.44.60, 162.158.89.140 | http | 1.1 vegur | 108564 | - | request.js | 0.336 | 0.336 | 0.0 | 0.336 |
135 | 135 | 2021-08-05T19:12:09.011499+00:00 app[web.1]: measure#nginx.service=7.865 request="GET /search/?tag=webworkers&tag=html5&tag=dragndrop&tag=performance&tag=video&tag=csstransforms&tag=javascript&tag=firefox35&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=7c965326-ec2e-4d14-8e20-228a6662c0a9 remote_addr="10.1.89.90" forwarded_for="54.161.41.102, 172.70.34.229" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14009 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="7.865" upstream_response_time="7.868" upstream_connect_time="0.000" upstream_header_time="7.868"; | 7.865 | GET /search/?tag=webworkers&tag=html5&tag=dragndrop&tag=performance&tag=video&tag=csstransforms&tag=javascript&tag=firefox35&type=blogmark&year=2009 HTTP/1.1 | 200 | 7c965326-ec2e-4d14-8e20-228a6662c0a9 | 10.1.89.90 | 54.161.41.102, 172.70.34.229 | http | 1.1 vegur | 14009 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 7.865 | 7.868 | 0.0 | 7.868 |
147 | 147 | 2021-08-05T19:12:25.794325+00:00 app[web.1]: measure#nginx.service=3.121 request="GET /search/?tag=tracemonkey&tag=audio&tag=html5&tag=crossdomain&tag=csstransforms&tag=browsers&month=6 HTTP/1.1" status_code=200 request_id=f8c8735d-3528-429f-9d40-6aa2b98f5b10 remote_addr="10.1.89.90" forwarded_for="54.161.41.102, 172.70.35.84" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11040 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.121" upstream_response_time="3.120" upstream_connect_time="0.000" upstream_header_time="3.120"; | 3.121 | GET /search/?tag=tracemonkey&tag=audio&tag=html5&tag=crossdomain&tag=csstransforms&tag=browsers&month=6 HTTP/1.1 | 200 | f8c8735d-3528-429f-9d40-6aa2b98f5b10 | 10.1.89.90 | 54.161.41.102, 172.70.35.84 | http | 1.1 vegur | 11040 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 3.121 | 3.12 | 0.0 | 3.12 |
152 | 152 | 2021-08-05T19:12:35.508314+00:00 app[web.1]: measure#nginx.service=1.068 request="GET /search/?tag=audio&tag=localstorage&tag=tracemonkey&tag=html5&tag=offlineresources&type=blogmark HTTP/1.1" status_code=200 request_id=f9d8d275-1440-4c3d-b3b0-fbb98172e6e0 remote_addr="10.1.89.90" forwarded_for="54.161.41.102, 172.70.35.52" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10443 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.068" upstream_response_time="1.068" upstream_connect_time="0.000" upstream_header_time="1.068"; | 1.068 | GET /search/?tag=audio&tag=localstorage&tag=tracemonkey&tag=html5&tag=offlineresources&type=blogmark HTTP/1.1 | 200 | f9d8d275-1440-4c3d-b3b0-fbb98172e6e0 | 10.1.89.90 | 54.161.41.102, 172.70.35.52 | http | 1.1 vegur | 10443 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 1.068 | 1.068 | 0.0 | 1.068 |
171 | 171 | 2021-08-05T19:13:00.674132+00:00 app[web.1]: measure#nginx.service=0.174 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=a41d1e7f-3505-46dc-a250-9374131ebf56 remote_addr="10.1.89.90" 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.174" upstream_response_time="0.172" upstream_connect_time="0.000" upstream_header_time="0.164"; | 0.174 | GET /atom/everything/ HTTP/1.1 | 200 | a41d1e7f-3505-46dc-a250-9374131ebf56 | 10.1.89.90 | 139.162.187.171, 162.158.92.97 | http | 1.1 vegur | 155913 | http://simonwillison.net/atom/everything/ | Gofeed/1.0 | 0.174 | 0.172 | 0.0 | 0.164 |
212 | 212 | 2021-08-05T19:14:03.814888+00:00 app[web.1]: measure#nginx.service=0.136 request="GET /search/?tag=opensource&page=1&year=2012&type=entry HTTP/1.1" status_code=200 request_id=d552b53b-bc13-4307-862d-a5211478da2f remote_addr="10.1.89.90" forwarded_for="114.119.147.75, 172.70.147.160" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=9195 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.136" upstream_response_time="0.136" upstream_connect_time="0.000" upstream_header_time="0.136"; | 0.136 | GET /search/?tag=opensource&page=1&year=2012&type=entry HTTP/1.1 | 200 | d552b53b-bc13-4307-862d-a5211478da2f | 10.1.89.90 | 114.119.147.75, 172.70.147.160 | http | 1.1 vegur | 9195 | - | 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.136 | 0.136 | 0.0 | 0.136 |
226 | 226 | 2021-08-05T19:14:23.436740+00:00 app[web.1]: measure#nginx.service=3.384 request="GET /search/?tag=canvas&tag=mozilla&tag=json&tag=textshadow&tag=performance&tag=tracemonkey&type=blogmark&year=2009&month=6 HTTP/1.1" status_code=200 request_id=66a3e0c6-ba56-418e-9c3a-083674d8871b remote_addr="10.1.89.90" forwarded_for="54.161.41.102, 172.70.35.88" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12794 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.384" upstream_response_time="3.384" upstream_connect_time="0.000" upstream_header_time="3.384"; | 3.384 | GET /search/?tag=canvas&tag=mozilla&tag=json&tag=textshadow&tag=performance&tag=tracemonkey&type=blogmark&year=2009&month=6 HTTP/1.1 | 200 | 66a3e0c6-ba56-418e-9c3a-083674d8871b | 10.1.89.90 | 54.161.41.102, 172.70.35.88 | http | 1.1 vegur | 12794 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 3.384 | 3.384 | 0.0 | 3.384 |
254 | 254 | 2021-08-05T19:15:06.817584+00:00 app[web.1]: measure#nginx.service=0.127 request="GET /search/?tag=realtimeweb&page=1&year=2008&type=blogmark HTTP/1.1" status_code=200 request_id=e09176bf-2031-4611-8f4a-c46655c511ce remote_addr="10.1.89.90" forwarded_for="114.119.146.18, 172.70.147.181" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7247 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.127" upstream_response_time="0.128" upstream_connect_time="0.000" upstream_header_time="0.128"; | 0.127 | GET /search/?tag=realtimeweb&page=1&year=2008&type=blogmark HTTP/1.1 | 200 | e09176bf-2031-4611-8f4a-c46655c511ce | 10.1.89.90 | 114.119.146.18, 172.70.147.181 | http | 1.1 vegur | 7247 | - | 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.127 | 0.128 | 0.0 | 0.128 |
350 | 350 | 2021-08-05T19:16:23.907342+00:00 app[web.1]: measure#nginx.service=3.696 request="GET /search/?tag=javascript&tag=geolocation&tag=webworkers&tag=performance&tag=canvas&tag=video&tag=fonts&year=2009&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=a67c6599-9f0a-47ea-9a99-99da6c6cf4cd remote_addr="10.1.89.90" forwarded_for="54.161.41.102, 172.70.34.47" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13726 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.696" upstream_response_time="3.696" upstream_connect_time="0.000" upstream_header_time="3.696"; | 3.696 | GET /search/?tag=javascript&tag=geolocation&tag=webworkers&tag=performance&tag=canvas&tag=video&tag=fonts&year=2009&type=blogmark&month=6 HTTP/1.1 | 200 | a67c6599-9f0a-47ea-9a99-99da6c6cf4cd | 10.1.89.90 | 54.161.41.102, 172.70.34.47 | http | 1.1 vegur | 13726 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 3.696 | 3.696 | 0.0 | 3.696 |
389 | 389 | 2021-08-05T19:17:14.876393+00:00 app[web.1]: measure#nginx.service=0.213 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=f82fc09b-1a8f-4fcd-957a-b93c5582c235 remote_addr="10.1.89.90" forwarded_for="168.91.196.173, 172.70.130.51" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app)" request_time="0.213" upstream_response_time="0.212" upstream_connect_time="0.000" upstream_header_time="0.208"; | 0.213 | GET /atom/links/ HTTP/1.1 | 200 | f82fc09b-1a8f-4fcd-957a-b93c5582c235 | 10.1.89.90 | 168.91.196.173, 172.70.130.51 | http | 1.1 vegur | 16609 | - | Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app) | 0.213 | 0.212 | 0.0 | 0.208 |
403 | 403 | 2021-08-05T19:17:35.135172+00:00 app[web.1]: measure#nginx.service=1.999 request="GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=charlesying HTTP/1.1" status_code=200 request_id=f5b37724-d5aa-4c5a-af87-622165c20057 remote_addr="10.1.89.90" forwarded_for="167.114.100.201, 172.70.126.94" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6721 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="1.999" upstream_response_time="1.996" upstream_connect_time="0.000" upstream_header_time="1.996"; | 1.999 | GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=charlesying HTTP/1.1 | 200 | f5b37724-d5aa-4c5a-af87-622165c20057 | 10.1.89.90 | 167.114.100.201, 172.70.126.94 | http | 1.1 vegur | 6721 | - | Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) | 1.999 | 1.996 | 0.0 | 1.996 |
479 | 479 | 2021-08-05T19:19:43.570999+00:00 app[web.1]: measure#nginx.service=29.486 request="GET /search/?tag=video&tag=localstorage&tag=mozilla&tag=textshadow&tag=audio&tag=html5&tag=dragndrop&tag=firefox35&tag=javascript&tag=tracemonkey&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=1a70df3f-4a1f-4347-85d2-861c7f11d708 remote_addr="10.1.89.90" forwarded_for="54.161.41.102, 172.70.34.113" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=15427 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="29.486" upstream_response_time="29.484" upstream_connect_time="0.000" upstream_header_time="29.484"; | 29.486 | GET /search/?tag=video&tag=localstorage&tag=mozilla&tag=textshadow&tag=audio&tag=html5&tag=dragndrop&tag=firefox35&tag=javascript&tag=tracemonkey&type=blogmark&month=6 HTTP/1.1 | 200 | 1a70df3f-4a1f-4347-85d2-861c7f11d708 | 10.1.89.90 | 54.161.41.102, 172.70.34.113 | http | 1.1 vegur | 15427 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 29.486 | 29.484 | 0.0 | 29.484 |
485 | 485 | 2021-08-05T19:19:46.291048+00:00 app[web.1]: measure#nginx.service=12.725 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=b7ddf11c-ef5d-4508-82d1-ae04e832c79f remote_addr="10.1.89.90" forwarded_for="24.27.54.164, 172.69.71.72" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Tiny Tiny RSS/21.06-34807ba (http://tt-rss.org/)" request_time="12.725" upstream_response_time="12.724" upstream_connect_time="0.000" upstream_header_time="12.716"; | 12.725 | GET /atom/everything/ HTTP/1.1 | 200 | b7ddf11c-ef5d-4508-82d1-ae04e832c79f | 10.1.89.90 | 24.27.54.164, 172.69.71.72 | http | 1.1 vegur | 155913 | - | Tiny Tiny RSS/21.06-34807ba (http://tt-rss.org/) | 12.725 | 12.724 | 0.0 | 12.716 |
456 | 456 | 2021-08-05T19:19:01.816315+00:00 app[web.1]: measure#nginx.service=10.339 request="GET / HTTP/1.1" status_code=301 request_id=3a215e29-aa53-4661-bfa6-42f58a068a3b remote_addr="10.1.89.90" forwarded_for="175.27.168.253, 172.70.98.137" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36" request_time="10.339" upstream_response_time="10.340" upstream_connect_time="0.000" upstream_header_time="10.340"; | 10.339 | GET / HTTP/1.1 | 301 | 3a215e29-aa53-4661-bfa6-42f58a068a3b | 10.1.89.90 | 175.27.168.253, 172.70.98.137 | http | 1.1 vegur | 5 | - | Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36 | 10.339 | 10.34 | 0.0 | 10.34 |
458 | 458 | 2021-08-05T19:19:14.076491+00:00 app[web.1]: measure#nginx.service=30.001 request="GET /search/?tag=geolocation&tag=offlineresources&tag=canvas&tag=javascript&tag=performance&tag=dragndrop&tag=crossdomain&tag=mozilla&tag=video&tag=tracemonkey&year=2009&type=blogmark HTTP/1.1" status_code=499 request_id=b000a498-2044-4f40-8b63-daeb57f27b60 remote_addr="10.1.89.90" forwarded_for="54.161.41.102, 172.70.34.105" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="30.001" upstream_response_time="30.000" upstream_connect_time="0.000" upstream_header_time="-"; | 30.001 | GET /search/?tag=geolocation&tag=offlineresources&tag=canvas&tag=javascript&tag=performance&tag=dragndrop&tag=crossdomain&tag=mozilla&tag=video&tag=tracemonkey&year=2009&type=blogmark HTTP/1.1 | 499 | b000a498-2044-4f40-8b63-daeb57f27b60 | 10.1.89.90 | 54.161.41.102, 172.70.34.105 | http | 1.1 vegur | 0 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 30.001 | 30.0 | 0.0 | - |
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 );