19 rows where remote_addr = "10.1.55.92"

View and edit SQL

Suggested facets: 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
21 2021-08-05T19:09:15.571614+00:00 app[web.1]: measure#nginx.service=5.216 request="GET /search/?tag=fonts&tag=audio&tag=geolocation&tag=webworkers&tag=html5&tag=csstransforms&tag=json&tag=firefox35&tag=browsers&year=2009&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=54df9d8e-560a-464f-adb4-31ec9e60ed38 remote_addr="10.1.55.92" forwarded_for="54.161.41.102, 172.70.34.117" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=15464 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="5.216" upstream_response_time="5.216" upstream_connect_time="0.000" upstream_header_time="5.216"; 5.216 GET /search/?tag=fonts&tag=audio&tag=geolocation&tag=webworkers&tag=html5&tag=csstransforms&tag=json&tag=firefox35&tag=browsers&year=2009&type=blogmark&month=6 HTTP/1.1 200 54df9d8e-560a-464f-adb4-31ec9e60ed38 10.1.55.92 54.161.41.102, 172.70.34.117 http 1.1 vegur 15464 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 5.216 5.216 0.0 5.216
42 2021-08-05T19:09:52.780382+00:00 app[web.1]: measure#nginx.service=2.073 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=databases HTTP/1.1" status_code=200 request_id=b717566e-6a10-4122-aac2-2ba55dabbc1b remote_addr="10.1.55.92" forwarded_for="167.114.100.201, 172.70.126.150" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6631 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.073" upstream_response_time="2.072" upstream_connect_time="0.000" upstream_header_time="2.072"; 2.073 GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=databases HTTP/1.1 200 b717566e-6a10-4122-aac2-2ba55dabbc1b 10.1.55.92 167.114.100.201, 172.70.126.150 http 1.1 vegur 6631 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.073 2.072 0.0 2.072
98 2021-08-05T19:11:09.383849+00:00 app[web.1]: measure#nginx.service=5.492 request="GET /search/?tag=performance&tag=geolocation&tag=localstorage&tag=csstransforms&tag=textshadow&tag=html5&tag=json&tag=offlineresources&tag=fonts&type=blogmark&month=6&year=2009 HTTP/1.1" status_code=200 request_id=54380bf5-1d5a-45ee-bda6-f3fa8c7ce0ac remote_addr="10.1.55.92" forwarded_for="54.161.41.102, 172.70.35.74" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16127 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="5.492" upstream_response_time="5.492" upstream_connect_time="0.000" upstream_header_time="5.492"; 5.492 GET /search/?tag=performance&tag=geolocation&tag=localstorage&tag=csstransforms&tag=textshadow&tag=html5&tag=json&tag=offlineresources&tag=fonts&type=blogmark&month=6&year=2009 HTTP/1.1 200 54380bf5-1d5a-45ee-bda6-f3fa8c7ce0ac 10.1.55.92 54.161.41.102, 172.70.35.74 http 1.1 vegur 16127 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 5.492 5.492 0.0 5.492
100 2021-08-05T19:11:09.678735+00:00 app[web.1]: measure#nginx.service=0.113 request="GET /search/?q%3Dpostgresql&tag=apple&year=2011&month=1 HTTP/1.1" status_code=200 request_id=607ffc0d-6f80-4703-b3dc-b526a4476f53 remote_addr="10.1.55.92" forwarded_for="114.119.150.114, 172.70.142.229" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7090 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.113" upstream_response_time="0.112" upstream_connect_time="0.000" upstream_header_time="0.112"; 0.113 GET /search/?q%3Dpostgresql&tag=apple&year=2011&month=1 HTTP/1.1 200 607ffc0d-6f80-4703-b3dc-b526a4476f53 10.1.55.92 114.119.150.114, 172.70.142.229 http 1.1 vegur 7090 - 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.113 0.112 0.0 0.112
103 2021-08-05T19:11:15.963362+00:00 app[web.1]: measure#nginx.service=0.522 request="GET / HTTP/1.1" status_code=200 request_id=ef823985-b58b-4129-894d-3388768c1a56 remote_addr="10.1.55.92" forwarded_for="122.228.19.71, 172.69.35.208" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=108578 referer="http://popsmart.cn/Build/Cesium/Cesium.js" user_agent="Baiduspider+(+http://www.baidu.com/search/spider.htm)" request_time="0.522" upstream_response_time="0.524" upstream_connect_time="0.000" upstream_header_time="0.520"; 0.522 GET / HTTP/1.1 200 ef823985-b58b-4129-894d-3388768c1a56 10.1.55.92 122.228.19.71, 172.69.35.208 http 1.1 vegur 108578 http://popsmart.cn/Build/Cesium/Cesium.js Baiduspider+(+http://www.baidu.com/search/spider.htm) 0.522 0.524 0.0 0.52
115 2021-08-05T19:11:35.991838+00:00 app[web.1]: measure#nginx.service=3.014 request="GET /search/?tag=json&tag=performance&tag=crossdomain&tag=geolocation&tag=javascript&page=1&type=blogmark HTTP/1.1" status_code=200 request_id=66c6ffba-00c3-410f-a98d-cd25016ab957 remote_addr="10.1.55.92" forwarded_for="54.161.41.102, 172.70.35.48" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10709 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.014" upstream_response_time="3.016" upstream_connect_time="0.000" upstream_header_time="3.016"; 3.014 GET /search/?tag=json&tag=performance&tag=crossdomain&tag=geolocation&tag=javascript&page=1&type=blogmark HTTP/1.1 200 66c6ffba-00c3-410f-a98d-cd25016ab957 10.1.55.92 54.161.41.102, 172.70.35.48 http 1.1 vegur 10709 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.014 3.016 0.0 3.016
119 2021-08-05T19:11:39.070818+00:00 app[web.1]: measure#nginx.service=3.029 request="GET /search/?tag=geolocation&tag=json&tag=tracemonkey&tag=offlineresources&tag=crossdomain&tag=canvas&tag=firefox35&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=a9c4b885-51d7-4450-a091-8f9773c28f54 remote_addr="10.1.55.92" forwarded_for="54.161.41.102, 172.70.34.233" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13246 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.029" upstream_response_time="3.028" upstream_connect_time="0.000" upstream_header_time="3.028"; 3.029 GET /search/?tag=geolocation&tag=json&tag=tracemonkey&tag=offlineresources&tag=crossdomain&tag=canvas&tag=firefox35&type=blogmark&year=2009 HTTP/1.1 200 a9c4b885-51d7-4450-a091-8f9773c28f54 10.1.55.92 54.161.41.102, 172.70.34.233 http 1.1 vegur 13246 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.029 3.028 0.0 3.028
179 2021-08-05T19:13:24.247041+00:00 app[web.1]: measure#nginx.service=13.349 request="GET /search/?tag=webworkers&tag=json&tag=fonts&tag=geolocation&tag=firefox35&tag=textshadow&tag=video&tag=dragndrop&tag=performance&year=2009&month=6&type=blogmark HTTP/1.1" status_code=200 request_id=ca3ecee3-3ef3-4c29-b971-d9c95ca5c615 remote_addr="10.1.55.92" forwarded_for="54.161.41.102, 172.70.35.60" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=15620 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="13.349" upstream_response_time="13.348" upstream_connect_time="0.000" upstream_header_time="13.348"; 13.349 GET /search/?tag=webworkers&tag=json&tag=fonts&tag=geolocation&tag=firefox35&tag=textshadow&tag=video&tag=dragndrop&tag=performance&year=2009&month=6&type=blogmark HTTP/1.1 200 ca3ecee3-3ef3-4c29-b971-d9c95ca5c615 10.1.55.92 54.161.41.102, 172.70.35.60 http 1.1 vegur 15620 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 13.349 13.348 0.0 13.348
189 2021-08-05T19:13:31.263440+00:00 app[web.1]: measure#nginx.service=2.312 request="GET /search/?tag=mozilla&tag=html5&tag=webworkers&tag=browsers&tag=audio&tag=offlineresources&tag=firefox35&type=blogmark HTTP/1.1" status_code=200 request_id=a3849ad8-87c4-47f9-a77c-c2364c269412 remote_addr="10.1.55.92" forwarded_for="54.161.41.102, 172.70.34.209" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11891 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.312" upstream_response_time="2.316" upstream_connect_time="0.000" upstream_header_time="2.316"; 2.312 GET /search/?tag=mozilla&tag=html5&tag=webworkers&tag=browsers&tag=audio&tag=offlineresources&tag=firefox35&type=blogmark HTTP/1.1 200 a3849ad8-87c4-47f9-a77c-c2364c269412 10.1.55.92 54.161.41.102, 172.70.34.209 http 1.1 vegur 11891 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.312 2.316 0.0 2.316
223 2021-08-05T19:14:18.163742+00:00 app[web.1]: measure#nginx.service=4.494 request="GET /search/?q=django&tag=grahamdumpleton&year=2008 HTTP/1.1" status_code=200 request_id=609b918c-da29-49c2-b257-a5cb0a00adcb remote_addr="10.1.55.92" forwarded_for="114.119.137.91, 172.70.143.119" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5882 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="4.494" upstream_response_time="4.496" upstream_connect_time="0.000" upstream_header_time="4.496"; 4.494 GET /search/?q=django&tag=grahamdumpleton&year=2008 HTTP/1.1 200 609b918c-da29-49c2-b257-a5cb0a00adcb 10.1.55.92 114.119.137.91, 172.70.143.119 http 1.1 vegur 5882 - 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) 4.494 4.496 0.0 4.496
240 2021-08-05T19:14:43.485161+00:00 app[web.1]: measure#nginx.service=6.243 request="GET /search/?tag=canvas&tag=textshadow&tag=html5&tag=performance&tag=dragndrop&tag=firefox&tag=browsers&tag=tracemonkey&type=blogmark HTTP/1.1" status_code=200 request_id=f948c514-bd7e-4042-8ac9-3e87bb504109 remote_addr="10.1.55.92" forwarded_for="54.161.41.102, 172.70.34.79" 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="6.243" upstream_response_time="6.244" upstream_connect_time="0.000" upstream_header_time="6.244"; 6.243 GET /search/?tag=canvas&tag=textshadow&tag=html5&tag=performance&tag=dragndrop&tag=firefox&tag=browsers&tag=tracemonkey&type=blogmark HTTP/1.1 200 f948c514-bd7e-4042-8ac9-3e87bb504109 10.1.55.92 54.161.41.102, 172.70.34.79 http 1.1 vegur 12711 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 6.243 6.244 0.0 6.244
265 2021-08-05T19:15:17.363456+00:00 app[web.1]: measure#nginx.service=0.441 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=7134cb1a-02d7-41b2-b9a1-64be2b4e21b4 remote_addr="10.1.55.92" forwarded_for="18.215.244.20, 172.70.34.8" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Buck/2.2; (+https://app.hypefactors.com/media-monitoring/about.html)" request_time="0.441" upstream_response_time="0.444" upstream_connect_time="0.000" upstream_header_time="0.436"; 0.441 GET /atom/everything/ HTTP/1.1 200 7134cb1a-02d7-41b2-b9a1-64be2b4e21b4 10.1.55.92 18.215.244.20, 172.70.34.8 http 1.1 vegur 155913 - Buck/2.2; (+https://app.hypefactors.com/media-monitoring/about.html) 0.441 0.444 0.0 0.436
297 2021-08-05T19:15:51.290410+00:00 app[web.1]: measure#nginx.service=0.095 request="GET /2007 HTTP/1.1" status_code=301 request_id=a70f9621-a1ec-409a-8d4e-6018aed656e1 remote_addr="10.1.55.92" forwarded_for="34.147.114.27, 141.101.105.157" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.095" upstream_response_time="0.096" upstream_connect_time="0.000" upstream_header_time="0.096"; 0.095 GET /2007 HTTP/1.1 301 a70f9621-a1ec-409a-8d4e-6018aed656e1 10.1.55.92 34.147.114.27, 141.101.105.157 http 1.1 vegur 0 - newspaper/0.2.8 0.095 0.096 0.0 0.096
324 2021-08-05T19:15:55.903591+00:00 app[web.1]: measure#nginx.service=1.383 request="GET /2009/ HTTP/1.1" status_code=200 request_id=15a509e5-18cd-4723-90d0-0c5e5f645ea9 remote_addr="10.1.55.92" forwarded_for="34.147.114.27, 141.101.76.208" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5930 referer="-" user_agent="newspaper/0.2.8" request_time="1.383" upstream_response_time="1.384" upstream_connect_time="0.000" upstream_header_time="1.384"; 1.383 GET /2009/ HTTP/1.1 200 15a509e5-18cd-4723-90d0-0c5e5f645ea9 10.1.55.92 34.147.114.27, 141.101.76.208 http 1.1 vegur 5930 - newspaper/0.2.8 1.383 1.384 0.0 1.384
375 2021-08-05T19:16:53.774600+00:00 app[web.1]: measure#nginx.service=4.688 request="GET /search/?tag=canvas&tag=video&tag=fonts&tag=json&tag=mozilla&tag=textshadow&tag=webworkers&tag=browsers&tag=performance&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=c58117a7-c954-4e7b-9450-197c54f98443 remote_addr="10.1.55.92" forwarded_for="54.161.41.102, 172.70.34.89" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14418 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.688" upstream_response_time="4.688" upstream_connect_time="0.000" upstream_header_time="4.688"; 4.688 GET /search/?tag=canvas&tag=video&tag=fonts&tag=json&tag=mozilla&tag=textshadow&tag=webworkers&tag=browsers&tag=performance&type=blogmark&year=2009 HTTP/1.1 200 c58117a7-c954-4e7b-9450-197c54f98443 10.1.55.92 54.161.41.102, 172.70.34.89 http 1.1 vegur 14418 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.688 4.688 0.0 4.688
385 2021-08-05T19:17:08.816651+00:00 app[web.1]: measure#nginx.service=1.102 request="GET /static/2009/devdays-amsterdam.html HTTP/1.1" status_code=301 request_id=24d69036-dde3-412a-a0a7-684b7b70803e remote_addr="10.1.55.92" forwarded_for="5.255.231.61, 141.101.77.87" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)" request_time="1.102" upstream_response_time="1.104" upstream_connect_time="0.000" upstream_header_time="1.104"; 1.102 GET /static/2009/devdays-amsterdam.html HTTP/1.1 301 24d69036-dde3-412a-a0a7-684b7b70803e 10.1.55.92 5.255.231.61, 141.101.77.87 http 1.1 vegur 0 - Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) 1.102 1.104 0.0 1.104
392 2021-08-05T19:17:19.177629+00:00 app[web.1]: measure#nginx.service=0.118 request="GET /search/?q%3Dpostgresql&tag=jsk&page=1&type=entry&year=2020 HTTP/1.1" status_code=200 request_id=3fdd836b-5bfc-4c22-8b9b-3a276c2addb7 remote_addr="10.1.55.92" forwarded_for="114.119.148.197, 172.70.143.79" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8823 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/?q%3Dpostgresql&tag=jsk&page=1&type=entry&year=2020 HTTP/1.1 200 3fdd836b-5bfc-4c22-8b9b-3a276c2addb7 10.1.55.92 114.119.148.197, 172.70.143.79 http 1.1 vegur 8823 - 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
420 2021-08-05T19:18:00.937678+00:00 app[web.1]: measure#nginx.service=2.998 request="GET /search/?tag=charlesmiller&tag=macbookair&tag=apple&tag=ipodmini&page=1 HTTP/1.1" status_code=200 request_id=6cf4a3be-53e4-40eb-ab98-3d8464f331d1 remote_addr="10.1.55.92" forwarded_for="157.55.39.163, 162.158.107.221" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6372 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="2.998" upstream_response_time="2.996" upstream_connect_time="0.000" upstream_header_time="2.996"; 2.998 GET /search/?tag=charlesmiller&tag=macbookair&tag=apple&tag=ipodmini&page=1 HTTP/1.1 200 6cf4a3be-53e4-40eb-ab98-3d8464f331d1 10.1.55.92 157.55.39.163, 162.158.107.221 http 1.1 vegur 6372 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 2.998 2.996 0.0 2.996
426 2021-08-05T19:18:13.647472+00:00 app[web.1]: measure#nginx.service=9.805 request="GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=databases HTTP/1.1" status_code=200 request_id=e5a8e3e9-139c-4ac1-9d10-e124e5b97dc7 remote_addr="10.1.55.92" forwarded_for="167.114.100.201, 172.70.126.2" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6685 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="9.805" upstream_response_time="9.808" upstream_connect_time="0.000" upstream_header_time="9.808"; 9.805 GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=databases HTTP/1.1 200 e5a8e3e9-139c-4ac1-9d10-e124e5b97dc7 10.1.55.92 167.114.100.201, 172.70.126.2 http 1.1 vegur 6685 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 9.805 9.808 0.0 9.808

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