18 rows where remote_addr = "10.1.89.90"

View and edit SQL

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

remote_addr

  • 10.1.89.90 · 18
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
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 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 -
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 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

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