24 rows where remote_addr = "10.1.28.143" sorted by user_agent

View and edit SQL

Suggested facets: request, status_code, body_bytes_sent, user_agent, upstream_response_time, upstream_header_time

remote_addr

  • 10.1.28.143 · 24
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
339 2021-08-05T19:16:14.922155+00:00 app[web.1]: measure#nginx.service=6.673 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=20b4bbd1-ddc3-4b66-b249-fa66615c2271 remote_addr="10.1.28.143" forwarded_for="8.29.198.27, 172.70.98.91" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Feedly/1.0 (+http://www.feedly.com/fetcher.html; 593 subscribers; like FeedFetcher-Google)" request_time="6.673" upstream_response_time="6.672" upstream_connect_time="0.000" upstream_header_time="6.668"; 6.673 GET /atom/entries/ HTTP/1.1 200 20b4bbd1-ddc3-4b66-b249-fa66615c2271 10.1.28.143 8.29.198.27, 172.70.98.91 http 1.1 vegur 207454 - Feedly/1.0 (+http://www.feedly.com/fetcher.html; 593 subscribers; like FeedFetcher-Google) 6.673 6.672 0.0 6.668
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
88 2021-08-05T19:10:52.919914+00:00 app[web.1]: measure#nginx.service=0.098 request="GET /search/?page=1&type=blogmark&tag=reference&year=2009&month=2 HTTP/1.1" status_code=200 request_id=6443d69a-76ff-47a2-9399-1201b7e3b521 remote_addr="10.1.28.143" forwarded_for="114.119.137.173, 172.70.147.57" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6990 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.098" upstream_response_time="0.100" upstream_connect_time="0.000" upstream_header_time="0.100"; 0.098 GET /search/?page=1&type=blogmark&tag=reference&year=2009&month=2 HTTP/1.1 200 6443d69a-76ff-47a2-9399-1201b7e3b521 10.1.28.143 114.119.137.173, 172.70.147.57 http 1.1 vegur 6990 - 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.098 0.1 0.0 0.1
96 2021-08-05T19:11:07.456526+00:00 app[web.1]: measure#nginx.service=0.130 request="GET /search/?page=1&year=2009&tag=db2&month=2&type=blogmark HTTP/1.1" status_code=200 request_id=26a5e383-80be-4506-a24d-3f5788cb3763 remote_addr="10.1.28.143" forwarded_for="114.119.138.95, 172.70.142.4" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7026 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.130" upstream_response_time="0.132" upstream_connect_time="0.000" upstream_header_time="0.132"; 0.13 GET /search/?page=1&year=2009&tag=db2&month=2&type=blogmark HTTP/1.1 200 26a5e383-80be-4506-a24d-3f5788cb3763 10.1.28.143 114.119.138.95, 172.70.142.4 http 1.1 vegur 7026 - 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.13 0.132 0.0 0.132
188 2021-08-05T19:13:30.709431+00:00 app[web.1]: measure#nginx.service=0.131 request="GET /search/?page=1&month=6&year=2008&type=blogmark&tag=php HTTP/1.1" status_code=200 request_id=d7d7add4-e816-436b-86c6-591f883b6aac remote_addr="10.1.28.143" forwarded_for="114.119.131.46, 172.70.143.89" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8371 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.131" upstream_response_time="0.132" upstream_connect_time="0.000" upstream_header_time="0.132"; 0.131 GET /search/?page=1&month=6&year=2008&type=blogmark&tag=php HTTP/1.1 200 d7d7add4-e816-436b-86c6-591f883b6aac 10.1.28.143 114.119.131.46, 172.70.143.89 http 1.1 vegur 8371 - 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.131 0.132 0.0 0.132
268 2021-08-05T19:15:17.761735+00:00 app[web.1]: measure#nginx.service=0.196 request="GET /search/?q%3Dpostgresql&page=1&tag=bazaar&type=blogmark&year=2008&month=6 HTTP/1.1" status_code=200 request_id=b13158cf-7b22-4745-a44a-00a005ec8bac remote_addr="10.1.28.143" forwarded_for="114.119.136.134, 172.70.143.68" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7935 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.196" upstream_response_time="0.196" upstream_connect_time="0.000" upstream_header_time="0.196"; 0.196 GET /search/?q%3Dpostgresql&page=1&tag=bazaar&type=blogmark&year=2008&month=6 HTTP/1.1 200 b13158cf-7b22-4745-a44a-00a005ec8bac 10.1.28.143 114.119.136.134, 172.70.143.68 http 1.1 vegur 7935 - 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.196 0.196 0.0 0.196
370 2021-08-05T19:16:48.506758+00:00 app[web.1]: measure#nginx.service=4.007 request="GET /search/?year=2020&type=blogmark&tag=rust HTTP/1.1" status_code=200 request_id=8c42c3e1-3094-4ae8-b3b8-4db4ad353094 remote_addr="10.1.28.143" forwarded_for="114.119.129.57, 172.70.147.20" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8582 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.007" upstream_response_time="4.004" upstream_connect_time="0.000" upstream_header_time="4.004"; 4.007 GET /search/?year=2020&type=blogmark&tag=rust HTTP/1.1 200 8c42c3e1-3094-4ae8-b3b8-4db4ad353094 10.1.28.143 114.119.129.57, 172.70.147.20 http 1.1 vegur 8582 - 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.007 4.004 0.0 4.004
114 2021-08-05T19:11:32.772892+00:00 app[web.1]: measure#nginx.service=0.147 request="GET /2008/Jan/8/ HTTP/1.1" status_code=200 request_id=ff1b91a7-c9b4-4538-a565-3ef1733bcad4 remote_addr="10.1.28.143" forwarded_for="66.249.73.59, 172.69.70.220" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6853 referer="-" user_agent="Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" request_time="0.147" upstream_response_time="0.148" upstream_connect_time="0.000" upstream_header_time="0.148"; 0.147 GET /2008/Jan/8/ HTTP/1.1 200 ff1b91a7-c9b4-4538-a565-3ef1733bcad4 10.1.28.143 66.249.73.59, 172.69.70.220 http 1.1 vegur 6853 - Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) 0.147 0.148 0.0 0.148
130 2021-08-05T19:12:00.696759+00:00 app[web.1]: measure#nginx.service=0.318 request="GET /search/?tag=async&tag=performance HTTP/1.1" status_code=200 request_id=d71a7b24-7d0b-4dc6-b985-b6f3f9bccb06 remote_addr="10.1.28.143" forwarded_for="158.69.243.99, 172.70.126.188" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5739 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.318" upstream_response_time="0.320" upstream_connect_time="0.000" upstream_header_time="0.320"; 0.318 GET /search/?tag=async&tag=performance HTTP/1.1 200 d71a7b24-7d0b-4dc6-b985-b6f3f9bccb06 10.1.28.143 158.69.243.99, 172.70.126.188 http 1.1 vegur 5739 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.318 0.32 0.0 0.32
186 2021-08-05T19:13:28.764560+00:00 app[web.1]: measure#nginx.service=0.272 request="GET /search/?tag=async&tag=perlbal&tag=eventio&type=blogmark HTTP/1.1" status_code=200 request_id=679e0514-87a6-4496-b2b3-f5d8e6e2db90 remote_addr="10.1.28.143" forwarded_for="158.69.243.99, 172.70.126.214" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6657 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.272" upstream_response_time="0.272" upstream_connect_time="0.000" upstream_header_time="0.272"; 0.272 GET /search/?tag=async&tag=perlbal&tag=eventio&type=blogmark HTTP/1.1 200 679e0514-87a6-4496-b2b3-f5d8e6e2db90 10.1.28.143 158.69.243.99, 172.70.126.214 http 1.1 vegur 6657 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.272 0.272 0.0 0.272
407 2021-08-05T19:17:42.340815+00:00 app[web.1]: measure#nginx.service=0.744 request="GET /search/?tag=async&tag=promise&tag=javascript HTTP/1.1" status_code=200 request_id=0bb6f66d-e9d3-4c5f-a961-aa2dc18a3864 remote_addr="10.1.28.143" forwarded_for="158.69.243.99, 172.70.126.50" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6142 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.744" upstream_response_time="0.744" upstream_connect_time="0.000" upstream_header_time="0.744"; 0.744 GET /search/?tag=async&tag=promise&tag=javascript HTTP/1.1 200 0bb6f66d-e9d3-4c5f-a961-aa2dc18a3864 10.1.28.143 158.69.243.99, 172.70.126.50 http 1.1 vegur 6142 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.744 0.744 0.0 0.744
465 2021-08-05T19:19:16.524671+00:00 app[web.1]: measure#nginx.service=17.435 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=ed598f4f-a2dd-43f0-b42f-683163a1f241 remote_addr="10.1.28.143" forwarded_for="94.130.182.203, 162.158.88.113" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app)" request_time="17.435" upstream_response_time="17.436" upstream_connect_time="0.000" upstream_header_time="17.432"; 17.435 GET /atom/entries/ HTTP/1.1 200 ed598f4f-a2dd-43f0-b42f-683163a1f241 10.1.28.143 94.130.182.203, 162.158.88.113 http 1.1 vegur 207454 - Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app) 17.435 17.436 0.0 17.432
19 2021-08-05T19:09:10.326693+00:00 app[web.1]: measure#nginx.service=3.991 request="GET /search/?tag=csstransforms&tag=video&tag=json&tag=crossdomain&tag=javascript&tag=fonts&tag=localstorage&tag=dragndrop&type=blogmark HTTP/1.1" status_code=200 request_id=d73583f9-0a79-4cc6-9602-04de52df485b remote_addr="10.1.28.143" forwarded_for="54.161.41.102, 172.70.34.29" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12781 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.991" upstream_response_time="3.988" upstream_connect_time="0.000" upstream_header_time="3.988"; 3.991 GET /search/?tag=csstransforms&tag=video&tag=json&tag=crossdomain&tag=javascript&tag=fonts&tag=localstorage&tag=dragndrop&type=blogmark HTTP/1.1 200 d73583f9-0a79-4cc6-9602-04de52df485b 10.1.28.143 54.161.41.102, 172.70.34.29 http 1.1 vegur 12781 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.991 3.988 0.0 3.988
185 2021-08-05T19:13:28.478276+00:00 app[web.1]: measure#nginx.service=2.571 request="GET /search/?tag=firefox35&tag=localstorage&tag=javascript&tag=canvas&tag=firefox&tag=performance&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=00b2a07e-4064-4c00-9d92-1f04dbc14dd0 remote_addr="10.1.28.143" forwarded_for="54.161.41.102, 172.70.34.125" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11963 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.571" upstream_response_time="2.568" upstream_connect_time="0.000" upstream_header_time="2.568"; 2.571 GET /search/?tag=firefox35&tag=localstorage&tag=javascript&tag=canvas&tag=firefox&tag=performance&type=blogmark&month=6 HTTP/1.1 200 00b2a07e-4064-4c00-9d92-1f04dbc14dd0 10.1.28.143 54.161.41.102, 172.70.34.125 http 1.1 vegur 11963 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.571 2.568 0.0 2.568
277 2021-08-05T19:15:28.255433+00:00 app[web.1]: measure#nginx.service=3.814 request="GET /search/?tag=tracemonkey&tag=firefox&tag=audio&tag=mozilla&tag=webworkers&tag=dragndrop&tag=localstorage&tag=geolocation&type=blogmark HTTP/1.1" status_code=200 request_id=e14481f0-d3ea-4225-9c03-4dc38d36746a remote_addr="10.1.28.143" forwarded_for="54.161.41.102, 172.70.35.86" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12886 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.814" upstream_response_time="3.812" upstream_connect_time="0.000" upstream_header_time="3.812"; 3.814 GET /search/?tag=tracemonkey&tag=firefox&tag=audio&tag=mozilla&tag=webworkers&tag=dragndrop&tag=localstorage&tag=geolocation&type=blogmark HTTP/1.1 200 e14481f0-d3ea-4225-9c03-4dc38d36746a 10.1.28.143 54.161.41.102, 172.70.35.86 http 1.1 vegur 12886 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.814 3.812 0.0 3.812
335 2021-08-05T19:16:12.146853+00:00 app[web.1]: measure#nginx.service=11.936 request="GET /search/?tag=offlineresources&tag=mozilla&tag=html5&tag=audio&tag=video&tag=performance&tag=textshadow&tag=tracemonkey&type=blogmark&month=6&year=2009 HTTP/1.1" status_code=200 request_id=73cf3c35-e9e5-4c68-ace3-756556ccbb94 remote_addr="10.1.28.143" forwarded_for="54.161.41.102, 172.70.34.115" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14808 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="11.936" upstream_response_time="11.936" upstream_connect_time="0.000" upstream_header_time="11.936"; 11.936 GET /search/?tag=offlineresources&tag=mozilla&tag=html5&tag=audio&tag=video&tag=performance&tag=textshadow&tag=tracemonkey&type=blogmark&month=6&year=2009 HTTP/1.1 200 73cf3c35-e9e5-4c68-ace3-756556ccbb94 10.1.28.143 54.161.41.102, 172.70.34.115 http 1.1 vegur 14808 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 11.936 11.936 0.0 11.936
341 2021-08-05T19:16:15.175752+00:00 app[web.1]: measure#nginx.service=9.953 request="GET /search/?tag=firefox35&tag=csstransforms&tag=browsers&tag=webworkers&tag=mozilla&tag=video&tag=canvas&tag=firefox&tag=audio&month=6&type=blogmark HTTP/1.1" status_code=200 request_id=229a1446-92c2-42d9-9301-15b98b783060 remote_addr="10.1.28.143" forwarded_for="54.161.41.102, 172.70.34.15" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14291 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="9.953" upstream_response_time="9.956" upstream_connect_time="0.000" upstream_header_time="9.956"; 9.953 GET /search/?tag=firefox35&tag=csstransforms&tag=browsers&tag=webworkers&tag=mozilla&tag=video&tag=canvas&tag=firefox&tag=audio&month=6&type=blogmark HTTP/1.1 200 229a1446-92c2-42d9-9301-15b98b783060 10.1.28.143 54.161.41.102, 172.70.34.15 http 1.1 vegur 14291 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 9.953 9.956 0.0 9.956
368 2021-08-05T19:16:48.173169+00:00 app[web.1]: measure#nginx.service=13.790 request="GET /search/?tag=fonts&tag=webworkers&tag=javascript&tag=geolocation&tag=firefox35&tag=crossdomain&tag=textshadow&tag=performance&year=2009 HTTP/1.1" status_code=200 request_id=34dd2ca6-a8a3-42ca-a01e-62ba1bc60ce5 remote_addr="10.1.28.143" forwarded_for="54.161.41.102, 172.70.34.195" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13241 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="13.790" upstream_response_time="13.792" upstream_connect_time="0.000" upstream_header_time="13.792"; 13.79 GET /search/?tag=fonts&tag=webworkers&tag=javascript&tag=geolocation&tag=firefox35&tag=crossdomain&tag=textshadow&tag=performance&year=2009 HTTP/1.1 200 34dd2ca6-a8a3-42ca-a01e-62ba1bc60ce5 10.1.28.143 54.161.41.102, 172.70.34.195 http 1.1 vegur 13241 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 13.79 13.792 0.0 13.792
390 2021-08-05T19:17:15.674809+00:00 app[web.1]: measure#nginx.service=4.083 request="GET /search/?tag=video&tag=crossdomain&tag=browsers&tag=audio&tag=firefox35&year=2009 HTTP/1.1" status_code=200 request_id=e256384a-0f2d-4632-b001-326e94333e6c remote_addr="10.1.28.143" forwarded_for="54.161.41.102, 172.70.34.47" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10217 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.083" upstream_response_time="4.080" upstream_connect_time="0.000" upstream_header_time="4.080"; 4.083 GET /search/?tag=video&tag=crossdomain&tag=browsers&tag=audio&tag=firefox35&year=2009 HTTP/1.1 200 e256384a-0f2d-4632-b001-326e94333e6c 10.1.28.143 54.161.41.102, 172.70.34.47 http 1.1 vegur 10217 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.083 4.08 0.0 4.08
243 2021-08-05T19:14:48.627061+00:00 app[web.1]: measure#nginx.service=0.236 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=4f37469d-4f5a-4459-ae0d-6cf006eeb849 remote_addr="10.1.28.143" forwarded_for="82.46.215.61, 141.101.99.230" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="NetNewsWire (RSS Reader; https://netnewswire.com/)" request_time="0.236" upstream_response_time="0.236" upstream_connect_time="0.000" upstream_header_time="0.232"; 0.236 GET /atom/everything/ HTTP/1.1 200 4f37469d-4f5a-4459-ae0d-6cf006eeb849 10.1.28.143 82.46.215.61, 141.101.99.230 http 1.1 vegur 155913 - NetNewsWire (RSS Reader; https://netnewswire.com/) 0.236 0.236 0.0 0.232
287 2021-08-05T19:15:41.092319+00:00 app[web.1]: measure#nginx.service=0.185 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=e0cbfac4-bb53-4711-8e5d-23f1c54544b0 remote_addr="10.1.28.143" forwarded_for="108.2.161.198, 172.70.110.171" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="NetNewsWire (RSS Reader; https://netnewswire.com/)" request_time="0.185" upstream_response_time="0.184" upstream_connect_time="0.000" upstream_header_time="0.180"; 0.185 GET /atom/entries/ HTTP/1.1 200 e0cbfac4-bb53-4711-8e5d-23f1c54544b0 10.1.28.143 108.2.161.198, 172.70.110.171 http 1.1 vegur 207454 - NetNewsWire (RSS Reader; https://netnewswire.com/) 0.185 0.184 0.0 0.18
12 2021-08-05T19:09:03.240066+00:00 app[web.1]: measure#nginx.service=0.234 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=75472618-4a0d-4622-8e6a-40a51f44fd53 remote_addr="10.1.28.143" forwarded_for="198.2.69.130, 162.158.126.167" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Reeder/5000.79.04 CFNetwork/1240.0.4 Darwin/20.5.0" request_time="0.234" upstream_response_time="0.236" upstream_connect_time="0.000" upstream_header_time="0.228"; 0.234 GET /atom/everything/ HTTP/1.1 200 75472618-4a0d-4622-8e6a-40a51f44fd53 10.1.28.143 198.2.69.130, 162.158.126.167 http 1.1 vegur 155913 - Reeder/5000.79.04 CFNetwork/1240.0.4 Darwin/20.5.0 0.234 0.236 0.0 0.228
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
45 2021-08-05T19:09:55.690367+00:00 app[web.1]: measure#nginx.service=3.933 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=af76da4c-0df6-4fba-949f-b290171930e7 remote_addr="10.1.28.143" forwarded_for="2a01:e34:ec95:f440:44b3:beed:96e3:1fa6, 108.162.229.11" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="okhttp/4.9.1" request_time="3.933" upstream_response_time="3.932" upstream_connect_time="0.000" upstream_header_time="3.928"; 3.933 GET /atom/everything/ HTTP/1.1 200 af76da4c-0df6-4fba-949f-b290171930e7 10.1.28.143 2a01:e34:ec95:f440:44b3:beed:96e3:1fa6, 108.162.229.11 http 1.1 vegur 155913 - okhttp/4.9.1 3.933 3.932 0.0 3.928

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