log
15 rows where remote_addr = "10.1.3.232" sorted by body_bytes_sent
This data as json, CSV (advanced)
Suggested facets: status_code, forwarded_for, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
75 | 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 |
306 | 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 |
97 | 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 | 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 |
472 | 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 |
381 | 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 |
384 | 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 |
51 | 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 |
37 | 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 |
233 | 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 |
358 | 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 |
250 | 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 |
433 | 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 |
400 | 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 |
362 | 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 |
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 );