17 rows where remote_addr = "10.1.87.198"

View and edit SQL

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

remote_addr

  • 10.1.87.198 · 17
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
22 2021-08-05T19:09:16.767505+00:00 app[web.1]: measure#nginx.service=0.117 request="GET /search/?q%3Dpostgresql&page=1&tag=mapmaker&year=2010&type=blogmark&month=3 HTTP/1.1" status_code=200 request_id=94eb83cb-53cc-421e-a33e-edaa17d5eb4e remote_addr="10.1.87.198" forwarded_for="114.119.131.33, 172.70.142.95" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6717 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.117" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; 0.117 GET /search/?q%3Dpostgresql&page=1&tag=mapmaker&year=2010&type=blogmark&month=3 HTTP/1.1 200 94eb83cb-53cc-421e-a33e-edaa17d5eb4e 10.1.87.198 114.119.131.33, 172.70.142.95 http 1.1 vegur 6717 - 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.117 0.12 0.0 0.12
24 2021-08-05T19:09:21.217186+00:00 app[web.1]: measure#nginx.service=1.960 request="GET /search/?tag=firefox&tag=csstransforms&tag=firefox35&tag=json&tag=textshadow&tag=webworkers&tag=javascript&type=blogmark HTTP/1.1" status_code=200 request_id=468b0048-d9d3-4cd5-a91d-f072ae3fdc8b remote_addr="10.1.87.198" forwarded_for="54.161.41.102, 172.70.35.70" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11993 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.960" upstream_response_time="1.960" upstream_connect_time="0.000" upstream_header_time="1.960"; 1.96 GET /search/?tag=firefox&tag=csstransforms&tag=firefox35&tag=json&tag=textshadow&tag=webworkers&tag=javascript&type=blogmark HTTP/1.1 200 468b0048-d9d3-4cd5-a91d-f072ae3fdc8b 10.1.87.198 54.161.41.102, 172.70.35.70 http 1.1 vegur 11993 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.96 1.96 0.0 1.96
41 2021-08-05T19:09:50.226833+00:00 app[web.1]: measure#nginx.service=0.055 request="GET /rss HTTP/1.1" status_code=301 request_id=5ad0d9cf-0499-47ac-af9f-2111db00fbb3 remote_addr="10.1.87.198" forwarded_for="2a01:e34:ec95:f440:44b3:beed:96e3:1fa6, 141.101.68.37" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="okhttp/4.9.1" request_time="0.055" upstream_response_time="0.052" upstream_connect_time="0.000" upstream_header_time="0.052"; 0.055 GET /rss HTTP/1.1 301 5ad0d9cf-0499-47ac-af9f-2111db00fbb3 10.1.87.198 2a01:e34:ec95:f440:44b3:beed:96e3:1fa6, 141.101.68.37 http 1.1 vegur 5 - okhttp/4.9.1 0.055 0.052 0.0 0.052
73 2021-08-05T19:10:38.576473+00:00 app[web.1]: measure#nginx.service=0.136 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=13564551-d7e9-40ab-b2ce-20180333ee9d remote_addr="10.1.87.198" forwarded_for="92.247.181.12, 172.68.110.114" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="https://simonwillison.net/" user_agent="Mozilla/5.0 (compatible; inoreader.com; 9 subscribers)" request_time="0.136" upstream_response_time="0.136" upstream_connect_time="0.000" upstream_header_time="0.132"; 0.136 GET /atom/links/ HTTP/1.1 200 13564551-d7e9-40ab-b2ce-20180333ee9d 10.1.87.198 92.247.181.12, 172.68.110.114 http 1.1 vegur 16609 https://simonwillison.net/ Mozilla/5.0 (compatible; inoreader.com; 9 subscribers) 0.136 0.136 0.0 0.132
76 2021-08-05T19:10:41.735312+00:00 app[web.1]: measure#nginx.service=1.293 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=143510c6-47f8-42e2-8260-42b3f2d1f589 remote_addr="10.1.87.198" 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="1.293" upstream_response_time="1.296" upstream_connect_time="0.000" upstream_header_time="1.292"; 1.293 GET /atom/links/ HTTP/1.1 200 143510c6-47f8-42e2-8260-42b3f2d1f589 10.1.87.198 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) 1.293 1.296 0.0 1.292
93 2021-08-05T19:10:58.589971+00:00 app[web.1]: measure#nginx.service=0.063 request="GET /search/?month=11&type=entry&year=2017&tag=scraping HTTP/1.1" status_code=200 request_id=ea7532ac-61a2-4041-aca2-0403b128e8e6 remote_addr="10.1.87.198" forwarded_for="114.119.156.46, 172.70.142.176" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6813 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.063" upstream_response_time="0.064" upstream_connect_time="0.000" upstream_header_time="0.064"; 0.063 GET /search/?month=11&type=entry&year=2017&tag=scraping HTTP/1.1 200 ea7532ac-61a2-4041-aca2-0403b128e8e6 10.1.87.198 114.119.156.46, 172.70.142.176 http 1.1 vegur 6813 - 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.063 0.064 0.0 0.064
94 2021-08-05T19:10:59.201248+00:00 app[web.1]: measure#nginx.service=0.214 request="GET /search/?tag=async&tag=nosql HTTP/1.1" status_code=200 request_id=930720c7-32b7-4a37-87be-a6871289fe4f remote_addr="10.1.87.198" forwarded_for="158.69.243.99, 172.70.126.6" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7002 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.214" upstream_response_time="0.212" upstream_connect_time="0.000" upstream_header_time="0.212"; 0.214 GET /search/?tag=async&tag=nosql HTTP/1.1 200 930720c7-32b7-4a37-87be-a6871289fe4f 10.1.87.198 158.69.243.99, 172.70.126.6 http 1.1 vegur 7002 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.214 0.212 0.0 0.212
128 2021-08-05T19:11:58.314323+00:00 app[web.1]: measure#nginx.service=6.630 request="GET /search/?tag=performance&tag=dragndrop&tag=offlineresources&tag=fonts&tag=firefox35&tag=browsers&tag=textshadow&tag=html5&tag=javascript&type=blogmark HTTP/1.1" status_code=200 request_id=80d588ce-dcc0-4a9c-a55c-8b09901ce785 remote_addr="10.1.87.198" forwarded_for="54.161.41.102, 172.70.34.175" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13887 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="6.630" upstream_response_time="6.628" upstream_connect_time="0.000" upstream_header_time="6.628"; 6.63 GET /search/?tag=performance&tag=dragndrop&tag=offlineresources&tag=fonts&tag=firefox35&tag=browsers&tag=textshadow&tag=html5&tag=javascript&type=blogmark HTTP/1.1 200 80d588ce-dcc0-4a9c-a55c-8b09901ce785 10.1.87.198 54.161.41.102, 172.70.34.175 http 1.1 vegur 13887 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 6.63 6.628 0.0 6.628
174 2021-08-05T19:13:15.356320+00:00 app[web.1]: measure#nginx.service=5.342 request="GET /search/?tag=adobe&year=2009&type=quotation HTTP/1.1" status_code=200 request_id=5d57db3b-16e5-4ffd-8add-fb4fc3084374 remote_addr="10.1.87.198" forwarded_for="114.119.147.150, 172.70.143.72" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5843 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.342" upstream_response_time="5.344" upstream_connect_time="0.000" upstream_header_time="5.344"; 5.342 GET /search/?tag=adobe&year=2009&type=quotation HTTP/1.1 200 5d57db3b-16e5-4ffd-8add-fb4fc3084374 10.1.87.198 114.119.147.150, 172.70.143.72 http 1.1 vegur 5843 - 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.342 5.344 0.0 5.344
176 2021-08-05T19:13:18.391890+00:00 app[web.1]: measure#nginx.service=4.054 request="GET /tags/german/ HTTP/1.1" status_code=200 request_id=fe70a403-8600-48e8-90bd-ff7ec5d40232 remote_addr="10.1.87.198" forwarded_for="185.191.171.25, 172.70.34.113" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=3532 referer="-" user_agent="Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html)" request_time="4.054" upstream_response_time="4.056" upstream_connect_time="0.000" upstream_header_time="4.056"; 4.054 GET /tags/german/ HTTP/1.1 200 fe70a403-8600-48e8-90bd-ff7ec5d40232 10.1.87.198 185.191.171.25, 172.70.34.113 http 1.1 vegur 3532 - Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) 4.054 4.056 0.0 4.056
182 2021-08-05T19:13:24.856403+00:00 app[web.1]: measure#nginx.service=1.922 request="GET /2006/Feb/26/django/ HTTP/1.1" status_code=200 request_id=2f76347f-4cb0-4593-a5e5-2cc3f003ca19 remote_addr="10.1.87.198" forwarded_for="185.191.171.5, 172.70.35.65" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=3458 referer="-" user_agent="Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html)" request_time="1.922" upstream_response_time="1.924" upstream_connect_time="0.000" upstream_header_time="1.924"; 1.922 GET /2006/Feb/26/django/ HTTP/1.1 200 2f76347f-4cb0-4593-a5e5-2cc3f003ca19 10.1.87.198 185.191.171.5, 172.70.35.65 http 1.1 vegur 3458 - Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html) 1.922 1.924 0.0 1.924
196 2021-08-05T19:13:42.520262+00:00 app[web.1]: measure#nginx.service=2.386 request="GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=benchmarks HTTP/1.1" status_code=200 request_id=cec3b56a-c36a-4da1-b9fa-ab0dd7f16717 remote_addr="10.1.87.198" forwarded_for="167.114.100.201, 172.70.126.104" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6758 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.386" upstream_response_time="2.388" upstream_connect_time="0.000" upstream_header_time="2.388"; 2.386 GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=benchmarks HTTP/1.1 200 cec3b56a-c36a-4da1-b9fa-ab0dd7f16717 10.1.87.198 167.114.100.201, 172.70.126.104 http 1.1 vegur 6758 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.386 2.388 0.0 2.388
314 2021-08-05T19:15:53.758652+00:00 app[web.1]: measure#nginx.service=1.463 request="GET /2010 HTTP/1.1" status_code=301 request_id=350a63e7-e734-493b-9120-b1fb78ae9497 remote_addr="10.1.87.198" forwarded_for="34.147.114.27, 162.158.111.199" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="1.463" upstream_response_time="1.460" upstream_connect_time="0.000" upstream_header_time="1.460"; 1.463 GET /2010 HTTP/1.1 301 350a63e7-e734-493b-9120-b1fb78ae9497 10.1.87.198 34.147.114.27, 162.158.111.199 http 1.1 vegur 0 - newspaper/0.2.8 1.463 1.46 0.0 1.46
319 2021-08-05T19:15:54.321365+00:00 app[web.1]: measure#nginx.service=1.037 request="GET /2009 HTTP/1.1" status_code=301 request_id=a9c65811-0198-45eb-bf8e-e8afe19c478a remote_addr="10.1.87.198" forwarded_for="34.147.114.27, 172.69.54.231" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="1.037" upstream_response_time="1.036" upstream_connect_time="0.000" upstream_header_time="1.036"; 1.037 GET /2009 HTTP/1.1 301 a9c65811-0198-45eb-bf8e-e8afe19c478a 10.1.87.198 34.147.114.27, 172.69.54.231 http 1.1 vegur 0 - newspaper/0.2.8 1.037 1.036 0.0 1.036
329 2021-08-05T19:16:04.068427+00:00 app[web.1]: measure#nginx.service=7.351 request="GET /feed HTTP/1.1" status_code=404 request_id=e48b8b46-5175-4f7e-83bf-2d1d527a9d1e remote_addr="10.1.87.198" forwarded_for="34.147.114.27, 141.101.76.155" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=179 referer="-" user_agent="newspaper/0.2.8" request_time="7.351" upstream_response_time="7.352" upstream_connect_time="0.000" upstream_header_time="7.352"; 7.351 GET /feed HTTP/1.1 404 e48b8b46-5175-4f7e-83bf-2d1d527a9d1e 10.1.87.198 34.147.114.27, 141.101.76.155 http 1.1 vegur 179 - newspaper/0.2.8 7.351 7.352 0.0 7.352
408 2021-08-05T19:17:43.836119+00:00 app[web.1]: measure#nginx.service=6.823 request="GET /search/?tag=crossdomain&tag=json&tag=canvas&tag=html5&tag=csstransforms&tag=audio&tag=javascript&tag=geolocation&tag=offlineresources&type=blogmark HTTP/1.1" status_code=200 request_id=64115ff7-67cf-49d8-abb0-36f17b3da861 remote_addr="10.1.87.198" forwarded_for="54.161.41.102, 172.70.34.155" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13815 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="6.823" upstream_response_time="6.824" upstream_connect_time="0.000" upstream_header_time="6.824"; 6.823 GET /search/?tag=crossdomain&tag=json&tag=canvas&tag=html5&tag=csstransforms&tag=audio&tag=javascript&tag=geolocation&tag=offlineresources&type=blogmark HTTP/1.1 200 64115ff7-67cf-49d8-abb0-36f17b3da861 10.1.87.198 54.161.41.102, 172.70.34.155 http 1.1 vegur 13815 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 6.823 6.824 0.0 6.824
432 2021-08-05T19:18:16.996045+00:00 app[web.1]: measure#nginx.service=2.177 request="GET /tags/gis/ HTTP/1.1" status_code=200 request_id=4b2c19bb-4827-41b3-bef5-2d1d016ef24c remote_addr="10.1.87.198" forwarded_for="207.46.13.186, 108.162.246.141" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=25418 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="2.177" upstream_response_time="2.180" upstream_connect_time="0.000" upstream_header_time="2.180"; 2.177 GET /tags/gis/ HTTP/1.1 200 4b2c19bb-4827-41b3-bef5-2d1d016ef24c 10.1.87.198 207.46.13.186, 108.162.246.141 http 1.1 vegur 25418 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 2.177 2.18 0.0 2.18

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