log
15 rows where remote_addr = "10.1.93.20" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 );