14 rows where remote_addr = "10.1.63.160"

View and edit SQL

Suggested facets: status_code, user_agent

remote_addr

  • 10.1.63.160 · 14
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
16 2021-08-05T19:09:07.171562+00:00 app[web.1]: measure#nginx.service=0.148 request="GET /2020/May/22/ HTTP/1.1" status_code=200 request_id=568181f5-70f2-44bd-bdc2-2df2d245200e remote_addr="10.1.63.160" forwarded_for="157.55.39.163, 108.162.245.239" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7074 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.148" upstream_response_time="0.148" upstream_connect_time="0.000" upstream_header_time="0.148"; 0.148 GET /2020/May/22/ HTTP/1.1 200 568181f5-70f2-44bd-bdc2-2df2d245200e 10.1.63.160 157.55.39.163, 108.162.245.239 http 1.1 vegur 7074 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 0.148 0.148 0.0 0.148
26 2021-08-05T19:09:25.302860+00:00 app[web.1]: measure#nginx.service=2.985 request="GET /search/?tag=tracemonkey&tag=video&tag=offlineresources&tag=browsers&tag=dragndrop&tag=csstransforms&tag=firefox&type=blogmark&month=6&year=2009 HTTP/1.1" status_code=200 request_id=80d278dd-ad0b-4419-ab46-069d4dd9e530 remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.34.237" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14133 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.985" upstream_response_time="2.984" upstream_connect_time="0.000" upstream_header_time="2.984"; 2.985 GET /search/?tag=tracemonkey&tag=video&tag=offlineresources&tag=browsers&tag=dragndrop&tag=csstransforms&tag=firefox&type=blogmark&month=6&year=2009 HTTP/1.1 200 80d278dd-ad0b-4419-ab46-069d4dd9e530 10.1.63.160 54.161.41.102, 172.70.34.237 http 1.1 vegur 14133 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.985 2.984 0.0 2.984
84 2021-08-05T19:10:49.320410+00:00 app[web.1]: measure#nginx.service=1.798 request="GET /2004/Jun/9/playing/ HTTP/1.1" status_code=200 request_id=0e33731f-9aed-4429-a2c9-e42193fb34b5 remote_addr="10.1.63.160" forwarded_for="207.46.13.98, 108.162.245.120" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=3628 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.798" upstream_response_time="1.800" upstream_connect_time="0.000" upstream_header_time="1.800"; 1.798 GET /2004/Jun/9/playing/ HTTP/1.1 200 0e33731f-9aed-4429-a2c9-e42193fb34b5 10.1.63.160 207.46.13.98, 108.162.245.120 http 1.1 vegur 3628 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 1.798 1.8 0.0 1.8
87 2021-08-05T19:10:51.917489+00:00 app[web.1]: measure#nginx.service=2.187 request="GET /search/?tag=textshadow&tag=crossdomain&tag=firefox35&tag=fonts&tag=audio&tag=tracemonkey&tag=dragndrop&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=b5b4cb17-d48b-479e-a0f8-5a4fbef98fd1 remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.34.143" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12711 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.187" upstream_response_time="2.188" upstream_connect_time="0.000" upstream_header_time="2.188"; 2.187 GET /search/?tag=textshadow&tag=crossdomain&tag=firefox35&tag=fonts&tag=audio&tag=tracemonkey&tag=dragndrop&type=blogmark&month=6 HTTP/1.1 200 b5b4cb17-d48b-479e-a0f8-5a4fbef98fd1 10.1.63.160 54.161.41.102, 172.70.34.143 http 1.1 vegur 12711 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.187 2.188 0.0 2.188
193 2021-08-05T19:13:38.369423+00:00 app[web.1]: measure#nginx.service=0.045 request="GET / HTTP/1.1" status_code=301 request_id=fa36859c-6d7d-40b8-9460-6598c0830bf5 remote_addr="10.1.63.160" forwarded_for="18.215.244.20, 172.70.34.226" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="Buck/2.2; (+https://app.hypefactors.com/media-monitoring/about.html)" request_time="0.045" upstream_response_time="0.044" upstream_connect_time="0.000" upstream_header_time="0.044"; 0.045 GET / HTTP/1.1 301 fa36859c-6d7d-40b8-9460-6598c0830bf5 10.1.63.160 18.215.244.20, 172.70.34.226 http 1.1 vegur 5 - Buck/2.2; (+https://app.hypefactors.com/media-monitoring/about.html) 0.045 0.044 0.0 0.044
214 2021-08-05T19:14:06.662990+00:00 app[web.1]: measure#nginx.service=2.838 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=32136be2-597e-4e8c-a215-5b0474e9e48a remote_addr="10.1.63.160" forwarded_for="75.164.138.232, 162.158.107.231" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="easy-feed-oven/1.0 (+https://github.com/lmorchard/easy-feed-oven)" request_time="2.838" upstream_response_time="2.836" upstream_connect_time="0.000" upstream_header_time="2.832"; 2.838 GET /atom/everything/ HTTP/1.1 200 32136be2-597e-4e8c-a215-5b0474e9e48a 10.1.63.160 75.164.138.232, 162.158.107.231 http 1.1 vegur 155913 - easy-feed-oven/1.0 (+https://github.com/lmorchard/easy-feed-oven) 2.838 2.836 0.0 2.832
239 2021-08-05T19:14:40.968138+00:00 app[web.1]: measure#nginx.service=1.454 request="GET /search/?page=3&year=2008&month=12&tag=represent HTTP/1.1" status_code=404 request_id=fe60df44-872d-4804-b7de-4a52f7c71c2f remote_addr="10.1.63.160" forwarded_for="114.119.159.160, 172.70.142.219" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=179 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.454" upstream_response_time="1.456" upstream_connect_time="0.000" upstream_header_time="1.456"; 1.454 GET /search/?page=3&year=2008&month=12&tag=represent HTTP/1.1 404 fe60df44-872d-4804-b7de-4a52f7c71c2f 10.1.63.160 114.119.159.160, 172.70.142.219 http 1.1 vegur 179 - 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.454 1.456 0.0 1.456
291 2021-08-05T19:15:46.099624+00:00 app[web.1]: measure#nginx.service=1.997 request="GET /search/?tag=webworkers&tag=video&tag=crossdomain&tag=csstransforms&tag=geolocation&tag=offlineresources&tag=dragndrop&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=493a4a48-6137-466e-a05c-12d0cfa6b9fc remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.34.57" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13498 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.997" upstream_response_time="2.000" upstream_connect_time="0.000" upstream_header_time="2.000"; 1.997 GET /search/?tag=webworkers&tag=video&tag=crossdomain&tag=csstransforms&tag=geolocation&tag=offlineresources&tag=dragndrop&type=blogmark&year=2009 HTTP/1.1 200 493a4a48-6137-466e-a05c-12d0cfa6b9fc 10.1.63.160 54.161.41.102, 172.70.34.57 http 1.1 vegur 13498 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.997 2.0 0.0 2.0
302 2021-08-05T19:15:51.905668+00:00 app[web.1]: measure#nginx.service=0.382 request="GET /2016/ HTTP/1.1" status_code=200 request_id=418584df-a7cc-47c8-864d-fc121e01be8c remote_addr="10.1.63.160" forwarded_for="34.147.114.27, 141.101.104.113" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6479 referer="-" user_agent="newspaper/0.2.8" request_time="0.382" upstream_response_time="0.380" upstream_connect_time="0.000" upstream_header_time="0.380"; 0.382 GET /2016/ HTTP/1.1 200 418584df-a7cc-47c8-864d-fc121e01be8c 10.1.63.160 34.147.114.27, 141.101.104.113 http 1.1 vegur 6479 - newspaper/0.2.8 0.382 0.38 0.0 0.38
313 2021-08-05T19:15:53.702167+00:00 app[web.1]: measure#nginx.service=1.492 request="GET /2018/ HTTP/1.1" status_code=200 request_id=08d8da62-9df4-4f81-8120-c8553fddf9ae remote_addr="10.1.63.160" forwarded_for="34.147.114.27, 141.101.76.189" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6953 referer="-" user_agent="newspaper/0.2.8" request_time="1.492" upstream_response_time="1.492" upstream_connect_time="0.000" upstream_header_time="1.492"; 1.492 GET /2018/ HTTP/1.1 200 08d8da62-9df4-4f81-8120-c8553fddf9ae 10.1.63.160 34.147.114.27, 141.101.76.189 http 1.1 vegur 6953 - newspaper/0.2.8 1.492 1.492 0.0 1.492
387 2021-08-05T19:17:14.652086+00:00 app[web.1]: measure#nginx.service=8.044 request="GET /search/?tag=mozilla&tag=performance&tag=localstorage&tag=video&tag=browsers&tag=firefox35&tag=webworkers&tag=textshadow&tag=offlineresources&type=blogmark&year=2009&month=6 HTTP/1.1" status_code=200 request_id=2c61c167-ddb1-4dee-83bb-0eb3afb078be remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.35.58" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16166 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="8.044" upstream_response_time="8.044" upstream_connect_time="0.000" upstream_header_time="8.044"; 8.044 GET /search/?tag=mozilla&tag=performance&tag=localstorage&tag=video&tag=browsers&tag=firefox35&tag=webworkers&tag=textshadow&tag=offlineresources&type=blogmark&year=2009&month=6 HTTP/1.1 200 2c61c167-ddb1-4dee-83bb-0eb3afb078be 10.1.63.160 54.161.41.102, 172.70.35.58 http 1.1 vegur 16166 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 8.044 8.044 0.0 8.044
414 2021-08-05T19:17:51.072476+00:00 app[web.1]: measure#nginx.service=0.926 request="GET /search/?tag=offlineresources&tag=json&tag=tracemonkey&type=blogmark HTTP/1.1" status_code=200 request_id=d2a55505-33d2-4950-9bc2-10b144001481 remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.35.40" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8901 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="0.926" upstream_response_time="0.928" upstream_connect_time="0.000" upstream_header_time="0.928"; 0.926 GET /search/?tag=offlineresources&tag=json&tag=tracemonkey&type=blogmark HTTP/1.1 200 d2a55505-33d2-4950-9bc2-10b144001481 10.1.63.160 54.161.41.102, 172.70.35.40 http 1.1 vegur 8901 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 0.926 0.928 0.0 0.928
448 2021-08-05T19:18:50.797582+00:00 app[web.1]: measure#nginx.service=16.725 request="GET /search/?tag=browsers&tag=csstransforms&tag=video&tag=localstorage&tag=firefox&tag=html5&tag=fonts&type=blogmark HTTP/1.1" status_code=200 request_id=5068cc02-4444-47a4-95c2-e88bd74b8dae remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.34.133" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11721 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="16.725" upstream_response_time="16.724" upstream_connect_time="0.000" upstream_header_time="16.724"; 16.725 GET /search/?tag=browsers&tag=csstransforms&tag=video&tag=localstorage&tag=firefox&tag=html5&tag=fonts&type=blogmark HTTP/1.1 200 5068cc02-4444-47a4-95c2-e88bd74b8dae 10.1.63.160 54.161.41.102, 172.70.34.133 http 1.1 vegur 11721 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 16.725 16.724 0.0 16.724
460 2021-08-05T19:19:15.136925+00:00 app[web.1]: measure#nginx.service=20.592 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=b5bf893d-f88b-4a0f-a677-352c4529b26a remote_addr="10.1.63.160" forwarded_for="144.217.244.188, 172.70.127.10" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Mozilla/5.0 (compatible; YaK/1.0; http://linkfluence.com/; bot@linkfluence.com)" request_time="20.592" upstream_response_time="20.592" upstream_connect_time="0.000" upstream_header_time="20.588"; 20.592 GET /atom/links/ HTTP/1.1 200 b5bf893d-f88b-4a0f-a677-352c4529b26a 10.1.63.160 144.217.244.188, 172.70.127.10 http 1.1 vegur 16609 - Mozilla/5.0 (compatible; YaK/1.0; http://linkfluence.com/; bot@linkfluence.com) 20.592 20.592 0.0 20.588

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