log
25 rows where body_bytes_sent = 0 and status_code = 301 sorted by request_time descending
This data as json, CSV (advanced)
Suggested facets: measure#nginx.service, remote_addr, user_agent, request_time, upstream_response_time, upstream_header_time
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 454 | 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 | 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 | 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 | 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 | 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 | 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 |
| 319 | 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 | 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 |
| 311 | 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 | 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 | 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 | 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 | 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 |
| 307 | 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 | 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 | 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 | 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 | 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 | 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 | 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 |
| 191 | 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 |
| 296 | 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 |
| 295 | 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 | 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 |
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 );