15 rows where remote_addr = "10.1.3.232" sorted by upstream_response_time

View and edit SQL

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

remote_addr

  • 10.1.3.232 · 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
37 2021-08-05T19:09:42.580343+00:00 app[web.1]: measure#nginx.service=0.069 request="GET /search/?q%3Dpostgresql&tag=authentication&year=2007&type=blogmark HTTP/1.1" status_code=200 request_id=1aeb9cc5-e6a9-46bd-9695-810560faa0f4 remote_addr="10.1.3.232" forwarded_for="114.119.152.70, 172.68.144.117" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10515 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.069" upstream_response_time="0.068" upstream_connect_time="0.000" upstream_header_time="0.068"; 0.069 GET /search/?q%3Dpostgresql&tag=authentication&year=2007&type=blogmark HTTP/1.1 200 1aeb9cc5-e6a9-46bd-9695-810560faa0f4 10.1.3.232 114.119.152.70, 172.68.144.117 http 1.1 vegur 10515 - 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.069 0.068 0.0 0.068
97 2021-08-05T19:11:07.988553+00:00 app[web.1]: measure#nginx.service=0.111 request="GET /search/?tag=donations&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=b7d1e9a5-9359-4802-9e1d-2d2030b53099 remote_addr="10.1.3.232" forwarded_for="114.119.131.33, 172.70.143.46" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5427 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.111" upstream_response_time="0.112" upstream_connect_time="0.000" upstream_header_time="0.112"; 0.111 GET /search/?tag=donations&type=blogmark&year=2009 HTTP/1.1 200 b7d1e9a5-9359-4802-9e1d-2d2030b53099 10.1.3.232 114.119.131.33, 172.70.143.46 http 1.1 vegur 5427 - 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.111 0.112 0.0 0.112
410 2021-08-05T19:17:45.287588+00:00 app[web.1]: measure#nginx.service=0.116 request="GET /search/?q%3Dpostgresql&month=6&tag=andrewgodwin&type=blogmark HTTP/1.1" status_code=200 request_id=a9666e00-4b1b-4551-a3a5-b767f3c8a921 remote_addr="10.1.3.232" forwarded_for="114.119.130.104, 172.68.144.32" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6319 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.116" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; 0.116 GET /search/?q%3Dpostgresql&month=6&tag=andrewgodwin&type=blogmark HTTP/1.1 200 a9666e00-4b1b-4551-a3a5-b767f3c8a921 10.1.3.232 114.119.130.104, 172.68.144.32 http 1.1 vegur 6319 - 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.116 0.12 0.0 0.12
250 2021-08-05T19:14:59.062471+00:00 app[web.1]: measure#nginx.service=0.152 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=b155e8e6-6a43-457b-9ad5-1bb16f7e7599 remote_addr="10.1.3.232" forwarded_for="92.247.181.10, 172.68.50.92" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="https://simonwillison.net/" user_agent="Mozilla/5.0 (compatible; inoreader.com; 7 subscribers)" request_time="0.152" upstream_response_time="0.152" upstream_connect_time="0.000" upstream_header_time="0.152"; 0.152 GET /atom/links/ HTTP/1.1 200 b155e8e6-6a43-457b-9ad5-1bb16f7e7599 10.1.3.232 92.247.181.10, 172.68.50.92 http 1.1 vegur 16609 https://simonwillison.net/ Mozilla/5.0 (compatible; inoreader.com; 7 subscribers) 0.152 0.152 0.0 0.152
362 2021-08-05T19:16:34.352170+00:00 app[web.1]: measure#nginx.service=0.155 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=9d7759ce-3f0c-42ea-864b-d4b2d2746990 remote_addr="10.1.3.232" forwarded_for="2601:1c2:680:18b0:4df7:a816:8e3e:715c, 162.158.107.232" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="NetNewsWire (RSS Reader; https://netnewswire.com/)" request_time="0.155" upstream_response_time="0.156" upstream_connect_time="0.000" upstream_header_time="0.148"; 0.155 GET /atom/everything/ HTTP/1.1 200 9d7759ce-3f0c-42ea-864b-d4b2d2746990 10.1.3.232 2601:1c2:680:18b0:4df7:a816:8e3e:715c, 162.158.107.232 http 1.1 vegur 155913 - NetNewsWire (RSS Reader; https://netnewswire.com/) 0.155 0.156 0.0 0.148
400 2021-08-05T19:17:30.043030+00:00 app[web.1]: measure#nginx.service=0.245 request="GET / HTTP/1.1" status_code=200 request_id=b3556e84-9a26-4428-83f7-c4b8a4cc80f3 remote_addr="10.1.3.232" forwarded_for="147.182.168.177, 162.158.62.95" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=108572 referer="-" user_agent="NewsBlur Page 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.245" upstream_response_time="0.244" upstream_connect_time="0.000" upstream_header_time="0.244"; 0.245 GET / HTTP/1.1 200 b3556e84-9a26-4428-83f7-c4b8a4cc80f3 10.1.3.232 147.182.168.177, 162.158.62.95 http 1.1 vegur 108572 - NewsBlur Page 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.245 0.244 0.0 0.244
306 2021-08-05T19:15:52.600576+00:00 app[web.1]: measure#nginx.service=0.762 request="GET /2013 HTTP/1.1" status_code=301 request_id=95ec61b5-78a7-42a9-b72c-5e9e5b73c36a remote_addr="10.1.3.232" forwarded_for="34.147.114.27, 141.101.105.143" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.762" upstream_response_time="0.764" upstream_connect_time="0.000" upstream_header_time="0.764"; 0.762 GET /2013 HTTP/1.1 301 95ec61b5-78a7-42a9-b72c-5e9e5b73c36a 10.1.3.232 34.147.114.27, 141.101.105.143 http 1.1 vegur 0 - newspaper/0.2.8 0.762 0.764 0.0 0.764
384 2021-08-05T19:17:08.760218+00:00 app[web.1]: measure#nginx.service=1.170 request="GET /search/?month=8&tag=rails&type=blogmark HTTP/1.1" status_code=200 request_id=b0fa7256-0aea-4dd0-b1e7-7e00ba1b18dc remote_addr="10.1.3.232" forwarded_for="114.119.145.134, 162.158.166.156" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7848 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="1.170" upstream_response_time="1.172" upstream_connect_time="0.000" upstream_header_time="1.172"; 1.17 GET /search/?month=8&tag=rails&type=blogmark HTTP/1.1 200 b0fa7256-0aea-4dd0-b1e7-7e00ba1b18dc 10.1.3.232 114.119.145.134, 162.158.166.156 http 1.1 vegur 7848 - 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) 1.17 1.172 0.0 1.172
433 2021-08-05T19:18:17.237402+00:00 app[web.1]: measure#nginx.service=1.527 request="GET /search/?page=9&type=blogmark&year=2010 HTTP/1.1" status_code=200 request_id=8166627f-10e6-41f3-9161-0bee83124e1e remote_addr="10.1.3.232" forwarded_for="114.119.148.202, 172.70.143.5" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=27098 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="1.527" upstream_response_time="1.528" upstream_connect_time="0.000" upstream_header_time="1.528"; 1.527 GET /search/?page=9&type=blogmark&year=2010 HTTP/1.1 200 8166627f-10e6-41f3-9161-0bee83124e1e 10.1.3.232 114.119.148.202, 172.70.143.5 http 1.1 vegur 27098 - 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) 1.527 1.528 0.0 1.528
75 2021-08-05T19:10:41.611587+00:00 app[web.1]: measure#nginx.service=1.808 request="GET /2007/Aug/15/jquery HTTP/1.1" status_code=301 request_id=e2e17ba9-6b64-42bc-b8f4-e52c02dbc0a3 remote_addr="10.1.3.232" forwarded_for="49.12.12.219, 162.158.92.64" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36" request_time="1.808" upstream_response_time="1.808" upstream_connect_time="0.000" upstream_header_time="1.808"; 1.808 GET /2007/Aug/15/jquery HTTP/1.1 301 e2e17ba9-6b64-42bc-b8f4-e52c02dbc0a3 10.1.3.232 49.12.12.219, 162.158.92.64 http 1.1 vegur 0 - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36 1.808 1.808 0.0 1.808
381 2021-08-05T19:17:06.000945+00:00 app[web.1]: measure#nginx.service=3.001 request="GET /search/?q=javascript&year=2010&type=blogmark&tag=jquery&month=10 HTTP/1.1" status_code=200 request_id=2dc4a8cc-7ce2-46c5-bb1f-6f3b4099fa0f remote_addr="10.1.3.232" forwarded_for="114.119.154.242, 172.70.142.47" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7548 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="3.001" upstream_response_time="3.000" upstream_connect_time="0.000" upstream_header_time="3.000"; 3.001 GET /search/?q=javascript&year=2010&type=blogmark&tag=jquery&month=10 HTTP/1.1 200 2dc4a8cc-7ce2-46c5-bb1f-6f3b4099fa0f 10.1.3.232 114.119.154.242, 172.70.142.47 http 1.1 vegur 7548 - 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) 3.001 3.0 0.0 3.0
51 2021-08-05T19:10:07.655046+00:00 app[web.1]: measure#nginx.service=4.238 request="GET /search/?tag=firefox&tag=crossdomain&tag=javascript&tag=mozilla&tag=audio&year=2009 HTTP/1.1" status_code=200 request_id=26893e5d-07da-4497-a8d3-223202dda43c remote_addr="10.1.3.232" forwarded_for="54.161.41.102, 172.70.34.137" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10283 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.238" upstream_response_time="4.236" upstream_connect_time="0.000" upstream_header_time="4.236"; 4.238 GET /search/?tag=firefox&tag=crossdomain&tag=javascript&tag=mozilla&tag=audio&year=2009 HTTP/1.1 200 26893e5d-07da-4497-a8d3-223202dda43c 10.1.3.232 54.161.41.102, 172.70.34.137 http 1.1 vegur 10283 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.238 4.236 0.0 4.236
358 2021-08-05T19:16:31.307130+00:00 app[web.1]: measure#nginx.service=4.324 request="GET /search/?tag=canvas&tag=tracemonkey&tag=textshadow&tag=javascript&tag=performance&tag=webworkers&tag=json&tag=firefox&type=blogmark&year=2009&month=6 HTTP/1.1" status_code=200 request_id=fc4ef7ed-1f83-42cc-b8bb-eeac193ca204 remote_addr="10.1.3.232" forwarded_for="54.161.41.102, 172.70.35.68" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14770 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.324" upstream_response_time="4.324" upstream_connect_time="0.000" upstream_header_time="4.324"; 4.324 GET /search/?tag=canvas&tag=tracemonkey&tag=textshadow&tag=javascript&tag=performance&tag=webworkers&tag=json&tag=firefox&type=blogmark&year=2009&month=6 HTTP/1.1 200 fc4ef7ed-1f83-42cc-b8bb-eeac193ca204 10.1.3.232 54.161.41.102, 172.70.35.68 http 1.1 vegur 14770 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.324 4.324 0.0 4.324
233 2021-08-05T19:14:30.629357+00:00 app[web.1]: measure#nginx.service=7.162 request="GET /search/?tag=fonts&tag=performance&tag=html5&tag=tracemonkey&tag=json&tag=audio&tag=webworkers&tag=javascript&tag=firefox35&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=43ce4d44-1123-4030-9b80-ad58abdd33a8 remote_addr="10.1.3.232" forwarded_for="54.161.41.102, 172.70.35.68" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14570 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="7.162" upstream_response_time="7.160" upstream_connect_time="0.000" upstream_header_time="7.160"; 7.162 GET /search/?tag=fonts&tag=performance&tag=html5&tag=tracemonkey&tag=json&tag=audio&tag=webworkers&tag=javascript&tag=firefox35&type=blogmark&year=2009 HTTP/1.1 200 43ce4d44-1123-4030-9b80-ad58abdd33a8 10.1.3.232 54.161.41.102, 172.70.35.68 http 1.1 vegur 14570 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 7.162 7.16 0.0 7.16
472 2021-08-05T19:19:20.903852+00:00 app[web.1]: measure#nginx.service=12.030 request="GET /search/?month=2&tag=threads&year=2009 HTTP/1.1" status_code=200 request_id=07807936-48ff-4a64-b9da-cad648266d3f remote_addr="10.1.3.232" forwarded_for="114.119.131.112, 172.70.143.70" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6427 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="12.030" upstream_response_time="12.032" upstream_connect_time="0.000" upstream_header_time="12.032"; 12.03 GET /search/?month=2&tag=threads&year=2009 HTTP/1.1 200 07807936-48ff-4a64-b9da-cad648266d3f 10.1.3.232 114.119.131.112, 172.70.143.70 http 1.1 vegur 6427 - 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) 12.03 12.032 0.0 12.032

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