log
17 rows where remote_addr = "10.1.3.226" sorted by request_time descending
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44 | 44 | 2021-08-05T19:09:55.625157+00:00 app[web.1]: measure#nginx.service=6.484 request="GET /search/?tag=json&tag=localstorage&tag=firefox35&tag=video&tag=fonts&tag=geolocation&tag=textshadow&tag=firefox&tag=offlineresources&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=c8f6d3e5-98b5-42c4-bd4a-6c944274ee0c remote_addr="10.1.3.226" forwarded_for="54.161.41.102, 172.70.34.101" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14624 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="6.484" upstream_response_time="6.484" upstream_connect_time="0.000" upstream_header_time="6.484"; | 6.484 | GET /search/?tag=json&tag=localstorage&tag=firefox35&tag=video&tag=fonts&tag=geolocation&tag=textshadow&tag=firefox&tag=offlineresources&type=blogmark&month=6 HTTP/1.1 | 200 | c8f6d3e5-98b5-42c4-bd4a-6c944274ee0c | 10.1.3.226 | 54.161.41.102, 172.70.34.101 | http | 1.1 vegur | 14624 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 6.484 | 6.484 | 0.0 | 6.484 |
| 412 | 412 | 2021-08-05T19:17:50.127633+00:00 app[web.1]: measure#nginx.service=3.110 request="GET /search/?tag=browsers&tag=dragndrop&tag=video&tag=localstorage&tag=json&tag=textshadow&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=42ad2eb7-0994-4c31-a155-95e11b13e20a remote_addr="10.1.3.226" forwarded_for="54.161.41.102, 172.70.34.123" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11949 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.110" upstream_response_time="3.112" upstream_connect_time="0.000" upstream_header_time="3.112"; | 3.11 | GET /search/?tag=browsers&tag=dragndrop&tag=video&tag=localstorage&tag=json&tag=textshadow&year=2009&type=blogmark HTTP/1.1 | 200 | 42ad2eb7-0994-4c31-a155-95e11b13e20a | 10.1.3.226 | 54.161.41.102, 172.70.34.123 | http | 1.1 vegur | 11949 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 3.11 | 3.112 | 0.0 | 3.112 |
| 65 | 65 | 2021-08-05T19:10:25.897948+00:00 app[web.1]: measure#nginx.service=2.962 request="GET /search/?tag=firefox&tag=localstorage&tag=crossdomain&tag=dragndrop&tag=video&tag=html5&tag=tracemonkey&tag=performance&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=ea41354b-6201-4cad-9567-9416d318bff8 remote_addr="10.1.3.226" forwarded_for="54.161.41.102, 172.70.35.74" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13972 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.962" upstream_response_time="2.960" upstream_connect_time="0.000" upstream_header_time="2.960"; | 2.962 | GET /search/?tag=firefox&tag=localstorage&tag=crossdomain&tag=dragndrop&tag=video&tag=html5&tag=tracemonkey&tag=performance&year=2009&type=blogmark HTTP/1.1 | 200 | ea41354b-6201-4cad-9567-9416d318bff8 | 10.1.3.226 | 54.161.41.102, 172.70.35.74 | http | 1.1 vegur | 13972 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 2.962 | 2.96 | 0.0 | 2.96 |
| 197 | 197 | 2021-08-05T19:13:42.914062+00:00 app[web.1]: measure#nginx.service=2.464 request="GET / HTTP/1.1" status_code=200 request_id=0b2bedbe-f9bf-4ccb-80a5-6360fccf3bd8 remote_addr="10.1.3.226" forwarded_for="34.71.236.85, 172.70.130.27" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=108602 referer="http://simonwillison.net/" user_agent="Go-http-client/2.0" request_time="2.464" upstream_response_time="2.464" upstream_connect_time="0.000" upstream_header_time="2.464"; | 2.464 | GET / HTTP/1.1 | 200 | 0b2bedbe-f9bf-4ccb-80a5-6360fccf3bd8 | 10.1.3.226 | 34.71.236.85, 172.70.130.27 | http | 1.1 vegur | 108602 | http://simonwillison.net/ | Go-http-client/2.0 | 2.464 | 2.464 | 0.0 | 2.464 |
| 224 | 224 | 2021-08-05T19:14:18.551893+00:00 app[web.1]: measure#nginx.service=1.980 request="GET /tags/projects/ HTTP/1.1" status_code=200 request_id=812b6003-2ed8-4984-b31f-9172da409c7d remote_addr="10.1.3.226" forwarded_for="207.46.13.87, 108.162.245.224" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=33823 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.980" upstream_response_time="1.980" upstream_connect_time="0.000" upstream_header_time="1.980"; | 1.98 | GET /tags/projects/ HTTP/1.1 | 200 | 812b6003-2ed8-4984-b31f-9172da409c7d | 10.1.3.226 | 207.46.13.87, 108.162.245.224 | http | 1.1 vegur | 33823 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 1.98 | 1.98 | 0.0 | 1.98 |
| 256 | 256 | 2021-08-05T19:15:08.816829+00:00 app[web.1]: measure#nginx.service=1.890 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=b75dea83-7ccb-4e34-a848-a37542d48a43 remote_addr="10.1.3.226" forwarded_for="2a00:23c7:9f0e:ca00:2105:5019:4eb8:8810, 162.158.92.96" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:89.0) Gecko/20100101 Firefox/89.0" request_time="1.890" upstream_response_time="1.892" upstream_connect_time="0.000" upstream_header_time="1.888"; | 1.89 | GET /atom/everything/ HTTP/1.1 | 200 | b75dea83-7ccb-4e34-a848-a37542d48a43 | 10.1.3.226 | 2a00:23c7:9f0e:ca00:2105:5019:4eb8:8810, 162.158.92.96 | http | 1.1 vegur | 155913 | - | Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:89.0) Gecko/20100101 Firefox/89.0 | 1.89 | 1.892 | 0.0 | 1.888 |
| 31 | 31 | 2021-08-05T19:09:32.833352+00:00 app[web.1]: measure#nginx.service=0.328 request="GET /search/?year=2008&month=6&tag=basecamp HTTP/1.1" status_code=200 request_id=b74ef974-52f8-49ce-92d7-92e76b287165 remote_addr="10.1.3.226" forwarded_for="114.119.152.149, 162.158.166.166" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6280 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.328" upstream_response_time="0.328" upstream_connect_time="0.000" upstream_header_time="0.328"; | 0.328 | GET /search/?year=2008&month=6&tag=basecamp HTTP/1.1 | 200 | b74ef974-52f8-49ce-92d7-92e76b287165 | 10.1.3.226 | 114.119.152.149, 162.158.166.166 | http | 1.1 vegur | 6280 | - | 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.328 | 0.328 | 0.0 | 0.328 |
| 356 | 356 | 2021-08-05T19:16:28.723575+00:00 app[web.1]: measure#nginx.service=0.293 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=6fc278c6-7bb9-47f8-a992-9b4249f88aff remote_addr="10.1.3.226" forwarded_for="167.71.26.162, 172.70.114.104" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="NewsBlur Feed Fetcher - 555 subscribers - http://www.newsblur.com/site/5020414/simon-willisons-weblog (\x22Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.1 Safari/605.1.15\x22)" request_time="0.293" upstream_response_time="0.296" upstream_connect_time="0.000" upstream_header_time="0.288"; | 0.293 | GET /atom/everything/ HTTP/1.1 | 200 | 6fc278c6-7bb9-47f8-a992-9b4249f88aff | 10.1.3.226 | 167.71.26.162, 172.70.114.104 | http | 1.1 vegur | 155913 | - | NewsBlur Feed Fetcher - 555 subscribers - http://www.newsblur.com/site/5020414/simon-willisons-weblog (\x22Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0.1 Safari/605.1.15\x22) | 0.293 | 0.296 | 0.0 | 0.288 |
| 154 | 154 | 2021-08-05T19:12:38.291955+00:00 app[web.1]: measure#nginx.service=0.279 request="GET /search/?tag=async&tag=perlbal HTTP/1.1" status_code=200 request_id=02f1c764-66be-4ca2-ade9-6f7d691489b4 remote_addr="10.1.3.226" forwarded_for="158.69.243.99, 172.70.126.134" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5776 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.279" upstream_response_time="0.280" upstream_connect_time="0.000" upstream_header_time="0.280"; | 0.279 | GET /search/?tag=async&tag=perlbal HTTP/1.1 | 200 | 02f1c764-66be-4ca2-ade9-6f7d691489b4 | 10.1.3.226 | 158.69.243.99, 172.70.126.134 | http | 1.1 vegur | 5776 | - | Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) | 0.279 | 0.28 | 0.0 | 0.28 |
| 274 | 274 | 2021-08-05T19:15:25.162779+00:00 app[web.1]: measure#nginx.service=0.230 request="GET /search/?tag=ssh&tag=douglasbowman&year=2005 HTTP/1.1" status_code=200 request_id=89776c18-3dc3-40ce-8c58-e856f0dfcca5 remote_addr="10.1.3.226" forwarded_for="13.66.139.0, 108.162.246.8" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5654 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.230" upstream_response_time="0.228" upstream_connect_time="0.000" upstream_header_time="0.228"; | 0.23 | GET /search/?tag=ssh&tag=douglasbowman&year=2005 HTTP/1.1 | 200 | 89776c18-3dc3-40ce-8c58-e856f0dfcca5 | 10.1.3.226 | 13.66.139.0, 108.162.246.8 | http | 1.1 vegur | 5654 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 0.23 | 0.228 | 0.0 | 0.228 |
| 399 | 399 | 2021-08-05T19:17:29.717055+00:00 app[web.1]: measure#nginx.service=0.118 request="GET /search/?tag=flickrplaces&year=2008&page=1&month=1 HTTP/1.1" status_code=200 request_id=2aa2e65e-0573-40f6-99e8-d8396ee7cb42 remote_addr="10.1.3.226" forwarded_for="114.119.144.85, 172.70.147.75" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7172 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.120" upstream_connect_time="0.000" upstream_header_time="0.120"; | 0.118 | GET /search/?tag=flickrplaces&year=2008&page=1&month=1 HTTP/1.1 | 200 | 2aa2e65e-0573-40f6-99e8-d8396ee7cb42 | 10.1.3.226 | 114.119.144.85, 172.70.147.75 | http | 1.1 vegur | 7172 | - | 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.12 | 0.0 | 0.12 |
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 );