log
17 rows where remote_addr = "10.1.87.198" sorted by request_time descending
This data as json, CSV (advanced)
Suggested facets: request, status_code, body_bytes_sent, user_agent
referer ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
329 | 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 | 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 |
128 | 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 | 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 | 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 |
196 | 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 |
432 | 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 |
24 | 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 |
182 | 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 |
314 | 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 |
76 | 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 |
319 | 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 |
94 | 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 |
73 | 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 |
22 | 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 |
93 | 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 |
41 | 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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );