log
15 rows where remote_addr = "10.1.93.20" sorted by upstream_connect_time
This data as json, CSV (advanced)
Suggested facets: status_code, body_bytes_sent, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28 | 28 | 2021-08-05T19:09:30.177895+00:00 app[web.1]: measure#nginx.service=2.111 request="GET /search/?tag=robotstxt&year=2020&page=1 HTTP/1.1" status_code=200 request_id=dddf2100-5108-483f-82f9-d9a3b4ece26f remote_addr="10.1.93.20" forwarded_for="114.119.134.9, 172.70.142.161" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7559 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="2.111" upstream_response_time="2.112" upstream_connect_time="0.000" upstream_header_time="2.112"; | 2.111 | GET /search/?tag=robotstxt&year=2020&page=1 HTTP/1.1 | 200 | dddf2100-5108-483f-82f9-d9a3b4ece26f | 10.1.93.20 | 114.119.134.9, 172.70.142.161 | http | 1.1 vegur | 7559 | - | 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) | 2.111 | 2.112 | 0.0 | 2.112 |
43 | 43 | 2021-08-05T19:09:55.466234+00:00 app[web.1]: measure#nginx.service=4.684 request="GET /search/?tag=async&tag=node&tag=recovered&tag=json HTTP/1.1" status_code=200 request_id=8f9822ee-d851-4d2b-964b-b0982ffb58c1 remote_addr="10.1.93.20" forwarded_for="158.69.243.99, 172.70.126.210" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6588 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="4.684" upstream_response_time="4.684" upstream_connect_time="0.000" upstream_header_time="4.684"; | 4.684 | GET /search/?tag=async&tag=node&tag=recovered&tag=json HTTP/1.1 | 200 | 8f9822ee-d851-4d2b-964b-b0982ffb58c1 | 10.1.93.20 | 158.69.243.99, 172.70.126.210 | http | 1.1 vegur | 6588 | - | Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) | 4.684 | 4.684 | 0.0 | 4.684 |
58 | 58 | 2021-08-05T19:10:16.201577+00:00 app[web.1]: measure#nginx.service=0.412 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=df196517-b529-4bce-8fae-fbe8611b55a3 remote_addr="10.1.93.20" forwarded_for="80.241.215.228, 162.158.88.112" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Tiny Tiny RSS/18.12 (http://tt-rss.org/)" request_time="0.412" upstream_response_time="0.412" upstream_connect_time="0.000" upstream_header_time="0.408"; | 0.412 | GET /atom/entries/ HTTP/1.1 | 200 | df196517-b529-4bce-8fae-fbe8611b55a3 | 10.1.93.20 | 80.241.215.228, 162.158.88.112 | http | 1.1 vegur | 207454 | - | Tiny Tiny RSS/18.12 (http://tt-rss.org/) | 0.412 | 0.412 | 0.0 | 0.408 |
82 | 82 | 2021-08-05T19:10:44.873147+00:00 app[web.1]: measure#nginx.service=1.241 request="GET /search/?tag=webworkers&tag=geolocation&tag=video&tag=firefox&tag=mozilla&tag=html5&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=8d755819-5490-4c7d-ba74-6b0cb5e90388 remote_addr="10.1.93.20" forwarded_for="54.161.41.102, 172.70.34.3" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11844 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.241" upstream_response_time="1.240" upstream_connect_time="0.000" upstream_header_time="1.240"; | 1.241 | GET /search/?tag=webworkers&tag=geolocation&tag=video&tag=firefox&tag=mozilla&tag=html5&type=blogmark&year=2009 HTTP/1.1 | 200 | 8d755819-5490-4c7d-ba74-6b0cb5e90388 | 10.1.93.20 | 54.161.41.102, 172.70.34.3 | http | 1.1 vegur | 11844 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 1.241 | 1.24 | 0.0 | 1.24 |
156 | 156 | 2021-08-05T19:12:40.619236+00:00 app[web.1]: measure#nginx.service=0.230 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=3e2db9f8-93f2-4722-b342-0e313c236bc1 remote_addr="10.1.93.20" forwarded_for="147.182.164.48, 172.70.114.105" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="NewsBlur Feed Fetcher - 555 subscribers - http://www.newsblur.com/site/790/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.230" upstream_response_time="0.228" upstream_connect_time="0.000" upstream_header_time="0.220"; | 0.23 | GET /atom/everything/ HTTP/1.1 | 200 | 3e2db9f8-93f2-4722-b342-0e313c236bc1 | 10.1.93.20 | 147.182.164.48, 172.70.114.105 | http | 1.1 vegur | 155913 | - | NewsBlur Feed Fetcher - 555 subscribers - http://www.newsblur.com/site/790/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.23 | 0.228 | 0.0 | 0.22 |
205 | 205 | 2021-08-05T19:13:59.050905+00:00 app[web.1]: measure#nginx.service=8.996 request="GET /search/?tag=json&tag=video&tag=textshadow&tag=webworkers&tag=performance&tag=audio&tag=crossdomain&tag=fonts&tag=firefox35&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=e92e83f6-230c-41b3-92af-05b8cca05359 remote_addr="10.1.93.20" forwarded_for="54.161.41.102, 172.70.34.169" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14291 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="8.996" upstream_response_time="8.996" upstream_connect_time="0.000" upstream_header_time="8.996"; | 8.996 | GET /search/?tag=json&tag=video&tag=textshadow&tag=webworkers&tag=performance&tag=audio&tag=crossdomain&tag=fonts&tag=firefox35&type=blogmark&month=6 HTTP/1.1 | 200 | e92e83f6-230c-41b3-92af-05b8cca05359 | 10.1.93.20 | 54.161.41.102, 172.70.34.169 | http | 1.1 vegur | 14291 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 8.996 | 8.996 | 0.0 | 8.996 |
216 | 216 | 2021-08-05T19:14:09.354419+00:00 app[web.1]: measure#nginx.service=9.296 request="GET /search/?tag=csstransforms&tag=json&tag=fonts&tag=webworkers&tag=browsers&tag=dragndrop&tag=crossdomain&tag=html5&tag=localstorage&type=blogmark HTTP/1.1" status_code=200 request_id=426d255f-eece-46cb-ad4a-744efcc15c92 remote_addr="10.1.93.20" forwarded_for="54.161.41.102, 172.70.34.197" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13671 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="9.296" upstream_response_time="9.296" upstream_connect_time="0.000" upstream_header_time="9.296"; | 9.296 | GET /search/?tag=csstransforms&tag=json&tag=fonts&tag=webworkers&tag=browsers&tag=dragndrop&tag=crossdomain&tag=html5&tag=localstorage&type=blogmark HTTP/1.1 | 200 | 426d255f-eece-46cb-ad4a-744efcc15c92 | 10.1.93.20 | 54.161.41.102, 172.70.34.197 | http | 1.1 vegur | 13671 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 9.296 | 9.296 | 0.0 | 9.296 |
247 | 247 | 2021-08-05T19:14:54.621222+00:00 app[web.1]: measure#nginx.service=0.077 request="GET /search/?tag=longpolling&year=2008&type=blogmark&month=1 HTTP/1.1" status_code=200 request_id=ba6636d9-05b2-4590-a86b-1921c017e967 remote_addr="10.1.93.20" forwarded_for="114.119.150.168, 172.70.147.143" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6469 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.077" upstream_response_time="0.076" upstream_connect_time="0.000" upstream_header_time="0.076"; | 0.077 | GET /search/?tag=longpolling&year=2008&type=blogmark&month=1 HTTP/1.1 | 200 | ba6636d9-05b2-4590-a86b-1921c017e967 | 10.1.93.20 | 114.119.150.168, 172.70.147.143 | http | 1.1 vegur | 6469 | - | 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.077 | 0.076 | 0.0 | 0.076 |
318 | 318 | 2021-08-05T19:15:54.282968+00:00 app[web.1]: measure#nginx.service=1.020 request="GET /2004 HTTP/1.1" status_code=301 request_id=e048db4c-9bc4-4d2c-9044-46c0b7f9dac7 remote_addr="10.1.93.20" forwarded_for="34.147.114.27, 141.101.105.253" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="1.020" upstream_response_time="1.020" upstream_connect_time="0.000" upstream_header_time="1.020"; | 1.02 | GET /2004 HTTP/1.1 | 301 | e048db4c-9bc4-4d2c-9044-46c0b7f9dac7 | 10.1.93.20 | 34.147.114.27, 141.101.105.253 | http | 1.1 vegur | 0 | - | newspaper/0.2.8 | 1.02 | 1.02 | 0.0 | 1.02 |
320 | 320 | 2021-08-05T19:15:54.366775+00:00 app[web.1]: measure#nginx.service=0.992 request="GET /2020 HTTP/1.1" status_code=301 request_id=a184c028-ae36-4493-ad2d-54fa099ed005 remote_addr="10.1.93.20" forwarded_for="34.147.114.27, 141.101.76.225" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.992" upstream_response_time="0.992" upstream_connect_time="0.000" upstream_header_time="0.992"; | 0.992 | GET /2020 HTTP/1.1 | 301 | a184c028-ae36-4493-ad2d-54fa099ed005 | 10.1.93.20 | 34.147.114.27, 141.101.76.225 | http | 1.1 vegur | 0 | - | newspaper/0.2.8 | 0.992 | 0.992 | 0.0 | 0.992 |
331 | 331 | 2021-08-05T19:16:04.308800+00:00 app[web.1]: measure#nginx.service=4.609 request="GET /search/?tag=masterslave&page=1&year=2009&month=3&type=blogmark HTTP/1.1" status_code=200 request_id=a8bea0d2-d15a-4482-9448-7e07a89803cc remote_addr="10.1.93.20" forwarded_for="114.119.148.60, 162.158.166.58" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6819 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.609" upstream_response_time="4.608" upstream_connect_time="0.000" upstream_header_time="4.608"; | 4.609 | GET /search/?tag=masterslave&page=1&year=2009&month=3&type=blogmark HTTP/1.1 | 200 | a8bea0d2-d15a-4482-9448-7e07a89803cc | 10.1.93.20 | 114.119.148.60, 162.158.166.58 | http | 1.1 vegur | 6819 | - | 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.609 | 4.608 | 0.0 | 4.608 |
342 | 342 | 2021-08-05T19:16:18.408378+00:00 app[web.1]: measure#nginx.service=7.867 request="GET /search/?q=%F0%9F%A6%A5%E2%A5%AE%E2%9D%8B%20www.Getroman.store%20%E2%9D%8B%E2%A5%AE%F0%9F%A6%A5%20Costo%20viagra%20100%20mg%20in%20farmacia%20Viagra%20generico%20acquisto%20senza%20ricetta%20Best%20sites%20to%20buy%20cialis%20online%20Comprare%20cialis%20in%20gel%20online%20Cialis%20generico%2020%20mg%20online%20farmacia%20italia HTTP/1.1" status_code=200 request_id=eddc5bd0-ef90-4309-afd0-5427720409f6 remote_addr="10.1.93.20" forwarded_for="54.36.148.115, 141.101.77.136" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=4136 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="7.867" upstream_response_time="7.868" upstream_connect_time="0.000" upstream_header_time="7.868"; | 7.867 | GET /search/?q=%F0%9F%A6%A5%E2%A5%AE%E2%9D%8B%20www.Getroman.store%20%E2%9D%8B%E2%A5%AE%F0%9F%A6%A5%20Costo%20viagra%20100%20mg%20in%20farmacia%20Viagra%20generico%20acquisto%20senza%20ricetta%20Best%20sites%20to%20buy%20cialis%20online%20Comprare%20cialis%20in%20gel%20online%20Cialis%20generico%2020%20mg%20online%20farmacia%20italia HTTP/1.1 | 200 | eddc5bd0-ef90-4309-afd0-5427720409f6 | 10.1.93.20 | 54.36.148.115, 141.101.77.136 | http | 1.1 vegur | 4136 | - | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) | 7.867 | 7.868 | 0.0 | 7.868 |
468 | 468 | 2021-08-05T19:19:17.368447+00:00 app[web.1]: measure#nginx.service=13.331 request="GET /search/?tag=jsk&type=blogmark&year=2019 HTTP/1.1" status_code=200 request_id=d85cc8e0-bca0-48f6-b362-c59fcd93f89b remote_addr="10.1.93.20" forwarded_for="114.119.136.88, 172.70.142.60" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6911 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="13.331" upstream_response_time="13.332" upstream_connect_time="0.000" upstream_header_time="13.332"; | 13.331 | GET /search/?tag=jsk&type=blogmark&year=2019 HTTP/1.1 | 200 | d85cc8e0-bca0-48f6-b362-c59fcd93f89b | 10.1.93.20 | 114.119.136.88, 172.70.142.60 | http | 1.1 vegur | 6911 | - | 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) | 13.331 | 13.332 | 0.0 | 13.332 |
469 | 469 | 2021-08-05T19:19:20.269797+00:00 app[web.1]: measure#nginx.service=16.190 request="GET /search/?tag=offlineresources&tag=csstransforms&tag=tracemonkey&tag=browsers&tag=javascript&type=blogmark&year=2009&month=6 HTTP/1.1" status_code=200 request_id=8c64f42b-5ae0-412e-a2d6-99e50eec4ba9 remote_addr="10.1.93.20" forwarded_for="54.161.41.102, 172.70.34.243" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12528 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="16.190" upstream_response_time="16.188" upstream_connect_time="0.000" upstream_header_time="16.188"; | 16.19 | GET /search/?tag=offlineresources&tag=csstransforms&tag=tracemonkey&tag=browsers&tag=javascript&type=blogmark&year=2009&month=6 HTTP/1.1 | 200 | 8c64f42b-5ae0-412e-a2d6-99e50eec4ba9 | 10.1.93.20 | 54.161.41.102, 172.70.34.243 | http | 1.1 vegur | 12528 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 16.19 | 16.188 | 0.0 | 16.188 |
486 | 486 | 2021-08-05T19:19:46.724627+00:00 app[web.1]: measure#nginx.service=11.864 request="GET /tags/datasette/ HTTP/1.1" status_code=200 request_id=b5f7b276-4562-4a1f-89de-6034c1619695 remote_addr="10.1.93.20" forwarded_for="66.249.73.62, 108.162.221.138" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=32494 referer="-" user_agent="Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" request_time="11.864" upstream_response_time="11.864" upstream_connect_time="0.000" upstream_header_time="11.864"; | 11.864 | GET /tags/datasette/ HTTP/1.1 | 200 | b5f7b276-4562-4a1f-89de-6034c1619695 | 10.1.93.20 | 66.249.73.62, 108.162.221.138 | http | 1.1 vegur | 32494 | - | Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) | 11.864 | 11.864 | 0.0 | 11.864 |
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 );