13 rows where remote_addr = "10.1.27.43"

View and edit SQL

Suggested facets: request, body_bytes_sent, user_agent

remote_addr

  • 10.1.27.43 · 13
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
8 2021-08-05T19:09:01.529601+00:00 app[web.1]: measure#nginx.service=11.287 request="GET /search/?tag=audio&tag=dragndrop&tag=fonts&tag=firefox&tag=html5&tag=mozilla&tag=offlineresources&tag=javascript&tag=canvas&tag=tracemonkey&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=c5e60a6c-d8c5-4220-8a57-e0aa9630e545 remote_addr="10.1.27.43" forwarded_for="54.161.41.102, 172.70.34.51" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=15652 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="11.287" upstream_response_time="11.288" upstream_connect_time="0.000" upstream_header_time="11.288"; 11.287 GET /search/?tag=audio&tag=dragndrop&tag=fonts&tag=firefox&tag=html5&tag=mozilla&tag=offlineresources&tag=javascript&tag=canvas&tag=tracemonkey&year=2009&type=blogmark HTTP/1.1 200 c5e60a6c-d8c5-4220-8a57-e0aa9630e545 10.1.27.43 54.161.41.102, 172.70.34.51 http 1.1 vegur 15652 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 11.287 11.288 0.0 11.288
80 2021-08-05T19:10:44.106852+00:00 app[web.1]: measure#nginx.service=0.112 request="GET /search/?type=blogmark&month=9&tag=wiki&year=2007 HTTP/1.1" status_code=200 request_id=0bff7c11-5d36-4d1b-95bf-38516d0d570a remote_addr="10.1.27.43" forwarded_for="114.119.135.163, 172.70.143.95" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8060 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.112" upstream_response_time="0.112" upstream_connect_time="0.000" upstream_header_time="0.112"; 0.112 GET /search/?type=blogmark&month=9&tag=wiki&year=2007 HTTP/1.1 200 0bff7c11-5d36-4d1b-95bf-38516d0d570a 10.1.27.43 114.119.135.163, 172.70.143.95 http 1.1 vegur 8060 - 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.112 0.112 0.0 0.112
116 2021-08-05T19:11:36.139211+00:00 app[web.1]: measure#nginx.service=3.370 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=schemaless HTTP/1.1" status_code=200 request_id=6eef5379-6c2a-45cd-ad65-cd0f162b95ec remote_addr="10.1.27.43" forwarded_for="167.114.100.201, 172.70.126.218" 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="3.370" upstream_response_time="3.368" upstream_connect_time="0.000" upstream_header_time="3.368"; 3.37 GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=schemaless HTTP/1.1 200 6eef5379-6c2a-45cd-ad65-cd0f162b95ec 10.1.27.43 167.114.100.201, 172.70.126.218 http 1.1 vegur 6649 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 3.37 3.368 0.0 3.368
219 2021-08-05T19:14:09.829984+00:00 app[web.1]: measure#nginx.service=0.861 request="GET /search/?tag=libraries&year=2008&page=1&month=2 HTTP/1.1" status_code=200 request_id=1bb21746-6e74-4d57-8a1d-06edebc3bb83 remote_addr="10.1.27.43" forwarded_for="114.119.157.22, 172.70.142.229" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7259 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.861" upstream_response_time="0.860" upstream_connect_time="0.000" upstream_header_time="0.860"; 0.861 GET /search/?tag=libraries&year=2008&page=1&month=2 HTTP/1.1 200 1bb21746-6e74-4d57-8a1d-06edebc3bb83 10.1.27.43 114.119.157.22, 172.70.142.229 http 1.1 vegur 7259 - 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.861 0.86 0.0 0.86
259 2021-08-05T19:15:10.267726+00:00 app[web.1]: measure#nginx.service=3.426 request="GET /search/?tag=offlineresources&tag=webworkers&tag=tracemonkey&tag=json&tag=firefox&tag=javascript&tag=mozilla&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=3ade3112-639b-4395-9c30-5de928cccf28 remote_addr="10.1.27.43" forwarded_for="54.161.41.102, 172.70.34.109" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13138 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.426" upstream_response_time="3.428" upstream_connect_time="0.000" upstream_header_time="3.428"; 3.426 GET /search/?tag=offlineresources&tag=webworkers&tag=tracemonkey&tag=json&tag=firefox&tag=javascript&tag=mozilla&type=blogmark&year=2009 HTTP/1.1 200 3ade3112-639b-4395-9c30-5de928cccf28 10.1.27.43 54.161.41.102, 172.70.34.109 http 1.1 vegur 13138 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.426 3.428 0.0 3.428
281 2021-08-05T19:15:34.052655+00:00 app[web.1]: measure#nginx.service=0.224 request="GET /search/?q%3Dpostgresql&tag=javascript&month=6&year=2010 HTTP/1.1" status_code=200 request_id=d3511bb1-81fb-43c2-bcb0-cd7740c54ad5 remote_addr="10.1.27.43" forwarded_for="114.119.146.244, 172.70.142.4" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8481 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.224" upstream_response_time="0.224" upstream_connect_time="0.000" upstream_header_time="0.224"; 0.224 GET /search/?q%3Dpostgresql&tag=javascript&month=6&year=2010 HTTP/1.1 200 d3511bb1-81fb-43c2-bcb0-cd7740c54ad5 10.1.27.43 114.119.146.244, 172.70.142.4 http 1.1 vegur 8481 - 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.224 0.224 0.0 0.224
321 2021-08-05T19:15:54.752233+00:00 app[web.1]: measure#nginx.service=0.780 request="GET /2010/ HTTP/1.1" status_code=200 request_id=ea187806-84ae-4285-9e3b-030547e0ed17 remote_addr="10.1.27.43" forwarded_for="34.147.114.27, 172.69.54.123" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=25139 referer="-" user_agent="newspaper/0.2.8" request_time="0.780" upstream_response_time="0.780" upstream_connect_time="0.000" upstream_header_time="0.780"; 0.78 GET /2010/ HTTP/1.1 200 ea187806-84ae-4285-9e3b-030547e0ed17 10.1.27.43 34.147.114.27, 172.69.54.123 http 1.1 vegur 25139 - newspaper/0.2.8 0.78 0.78 0.0 0.78
351 2021-08-05T19:16:25.138595+00:00 app[web.1]: measure#nginx.service=1.204 request="GET /search/?tag=localstorage&tag=textshadow&tag=canvas&tag=tracemonkey&tag=json&tag=geolocation&year=2009&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=b03eec85-fe95-4584-a6f4-6a9dbf790466 remote_addr="10.1.27.43" forwarded_for="54.161.41.102, 172.70.35.66" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12974 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.204" upstream_response_time="1.204" upstream_connect_time="0.000" upstream_header_time="1.204"; 1.204 GET /search/?tag=localstorage&tag=textshadow&tag=canvas&tag=tracemonkey&tag=json&tag=geolocation&year=2009&type=blogmark&month=6 HTTP/1.1 200 b03eec85-fe95-4584-a6f4-6a9dbf790466 10.1.27.43 54.161.41.102, 172.70.35.66 http 1.1 vegur 12974 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.204 1.204 0.0 1.204
411 2021-08-05T19:17:46.091796+00:00 app[web.1]: measure#nginx.service=0.147 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=63471148-c4d5-458d-a02a-bf2f738dbe5f remote_addr="10.1.27.43" forwarded_for="8.29.198.26, 172.69.35.175" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Feedly/1.0 (+http://www.feedly.com/fetcher.html; 15 subscribers; like FeedFetcher-Google)" request_time="0.147" upstream_response_time="0.148" upstream_connect_time="0.000" upstream_header_time="0.140"; 0.147 GET /atom/links/ HTTP/1.1 200 63471148-c4d5-458d-a02a-bf2f738dbe5f 10.1.27.43 8.29.198.26, 172.69.35.175 http 1.1 vegur 16609 - Feedly/1.0 (+http://www.feedly.com/fetcher.html; 15 subscribers; like FeedFetcher-Google) 0.147 0.148 0.0 0.14
413 2021-08-05T19:17:50.781175+00:00 app[web.1]: measure#nginx.service=1.247 request="GET /search/?tag=fbml&tag=xfbml&tag=security HTTP/1.1" status_code=200 request_id=63ca0c3b-c93a-4871-b986-cff7fe7bc861 remote_addr="10.1.27.43" forwarded_for="13.66.139.0, 108.162.246.200" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6100 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.247" upstream_response_time="1.248" upstream_connect_time="0.000" upstream_header_time="1.248"; 1.247 GET /search/?tag=fbml&tag=xfbml&tag=security HTTP/1.1 200 63ca0c3b-c93a-4871-b986-cff7fe7bc861 10.1.27.43 13.66.139.0, 108.162.246.200 http 1.1 vegur 6100 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 1.247 1.248 0.0 1.248
421 2021-08-05T19:18:01.038637+00:00 app[web.1]: measure#nginx.service=0.416 request="GET /search/?q%3Dpostgresql&type=blogmark&tag=changeset HTTP/1.1" status_code=200 request_id=546397c4-098e-4752-b17d-6388f74bb850 remote_addr="10.1.27.43" forwarded_for="114.119.134.231, 172.70.143.35" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5679 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.416" upstream_response_time="0.416" upstream_connect_time="0.000" upstream_header_time="0.416"; 0.416 GET /search/?q%3Dpostgresql&type=blogmark&tag=changeset HTTP/1.1 200 546397c4-098e-4752-b17d-6388f74bb850 10.1.27.43 114.119.134.231, 172.70.143.35 http 1.1 vegur 5679 - 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.416 0.416 0.0 0.416
427 2021-08-05T19:18:13.909067+00:00 app[web.1]: measure#nginx.service=4.494 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=87e736e7-921e-44cf-99c4-92be5a072e23 remote_addr="10.1.27.43" forwarded_for="140.238.240.248, 172.68.155.147" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="NextCloud-News/1.0" request_time="4.494" upstream_response_time="4.496" upstream_connect_time="0.000" upstream_header_time="4.492"; 4.494 GET /atom/everything/ HTTP/1.1 200 87e736e7-921e-44cf-99c4-92be5a072e23 10.1.27.43 140.238.240.248, 172.68.155.147 http 1.1 vegur 155913 - NextCloud-News/1.0 4.494 4.496 0.0 4.492
438 2021-08-05T19:18:43.005610+00:00 app[web.1]: measure#nginx.service=19.921 request="GET /search/?tag=audio&tag=dragndrop&tag=fonts&tag=firefox&tag=html5&tag=mozilla&tag=offlineresources&tag=javascript&tag=canvas&tag=tracemonkey&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=81b87f0b-ceba-404c-ae19-7648cccaf335 remote_addr="10.1.27.43" forwarded_for="73.189.212.18, 172.70.98.73" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=15652 referer="-" user_agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:89.0) Gecko/20100101 Firefox/89.0" request_time="19.921" upstream_response_time="19.920" upstream_connect_time="0.000" upstream_header_time="19.920"; 19.921 GET /search/?tag=audio&tag=dragndrop&tag=fonts&tag=firefox&tag=html5&tag=mozilla&tag=offlineresources&tag=javascript&tag=canvas&tag=tracemonkey&year=2009&type=blogmark HTTP/1.1 200 81b87f0b-ceba-404c-ae19-7648cccaf335 10.1.27.43 73.189.212.18, 172.70.98.73 http 1.1 vegur 15652 - Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:89.0) Gecko/20100101 Firefox/89.0 19.921 19.92 0.0 19.92

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