18 rows where remote_addr = "10.1.21.228" sorted by request

View and edit SQL

Suggested facets: 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
371 2021-08-05T19:16:48.817950+00:00 app[web.1]: measure#nginx.service=1.202 request="GET / HTTP/1.1" status_code=200 request_id=e57c434c-e984-4cd3-97c8-27d76e61b76b remote_addr="10.1.21.228" forwarded_for="3.226.236.80, 172.69.62.57" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=108587 referer="-" user_agent="Slackbot 1.0 (+https://api.slack.com/robots)" request_time="1.202" upstream_response_time="1.200" upstream_connect_time="0.000" upstream_header_time="1.200"; 1.202 GET / HTTP/1.1 200 e57c434c-e984-4cd3-97c8-27d76e61b76b 10.1.21.228 3.226.236.80, 172.69.62.57 http 1.1 vegur 108587 - Slackbot 1.0 (+https://api.slack.com/robots) 1.202 1.2 0.0 1.2
340 2021-08-05T19:16:15.109404+00:00 app[web.1]: measure#nginx.service=6.040 request="GET /2021/Jul/1/pagnis/?hmsr=joyk.com&utm_source=joyk.com&utm_medium=referral HTTP/1.1" status_code=200 request_id=db7e5d56-948d-47ff-af47-811889d9fb96 remote_addr="10.1.21.228" forwarded_for="66.249.73.32, 108.162.221.138" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14324 referer="-" user_agent="Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.119 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" request_time="6.040" upstream_response_time="6.040" upstream_connect_time="0.000" upstream_header_time="6.040"; 6.04 GET /2021/Jul/1/pagnis/?hmsr=joyk.com&utm_source=joyk.com&utm_medium=referral HTTP/1.1 200 db7e5d56-948d-47ff-af47-811889d9fb96 10.1.21.228 66.249.73.32, 108.162.221.138 http 1.1 vegur 14324 - Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.119 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) 6.04 6.04 0.0 6.04
201 2021-08-05T19:13:51.087714+00:00 app[web.1]: measure#nginx.service=1.245 request="GET /robots.txt HTTP/1.1" status_code=200 request_id=568b3394-c878-4979-9606-2e03a4c6097c remote_addr="10.1.21.228" forwarded_for="18.215.244.20, 172.70.34.222" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=100 referer="-" user_agent="Buck/2.2; (+https://app.hypefactors.com/media-monitoring/about.html)" request_time="1.245" upstream_response_time="1.248" upstream_connect_time="0.000" upstream_header_time="1.248"; 1.245 GET /robots.txt HTTP/1.1 200 568b3394-c878-4979-9606-2e03a4c6097c 10.1.21.228 18.215.244.20, 172.70.34.222 http 1.1 vegur 100 - Buck/2.2; (+https://app.hypefactors.com/media-monitoring/about.html) 1.245 1.248 0.0 1.248
183 2021-08-05T19:13:25.891084+00:00 app[web.1]: measure#nginx.service=0.213 request="GET /search/?page=1&year=2009&tag=rails&month=3 HTTP/1.1" status_code=200 request_id=18b2805d-8999-461e-9fc2-21207be53d2d remote_addr="10.1.21.228" forwarded_for="114.119.130.248, 172.70.142.213" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5829 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.213" upstream_response_time="0.212" upstream_connect_time="0.000" upstream_header_time="0.212"; 0.213 GET /search/?page=1&year=2009&tag=rails&month=3 HTTP/1.1 200 18b2805d-8999-461e-9fc2-21207be53d2d 10.1.21.228 114.119.130.248, 172.70.142.213 http 1.1 vegur 5829 - 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.213 0.212 0.0 0.212
170 2021-08-05T19:13:00.069430+00:00 app[web.1]: measure#nginx.service=0.085 request="GET /search/?q%3Dpostgresql&month=10&tag=flickr&type=blogmark HTTP/1.1" status_code=200 request_id=b162b9d1-285e-4571-a827-3b70a8b617b2 remote_addr="10.1.21.228" forwarded_for="114.119.130.104, 162.158.165.34" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6726 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.085" upstream_response_time="0.084" upstream_connect_time="0.000" upstream_header_time="0.084"; 0.085 GET /search/?q%3Dpostgresql&month=10&tag=flickr&type=blogmark HTTP/1.1 200 b162b9d1-285e-4571-a827-3b70a8b617b2 10.1.21.228 114.119.130.104, 162.158.165.34 http 1.1 vegur 6726 - 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.085 0.084 0.0 0.084
288 2021-08-05T19:15:43.835129+00:00 app[web.1]: measure#nginx.service=0.107 request="GET /search/?q%3Dpostgresql&page=1&tag=billscott&type=blogmark HTTP/1.1" status_code=200 request_id=50883245-d196-4e10-aeea-bd307cea8e29 remote_addr="10.1.21.228" forwarded_for="114.119.130.152, 172.70.147.20" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5846 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.107" upstream_response_time="0.104" upstream_connect_time="0.000" upstream_header_time="0.104"; 0.107 GET /search/?q%3Dpostgresql&page=1&tag=billscott&type=blogmark HTTP/1.1 200 50883245-d196-4e10-aeea-bd307cea8e29 10.1.21.228 114.119.130.152, 172.70.147.20 http 1.1 vegur 5846 - 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.107 0.104 0.0 0.104
200 2021-08-05T19:13:51.031491+00:00 app[web.1]: measure#nginx.service=5.241 request="GET /search/?q=javascript&tag=security&type=blogmark&year=2007 HTTP/1.1" status_code=200 request_id=6fea1a2c-c6c3-4287-9cce-69ff95335c91 remote_addr="10.1.21.228" forwarded_for="114.119.143.135, 162.158.166.53" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10348 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="5.241" upstream_response_time="5.244" upstream_connect_time="0.000" upstream_header_time="5.244"; 5.241 GET /search/?q=javascript&tag=security&type=blogmark&year=2007 HTTP/1.1 200 6fea1a2c-c6c3-4287-9cce-69ff95335c91 10.1.21.228 114.119.143.135, 162.158.166.53 http 1.1 vegur 10348 - 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) 5.241 5.244 0.0 5.244
481 2021-08-05T19:19:45.629101+00:00 app[web.1]: measure#nginx.service=16.545 request="GET /search/?tag=browsers&tag=firefox35&tag=textshadow&tag=performance&tag=fonts&type=blogmark HTTP/1.1" status_code=200 request_id=a5d2bd7d-9065-45fb-bdc0-f6d9b19ce1f2 remote_addr="10.1.21.228" forwarded_for="54.161.41.102, 172.70.35.34" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10251 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="16.545" upstream_response_time="16.544" upstream_connect_time="0.000" upstream_header_time="16.544"; 16.545 GET /search/?tag=browsers&tag=firefox35&tag=textshadow&tag=performance&tag=fonts&type=blogmark HTTP/1.1 200 a5d2bd7d-9065-45fb-bdc0-f6d9b19ce1f2 10.1.21.228 54.161.41.102, 172.70.35.34 http 1.1 vegur 10251 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 16.545 16.544 0.0 16.544
252 2021-08-05T19:15:01.270874+00:00 app[web.1]: measure#nginx.service=2.478 request="GET /search/?tag=canvas&tag=crossdomain&tag=html5&tag=browsers&tag=webworkers&tag=mozilla&tag=firefox&type=blogmark&month=6&year=2009 HTTP/1.1" status_code=200 request_id=7290dfd0-f51a-4786-9fb2-8099dcda5bc7 remote_addr="10.1.21.228" forwarded_for="54.161.41.102, 172.70.34.27" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13578 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.478" upstream_response_time="2.476" upstream_connect_time="0.000" upstream_header_time="2.476"; 2.478 GET /search/?tag=canvas&tag=crossdomain&tag=html5&tag=browsers&tag=webworkers&tag=mozilla&tag=firefox&type=blogmark&month=6&year=2009 HTTP/1.1 200 7290dfd0-f51a-4786-9fb2-8099dcda5bc7 10.1.21.228 54.161.41.102, 172.70.34.27 http 1.1 vegur 13578 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.478 2.476 0.0 2.476
280 2021-08-05T19:15:32.677793+00:00 app[web.1]: measure#nginx.service=1.348 request="GET /search/?tag=csstransforms&tag=dragndrop&tag=webworkers&tag=browsers&tag=performance&tag=localstorage&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=010e5fd3-c45a-43a5-a7c8-81dfdf8164d6 remote_addr="10.1.21.228" forwarded_for="54.161.41.102, 172.70.34.187" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12474 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.348" upstream_response_time="1.348" upstream_connect_time="0.000" upstream_header_time="1.348"; 1.348 GET /search/?tag=csstransforms&tag=dragndrop&tag=webworkers&tag=browsers&tag=performance&tag=localstorage&type=blogmark&year=2009 HTTP/1.1 200 010e5fd3-c45a-43a5-a7c8-81dfdf8164d6 10.1.21.228 54.161.41.102, 172.70.34.187 http 1.1 vegur 12474 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.348 1.348 0.0 1.348
473 2021-08-05T19:19:22.894118+00:00 app[web.1]: measure#nginx.service=23.816 request="GET /search/?tag=csstransforms&tag=video&tag=performance&tag=textshadow&tag=javascript&tag=audio&tag=firefox&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=406a9a53-4c22-40a7-8757-4eaffa3688f2 remote_addr="10.1.21.228" forwarded_for="54.161.41.102, 172.70.34.23" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12994 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="23.816" upstream_response_time="23.816" upstream_connect_time="0.000" upstream_header_time="23.816"; 23.816 GET /search/?tag=csstransforms&tag=video&tag=performance&tag=textshadow&tag=javascript&tag=audio&tag=firefox&year=2009&type=blogmark HTTP/1.1 200 406a9a53-4c22-40a7-8757-4eaffa3688f2 10.1.21.228 54.161.41.102, 172.70.34.23 http 1.1 vegur 12994 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 23.816 23.816 0.0 23.816
364 2021-08-05T19:16:37.663310+00:00 app[web.1]: measure#nginx.service=0.118 request="GET /search/?tag=denialofservice&type=blogmark&year=2007&month=10 HTTP/1.1" status_code=200 request_id=ce35d134-cd52-4498-ae31-87a9fb8e7db2 remote_addr="10.1.21.228" forwarded_for="114.119.136.66, 172.70.147.143" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6735 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.118" upstream_response_time="0.116" upstream_connect_time="0.000" upstream_header_time="0.116"; 0.118 GET /search/?tag=denialofservice&type=blogmark&year=2007&month=10 HTTP/1.1 200 ce35d134-cd52-4498-ae31-87a9fb8e7db2 10.1.21.228 114.119.136.66, 172.70.147.143 http 1.1 vegur 6735 - 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.118 0.116 0.0 0.116
59 2021-08-05T19:10:17.645382+00:00 app[web.1]: measure#nginx.service=0.760 request="GET /search/?tag=fonts&tag=tracemonkey&tag=crossdomain&tag=json&tag=webworkers&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=52dd0a8b-db25-43e6-b2d3-0fcd585f5406 remote_addr="10.1.21.228" forwarded_for="54.161.41.102, 172.70.35.8" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11152 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="0.760" upstream_response_time="0.760" upstream_connect_time="0.000" upstream_header_time="0.760"; 0.76 GET /search/?tag=fonts&tag=tracemonkey&tag=crossdomain&tag=json&tag=webworkers&type=blogmark&year=2009 HTTP/1.1 200 52dd0a8b-db25-43e6-b2d3-0fcd585f5406 10.1.21.228 54.161.41.102, 172.70.35.8 http 1.1 vegur 11152 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 0.76 0.76 0.0 0.76
105 2021-08-05T19:11:21.036732+00:00 app[web.1]: measure#nginx.service=0.089 request="GET /search/?tag=hash&page=1&type=blogmark HTTP/1.1" status_code=200 request_id=24bd94a7-dbb2-435b-913e-e99a0597c292 remote_addr="10.1.21.228" forwarded_for="114.119.157.39, 172.70.147.155" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6792 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.089" upstream_response_time="0.088" upstream_connect_time="0.000" upstream_header_time="0.088"; 0.089 GET /search/?tag=hash&page=1&type=blogmark HTTP/1.1 200 24bd94a7-dbb2-435b-913e-e99a0597c292 10.1.21.228 114.119.157.39, 172.70.147.155 http 1.1 vegur 6792 - 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.089 0.088 0.0 0.088
246 2021-08-05T19:14:54.408986+00:00 app[web.1]: measure#nginx.service=2.321 request="GET /search/?tag=performance&tag=mozilla&tag=csstransforms&tag=json&tag=tracemonkey&tag=canvas&tag=firefox&month=6&type=blogmark HTTP/1.1" status_code=200 request_id=4e5df254-6864-4083-8f52-c75edba1b6d8 remote_addr="10.1.21.228" forwarded_for="54.161.41.102, 172.70.34.21" 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="2.321" upstream_response_time="2.320" upstream_connect_time="0.000" upstream_header_time="2.320"; 2.321 GET /search/?tag=performance&tag=mozilla&tag=csstransforms&tag=json&tag=tracemonkey&tag=canvas&tag=firefox&month=6&type=blogmark HTTP/1.1 200 4e5df254-6864-4083-8f52-c75edba1b6d8 10.1.21.228 54.161.41.102, 172.70.34.21 http 1.1 vegur 12676 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.321 2.32 0.0 2.32
151 2021-08-05T19:12:35.008450+00:00 app[web.1]: measure#nginx.service=5.571 request="GET /search/?tag=textshadow&tag=audio&tag=canvas&tag=html5&tag=tracemonkey&tag=mozilla&tag=performance&tag=dragndrop&tag=firefox&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=54ef98e1-c5c9-4880-93f3-be957c38b535 remote_addr="10.1.21.228" forwarded_for="54.161.41.102, 172.70.34.3" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14608 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="5.571" upstream_response_time="5.572" upstream_connect_time="0.000" upstream_header_time="5.572"; 5.571 GET /search/?tag=textshadow&tag=audio&tag=canvas&tag=html5&tag=tracemonkey&tag=mozilla&tag=performance&tag=dragndrop&tag=firefox&year=2009&type=blogmark HTTP/1.1 200 54ef98e1-c5c9-4880-93f3-be957c38b535 10.1.21.228 54.161.41.102, 172.70.34.3 http 1.1 vegur 14608 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 5.571 5.572 0.0 5.572
482 2021-08-05T19:19:45.862493+00:00 app[web.1]: measure#nginx.service=21.780 request="GET /search/?tag=textshadow&tag=canvas&tag=tracemonkey&tag=crossdomain&year=2009&month=6 HTTP/1.1" status_code=200 request_id=55a9770c-a5ff-4078-8b20-9de31ea076e3 remote_addr="10.1.21.228" forwarded_for="54.161.41.102, 172.70.34.175" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10440 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="21.780" upstream_response_time="21.780" upstream_connect_time="0.000" upstream_header_time="21.780"; 21.78 GET /search/?tag=textshadow&tag=canvas&tag=tracemonkey&tag=crossdomain&year=2009&month=6 HTTP/1.1 200 55a9770c-a5ff-4078-8b20-9de31ea076e3 10.1.21.228 54.161.41.102, 172.70.34.175 http 1.1 vegur 10440 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 21.78 21.78 0.0 21.78
279 2021-08-05T19:15:31.261680+00:00 app[web.1]: measure#nginx.service=2.965 request="GET /search/?tag=webworkers&tag=fonts&tag=audio&tag=crossdomain&tag=html5&tag=firefox&tag=canvas&tag=browsers&year=2009&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=df25752e-457f-4d22-b5bd-d815b434a5e1 remote_addr="10.1.21.228" forwarded_for="54.161.41.102, 172.70.35.28" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14314 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.965" upstream_response_time="2.964" upstream_connect_time="0.000" upstream_header_time="2.964"; 2.965 GET /search/?tag=webworkers&tag=fonts&tag=audio&tag=crossdomain&tag=html5&tag=firefox&tag=canvas&tag=browsers&year=2009&type=blogmark&month=6 HTTP/1.1 200 df25752e-457f-4d22-b5bd-d815b434a5e1 10.1.21.228 54.161.41.102, 172.70.35.28 http 1.1 vegur 14314 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.965 2.964 0.0 2.964

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