35 rows where status_code = 301 sorted by request_time descending

View and edit SQL

Suggested facets: remote_addr

body_bytes_sent

  • 0 25
  • 5 10
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
456 2021-08-05T19:19:01.816315+00:00 app[web.1]: measure#nginx.service=10.339 request="GET / HTTP/1.1" status_code=301 request_id=3a215e29-aa53-4661-bfa6-42f58a068a3b remote_addr="10.1.89.90" forwarded_for="175.27.168.253, 172.70.98.137" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36" request_time="10.339" upstream_response_time="10.340" upstream_connect_time="0.000" upstream_header_time="10.340"; 10.339 GET / HTTP/1.1 301 3a215e29-aa53-4661-bfa6-42f58a068a3b 10.1.89.90 175.27.168.253, 172.70.98.137 http 1.1 vegur 5 - Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36 10.339 10.34 0.0 10.34
454 2021-08-05T19:18:54.107520+00:00 app[web.1]: measure#nginx.service=6.453 request="GET /atom/everything HTTP/1.1" status_code=301 request_id=5cb47552-b0b1-4151-adad-846f44fe2fb4 remote_addr="10.1.29.75" forwarded_for="168.119.243.5, 162.158.94.84" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" request_time="6.453" upstream_response_time="6.456" upstream_connect_time="0.000" upstream_header_time="6.456"; 6.453 GET /atom/everything HTTP/1.1 301 5cb47552-b0b1-4151-adad-846f44fe2fb4 10.1.29.75 168.119.243.5, 162.158.94.84 http 1.1 vegur 0 - Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) 6.453 6.456 0.0 6.456
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
314 2021-08-05T19:15:53.758652+00:00 app[web.1]: measure#nginx.service=1.463 request="GET /2010 HTTP/1.1" status_code=301 request_id=350a63e7-e734-493b-9120-b1fb78ae9497 remote_addr="10.1.87.198" forwarded_for="34.147.114.27, 162.158.111.199" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="1.463" upstream_response_time="1.460" upstream_connect_time="0.000" upstream_header_time="1.460"; 1.463 GET /2010 HTTP/1.1 301 350a63e7-e734-493b-9120-b1fb78ae9497 10.1.87.198 34.147.114.27, 162.158.111.199 http 1.1 vegur 0 - newspaper/0.2.8 1.463 1.46 0.0 1.46
316 2021-08-05T19:15:54.187893+00:00 app[web.1]: measure#nginx.service=1.158 request="GET /2011 HTTP/1.1" status_code=301 request_id=e3efaac0-27eb-4b9c-b5fe-4c2cb73b2cc3 remote_addr="10.1.94.69" forwarded_for="34.147.114.27, 141.101.76.170" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="1.158" upstream_response_time="1.160" upstream_connect_time="0.000" upstream_header_time="1.160"; 1.158 GET /2011 HTTP/1.1 301 e3efaac0-27eb-4b9c-b5fe-4c2cb73b2cc3 10.1.94.69 34.147.114.27, 141.101.76.170 http 1.1 vegur 0 - newspaper/0.2.8 1.158 1.16 0.0 1.16
317 2021-08-05T19:15:54.244390+00:00 app[web.1]: measure#nginx.service=1.114 request="GET /2019 HTTP/1.1" status_code=301 request_id=7224777f-d932-46f6-b35a-b96c58af8bcd remote_addr="10.1.91.167" forwarded_for="34.147.114.27, 141.101.76.128" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="1.114" upstream_response_time="1.116" upstream_connect_time="0.000" upstream_header_time="1.116"; 1.114 GET /2019 HTTP/1.1 301 7224777f-d932-46f6-b35a-b96c58af8bcd 10.1.91.167 34.147.114.27, 141.101.76.128 http 1.1 vegur 0 - newspaper/0.2.8 1.114 1.116 0.0 1.116
385 2021-08-05T19:17:08.816651+00:00 app[web.1]: measure#nginx.service=1.102 request="GET /static/2009/devdays-amsterdam.html HTTP/1.1" status_code=301 request_id=24d69036-dde3-412a-a0a7-684b7b70803e remote_addr="10.1.55.92" forwarded_for="5.255.231.61, 141.101.77.87" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)" request_time="1.102" upstream_response_time="1.104" upstream_connect_time="0.000" upstream_header_time="1.104"; 1.102 GET /static/2009/devdays-amsterdam.html HTTP/1.1 301 24d69036-dde3-412a-a0a7-684b7b70803e 10.1.55.92 5.255.231.61, 141.101.77.87 http 1.1 vegur 0 - Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) 1.102 1.104 0.0 1.104
218 2021-08-05T19:14:09.664968+00:00 app[web.1]: measure#nginx.service=1.053 request="GET / HTTP/1.1" status_code=301 request_id=3c75902a-e765-4e4c-922a-0589d7901bea remote_addr="10.1.48.192" forwarded_for="119.45.23.33, 172.69.34.242" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36" request_time="1.053" upstream_response_time="1.052" upstream_connect_time="0.000" upstream_header_time="1.052"; 1.053 GET / HTTP/1.1 301 3c75902a-e765-4e4c-922a-0589d7901bea 10.1.48.192 119.45.23.33, 172.69.34.242 http 1.1 vegur 5 - Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36 1.053 1.052 0.0 1.052
319 2021-08-05T19:15:54.321365+00:00 app[web.1]: measure#nginx.service=1.037 request="GET /2009 HTTP/1.1" status_code=301 request_id=a9c65811-0198-45eb-bf8e-e8afe19c478a remote_addr="10.1.87.198" forwarded_for="34.147.114.27, 172.69.54.231" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="1.037" upstream_response_time="1.036" upstream_connect_time="0.000" upstream_header_time="1.036"; 1.037 GET /2009 HTTP/1.1 301 a9c65811-0198-45eb-bf8e-e8afe19c478a 10.1.87.198 34.147.114.27, 172.69.54.231 http 1.1 vegur 0 - newspaper/0.2.8 1.037 1.036 0.0 1.036
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 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
311 2021-08-05T19:15:52.843593+00:00 app[web.1]: measure#nginx.service=0.794 request="GET /2017 HTTP/1.1" status_code=301 request_id=165de9ec-8d00-4207-b991-24ec4cb4fb3f remote_addr="10.1.92.174" forwarded_for="34.147.114.27, 141.101.77.231" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.794" upstream_response_time="0.796" upstream_connect_time="0.000" upstream_header_time="0.796"; 0.794 GET /2017 HTTP/1.1 301 165de9ec-8d00-4207-b991-24ec4cb4fb3f 10.1.92.174 34.147.114.27, 141.101.77.231 http 1.1 vegur 0 - newspaper/0.2.8 0.794 0.796 0.0 0.796
310 2021-08-05T19:15:52.786427+00:00 app[web.1]: measure#nginx.service=0.777 request="GET /2021 HTTP/1.1" status_code=301 request_id=80a9e842-b196-41f6-8420-033f94dca2bb remote_addr="10.1.14.97" forwarded_for="34.147.114.27, 172.69.54.166" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.777" upstream_response_time="0.776" upstream_connect_time="0.000" upstream_header_time="0.776"; 0.777 GET /2021 HTTP/1.1 301 80a9e842-b196-41f6-8420-033f94dca2bb 10.1.14.97 34.147.114.27, 172.69.54.166 http 1.1 vegur 0 - newspaper/0.2.8 0.777 0.776 0.0 0.776
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
309 2021-08-05T19:15:52.749017+00:00 app[web.1]: measure#nginx.service=0.750 request="GET /2002 HTTP/1.1" status_code=301 request_id=01589f65-507c-488c-a89c-c7cb17115694 remote_addr="10.1.12.255" forwarded_for="34.147.114.27, 162.158.111.223" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.750" upstream_response_time="0.752" upstream_connect_time="0.000" upstream_header_time="0.752"; 0.75 GET /2002 HTTP/1.1 301 01589f65-507c-488c-a89c-c7cb17115694 10.1.12.255 34.147.114.27, 162.158.111.223 http 1.1 vegur 0 - newspaper/0.2.8 0.75 0.752 0.0 0.752
308 2021-08-05T19:15:52.712573+00:00 app[web.1]: measure#nginx.service=0.723 request="GET /2015 HTTP/1.1" status_code=301 request_id=e760a8cc-3997-4177-b1cc-785dc866daae remote_addr="10.1.58.55" forwarded_for="34.147.114.27, 141.101.105.75" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.723" upstream_response_time="0.724" upstream_connect_time="0.000" upstream_header_time="0.724"; 0.723 GET /2015 HTTP/1.1 301 e760a8cc-3997-4177-b1cc-785dc866daae 10.1.58.55 34.147.114.27, 141.101.105.75 http 1.1 vegur 0 - newspaper/0.2.8 0.723 0.724 0.0 0.724
208 2021-08-05T19:13:59.474710+00:00 app[web.1]: measure#nginx.service=0.704 request="GET /swn-everything HTTP/1.1" status_code=301 request_id=df385e7f-5a26-4015-aae9-3cd62f2f99ab remote_addr="10.1.48.192" forwarded_for="75.164.138.232, 162.158.106.35" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="easy-feed-oven/1.0 (+https://github.com/lmorchard/easy-feed-oven)" request_time="0.704" upstream_response_time="0.704" upstream_connect_time="0.000" upstream_header_time="0.704"; 0.704 GET /swn-everything HTTP/1.1 301 df385e7f-5a26-4015-aae9-3cd62f2f99ab 10.1.48.192 75.164.138.232, 162.158.106.35 http 1.1 vegur 5 - easy-feed-oven/1.0 (+https://github.com/lmorchard/easy-feed-oven) 0.704 0.704 0.0 0.704
307 2021-08-05T19:15:52.651490+00:00 app[web.1]: measure#nginx.service=0.667 request="GET /2005 HTTP/1.1" status_code=301 request_id=6d5a8cf0-f6fe-415a-bae1-3849db4a619a remote_addr="10.1.48.192" forwarded_for="34.147.114.27, 162.158.111.79" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.667" upstream_response_time="0.668" upstream_connect_time="0.000" upstream_header_time="0.668"; 0.667 GET /2005 HTTP/1.1 301 6d5a8cf0-f6fe-415a-bae1-3849db4a619a 10.1.48.192 34.147.114.27, 162.158.111.79 http 1.1 vegur 0 - newspaper/0.2.8 0.667 0.668 0.0 0.668
303 2021-08-05T19:15:51.947931+00:00 app[web.1]: measure#nginx.service=0.415 request="GET /2008 HTTP/1.1" status_code=301 request_id=f4cc267d-75cb-4c86-a7f1-033d56ce3586 remote_addr="10.1.17.204" forwarded_for="34.147.114.27, 141.101.77.162" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.415" upstream_response_time="0.416" upstream_connect_time="0.000" upstream_header_time="0.416"; 0.415 GET /2008 HTTP/1.1 301 f4cc267d-75cb-4c86-a7f1-033d56ce3586 10.1.17.204 34.147.114.27, 141.101.77.162 http 1.1 vegur 0 - newspaper/0.2.8 0.415 0.416 0.0 0.416
304 2021-08-05T19:15:52.017176+00:00 app[web.1]: measure#nginx.service=0.287 request="GET /2018 HTTP/1.1" status_code=301 request_id=8998a739-b882-4b7a-9221-48ef42fc0cee remote_addr="10.1.94.69" forwarded_for="34.147.114.27, 172.69.54.15" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.287" upstream_response_time="0.288" upstream_connect_time="0.000" upstream_header_time="0.288"; 0.287 GET /2018 HTTP/1.1 301 8998a739-b882-4b7a-9221-48ef42fc0cee 10.1.94.69 34.147.114.27, 172.69.54.15 http 1.1 vegur 0 - newspaper/0.2.8 0.287 0.288 0.0 0.288
298 2021-08-05T19:15:51.329652+00:00 app[web.1]: measure#nginx.service=0.119 request="GET /2014 HTTP/1.1" status_code=301 request_id=1f6d5780-0647-46f4-8179-b3ab0cf55664 remote_addr="10.1.12.255" forwarded_for="34.147.114.27, 141.101.76.23" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.119" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; 0.119 GET /2014 HTTP/1.1 301 1f6d5780-0647-46f4-8179-b3ab0cf55664 10.1.12.255 34.147.114.27, 141.101.76.23 http 1.1 vegur 0 - newspaper/0.2.8 0.119 0.12 0.0 0.12
297 2021-08-05T19:15:51.290410+00:00 app[web.1]: measure#nginx.service=0.095 request="GET /2007 HTTP/1.1" status_code=301 request_id=a70f9621-a1ec-409a-8d4e-6018aed656e1 remote_addr="10.1.55.92" forwarded_for="34.147.114.27, 141.101.105.157" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.095" upstream_response_time="0.096" upstream_connect_time="0.000" upstream_header_time="0.096"; 0.095 GET /2007 HTTP/1.1 301 a70f9621-a1ec-409a-8d4e-6018aed656e1 10.1.55.92 34.147.114.27, 141.101.105.157 http 1.1 vegur 0 - newspaper/0.2.8 0.095 0.096 0.0 0.096
299 2021-08-05T19:15:51.399523+00:00 app[web.1]: measure#nginx.service=0.080 request="GET /2012 HTTP/1.1" status_code=301 request_id=e347e942-f12d-46b9-86b9-9b402662fbcc remote_addr="10.1.12.255" forwarded_for="34.147.114.27, 141.101.105.105" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.080" upstream_response_time="0.080" upstream_connect_time="0.000" upstream_header_time="0.080"; 0.08 GET /2012 HTTP/1.1 301 e347e942-f12d-46b9-86b9-9b402662fbcc 10.1.12.255 34.147.114.27, 141.101.105.105 http 1.1 vegur 0 - newspaper/0.2.8 0.08 0.08 0.0 0.08
301 2021-08-05T19:15:51.585509+00:00 app[web.1]: measure#nginx.service=0.070 request="GET /2003 HTTP/1.1" status_code=301 request_id=9edb45f9-87af-4d4d-8a55-6815735ef0b2 remote_addr="10.1.31.190" forwarded_for="34.147.114.27, 162.158.111.206" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.070" upstream_response_time="0.072" upstream_connect_time="0.000" upstream_header_time="0.072"; 0.07 GET /2003 HTTP/1.1 301 9edb45f9-87af-4d4d-8a55-6815735ef0b2 10.1.31.190 34.147.114.27, 162.158.111.206 http 1.1 vegur 0 - newspaper/0.2.8 0.07 0.072 0.0 0.072
286 2021-08-05T19:15:40.739325+00:00 app[web.1]: measure#nginx.service=0.066 request="GET /swn-entries HTTP/1.1" status_code=301 request_id=e74c87aa-4cba-4814-bc90-d9ba36a7dde0 remote_addr="10.1.14.97" forwarded_for="108.2.161.198, 172.70.110.183" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="NetNewsWire (RSS Reader; https://netnewswire.com/)" request_time="0.066" upstream_response_time="0.068" upstream_connect_time="0.000" upstream_header_time="0.064"; 0.066 GET /swn-entries HTTP/1.1 301 e74c87aa-4cba-4814-bc90-d9ba36a7dde0 10.1.14.97 108.2.161.198, 172.70.110.183 http 1.1 vegur 5 - NetNewsWire (RSS Reader; https://netnewswire.com/) 0.066 0.068 0.0 0.064
191 2021-08-05T19:13:35.530507+00:00 app[web.1]: measure#nginx.service=0.065 request="HEAD / HTTP/1.1" status_code=301 request_id=037caf77-711e-4d98-ae14-8186dbd53d02 remote_addr="10.1.31.190" forwarded_for="18.215.244.20, 172.70.34.84" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="scalaj-http/2.4.2" request_time="0.065" upstream_response_time="0.064" upstream_connect_time="0.000" upstream_header_time="0.064"; 0.065 HEAD / HTTP/1.1 301 037caf77-711e-4d98-ae14-8186dbd53d02 10.1.31.190 18.215.244.20, 172.70.34.84 http 1.1 vegur 0 - scalaj-http/2.4.2 0.065 0.064 0.0 0.064
260 2021-08-05T19:15:12.252887+00:00 app[web.1]: measure#nginx.service=0.061 request="GET /swn-everything HTTP/1.1" status_code=301 request_id=7d46cd40-2726-41d7-8a82-10a622f442b0 remote_addr="10.1.28.143" forwarded_for="2604:a880:cad:d0::139:1, 162.158.126.55" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="Fever/1.39 (Feed Parser; http://feedafever.com; Allow like Gecko)" request_time="0.061" upstream_response_time="0.060" upstream_connect_time="0.000" upstream_header_time="0.060"; 0.061 GET /swn-everything HTTP/1.1 301 7d46cd40-2726-41d7-8a82-10a622f442b0 10.1.28.143 2604:a880:cad:d0::139:1, 162.158.126.55 http 1.1 vegur 5 - Fever/1.39 (Feed Parser; http://feedafever.com; Allow like Gecko) 0.061 0.06 0.0 0.06
41 2021-08-05T19:09:50.226833+00:00 app[web.1]: measure#nginx.service=0.055 request="GET /rss HTTP/1.1" status_code=301 request_id=5ad0d9cf-0499-47ac-af9f-2111db00fbb3 remote_addr="10.1.87.198" forwarded_for="2a01:e34:ec95:f440:44b3:beed:96e3:1fa6, 141.101.68.37" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="okhttp/4.9.1" request_time="0.055" upstream_response_time="0.052" upstream_connect_time="0.000" upstream_header_time="0.052"; 0.055 GET /rss HTTP/1.1 301 5ad0d9cf-0499-47ac-af9f-2111db00fbb3 10.1.87.198 2a01:e34:ec95:f440:44b3:beed:96e3:1fa6, 141.101.68.37 http 1.1 vegur 5 - okhttp/4.9.1 0.055 0.052 0.0 0.052
296 2021-08-05T19:15:51.241317+00:00 app[web.1]: measure#nginx.service=0.055 request="GET /2016 HTTP/1.1" status_code=301 request_id=ee8aad28-c37c-4ee9-bb3f-f24e2b9b517f remote_addr="10.1.7.130" forwarded_for="34.147.114.27, 141.101.105.129" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.055" upstream_response_time="0.056" upstream_connect_time="0.000" upstream_header_time="0.056"; 0.055 GET /2016 HTTP/1.1 301 ee8aad28-c37c-4ee9-bb3f-f24e2b9b517f 10.1.7.130 34.147.114.27, 141.101.105.129 http 1.1 vegur 0 - newspaper/0.2.8 0.055 0.056 0.0 0.056
193 2021-08-05T19:13:38.369423+00:00 app[web.1]: measure#nginx.service=0.045 request="GET / HTTP/1.1" status_code=301 request_id=fa36859c-6d7d-40b8-9460-6598c0830bf5 remote_addr="10.1.63.160" forwarded_for="18.215.244.20, 172.70.34.226" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="Buck/2.2; (+https://app.hypefactors.com/media-monitoring/about.html)" request_time="0.045" upstream_response_time="0.044" upstream_connect_time="0.000" upstream_header_time="0.044"; 0.045 GET / HTTP/1.1 301 fa36859c-6d7d-40b8-9460-6598c0830bf5 10.1.63.160 18.215.244.20, 172.70.34.226 http 1.1 vegur 5 - Buck/2.2; (+https://app.hypefactors.com/media-monitoring/about.html) 0.045 0.044 0.0 0.044
295 2021-08-05T19:15:51.194453+00:00 app[web.1]: measure#nginx.service=0.045 request="GET /2006 HTTP/1.1" status_code=301 request_id=1c82206e-4df0-4da3-8ebc-44671bbd71b9 remote_addr="10.1.28.143" forwarded_for="34.147.114.27, 141.101.76.237" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.045" upstream_response_time="0.044" upstream_connect_time="0.000" upstream_header_time="0.044"; 0.045 GET /2006 HTTP/1.1 301 1c82206e-4df0-4da3-8ebc-44671bbd71b9 10.1.28.143 34.147.114.27, 141.101.76.237 http 1.1 vegur 0 - newspaper/0.2.8 0.045 0.044 0.0 0.044
300 2021-08-05T19:15:51.544439+00:00 app[web.1]: measure#nginx.service=0.045 request="GET /tags HTTP/1.1" status_code=301 request_id=0348dd88-7441-42a4-b7cc-7bb70afc0cfe remote_addr="10.1.7.130" forwarded_for="34.147.114.27, 172.69.54.94" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="newspaper/0.2.8" request_time="0.045" upstream_response_time="0.044" upstream_connect_time="0.000" upstream_header_time="0.044"; 0.045 GET /tags HTTP/1.1 301 0348dd88-7441-42a4-b7cc-7bb70afc0cfe 10.1.7.130 34.147.114.27, 172.69.54.94 http 1.1 vegur 0 - newspaper/0.2.8 0.045 0.044 0.0 0.044
231 2021-08-05T19:14:27.626450+00:00 app[web.1]: measure#nginx.service=0.042 request="GET /swn-everything HTTP/1.1" status_code=301 request_id=c1b79cf8-ff76-4151-b33e-a507d6620728 remote_addr="10.1.7.130" forwarded_for="79.147.57.124, 188.114.111.163" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) News Explorer/1.9" request_time="0.042" upstream_response_time="0.040" upstream_connect_time="0.000" upstream_header_time="0.040"; 0.042 GET /swn-everything HTTP/1.1 301 c1b79cf8-ff76-4151-b33e-a507d6620728 10.1.7.130 79.147.57.124, 188.114.111.163 http 1.1 vegur 5 - Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) News Explorer/1.9 0.042 0.04 0.0 0.04
352 2021-08-05T19:16:27.003937+00:00 app[web.1]: measure#nginx.service=0.040 request="GET /rss HTTP/1.1" status_code=301 request_id=0750a249-359e-4f83-993a-f5cc8a33ff7c remote_addr="10.1.58.55" forwarded_for="2600:3c03::f03c:91ff:fe9d:7b56, 162.158.63.66" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="Feed Wrangler/1.0 (3 subscribers; feed-id=272116; http://feedwrangler.net; Allow like Gecko)" request_time="0.040" upstream_response_time="0.040" upstream_connect_time="0.000" upstream_header_time="0.036"; 0.04 GET /rss HTTP/1.1 301 0750a249-359e-4f83-993a-f5cc8a33ff7c 10.1.58.55 2600:3c03::f03c:91ff:fe9d:7b56, 162.158.63.66 http 1.1 vegur 5 - Feed Wrangler/1.0 (3 subscribers; feed-id=272116; http://feedwrangler.net; Allow like Gecko) 0.04 0.04 0.0 0.036
396 2021-08-05T19:17:29.085126+00:00 app[web.1]: measure#nginx.service=0.025 request="GET /swn-everything HTTP/1.1" status_code=301 request_id=7e789417-0a66-411d-9df3-f1ca932ab637 remote_addr="10.1.92.174" forwarded_for="31.170.123.77, 162.158.159.109" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="Fever/1.39 (Feed Parser; http://feedafever.com; Allow like Gecko)" request_time="0.025" upstream_response_time="0.024" upstream_connect_time="0.000" upstream_header_time="0.024"; 0.025 GET /swn-everything HTTP/1.1 301 7e789417-0a66-411d-9df3-f1ca932ab637 10.1.92.174 31.170.123.77, 162.158.159.109 http 1.1 vegur 5 - Fever/1.39 (Feed Parser; http://feedafever.com; Allow like Gecko) 0.025 0.024 0.0 0.024

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