15 rows where remote_addr = "10.1.93.20" sorted by upstream_response_time

View and edit SQL

Suggested facets: status_code, body_bytes_sent, user_agent

remote_addr

  • 10.1.93.20 · 15
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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 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

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