25 rows where remote_addr = "10.1.7.130"

View and edit SQL

Suggested facets: measure#nginx.service, request, status_code, body_bytes_sent, user_agent, request_time, upstream_response_time, upstream_header_time

remote_addr

  • 10.1.7.130 · 25
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
18 2021-08-05T19:09:08.573755+00:00 app[web.1]: measure#nginx.service=0.553 request="GET /search/?page=1&month=2&tag=antirez&type=blogmark HTTP/1.1" status_code=200 request_id=57c249ab-50e7-4dc0-8acc-279963838516 remote_addr="10.1.7.130" forwarded_for="114.119.131.90, 162.158.165.231" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5956 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.553" upstream_response_time="0.552" upstream_connect_time="0.000" upstream_header_time="0.552"; 0.553 GET /search/?page=1&month=2&tag=antirez&type=blogmark HTTP/1.1 200 57c249ab-50e7-4dc0-8acc-279963838516 10.1.7.130 114.119.131.90, 162.158.165.231 http 1.1 vegur 5956 - 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.553 0.552 0.0 0.552
69 2021-08-05T19:10:33.008154+00:00 app[web.1]: measure#nginx.service=0.347 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=5f661005-256f-48f0-a93d-b3125c47dd37 remote_addr="10.1.7.130" forwarded_for="221.139.84.141, 172.70.143.24" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="FeedReader 2.11.0" request_time="0.347" upstream_response_time="0.348" upstream_connect_time="0.000" upstream_header_time="0.340"; 0.347 GET /atom/everything/ HTTP/1.1 200 5f661005-256f-48f0-a93d-b3125c47dd37 10.1.7.130 221.139.84.141, 172.70.143.24 http 1.1 vegur 155913 - FeedReader 2.11.0 0.347 0.348 0.0 0.34
92 2021-08-05T19:10:56.510658+00:00 app[web.1]: measure#nginx.service=0.679 request="GET /search/?tag=csstransforms&tag=javascript&tag=performance&tag=firefox35&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=ffd4f618-e73d-4707-b507-42aabc3ee4bf remote_addr="10.1.7.130" forwarded_for="54.161.41.102, 172.70.34.89" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10684 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="0.679" upstream_response_time="0.676" upstream_connect_time="0.000" upstream_header_time="0.676"; 0.679 GET /search/?tag=csstransforms&tag=javascript&tag=performance&tag=firefox35&type=blogmark&year=2009 HTTP/1.1 200 ffd4f618-e73d-4707-b507-42aabc3ee4bf 10.1.7.130 54.161.41.102, 172.70.34.89 http 1.1 vegur 10684 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 0.679 0.676 0.0 0.676
95 2021-08-05T19:11:03.980905+00:00 app[web.1]: measure#nginx.service=5.105 request="GET /search/?tag=localstorage&tag=mozilla&tag=audio&tag=html5&tag=javascript&tag=performance&tag=video&month=6&year=2009 HTTP/1.1" status_code=200 request_id=62d16624-9280-4085-95f4-95f665bee314 remote_addr="10.1.7.130" forwarded_for="54.161.41.102, 172.70.34.139" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12681 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="5.105" upstream_response_time="5.104" upstream_connect_time="0.000" upstream_header_time="5.104"; 5.105 GET /search/?tag=localstorage&tag=mozilla&tag=audio&tag=html5&tag=javascript&tag=performance&tag=video&month=6&year=2009 HTTP/1.1 200 62d16624-9280-4085-95f4-95f665bee314 10.1.7.130 54.161.41.102, 172.70.34.139 http 1.1 vegur 12681 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 5.105 5.104 0.0 5.104
111 2021-08-05T19:11:30.857621+00:00 app[web.1]: measure#nginx.service=0.137 request="GET /search/?page=1&year=2007&tag=opensocialweb&month=12 HTTP/1.1" status_code=200 request_id=558bb800-30ac-48b6-93e6-5b58acbb6cc8 remote_addr="10.1.7.130" forwarded_for="114.119.154.13, 172.68.144.62" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6043 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.137" upstream_response_time="0.136" upstream_connect_time="0.000" upstream_header_time="0.136"; 0.137 GET /search/?page=1&year=2007&tag=opensocialweb&month=12 HTTP/1.1 200 558bb800-30ac-48b6-93e6-5b58acbb6cc8 10.1.7.130 114.119.154.13, 172.68.144.62 http 1.1 vegur 6043 - 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.137 0.136 0.0 0.136
133 2021-08-05T19:12:02.599372+00:00 app[web.1]: measure#nginx.service=0.277 request="GET /tags/recruiting/ HTTP/1.1" status_code=200 request_id=d5ad7faa-5191-4b13-8c5a-77f97a4fe930 remote_addr="10.1.7.130" forwarded_for="157.55.39.144, 108.162.246.139" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11339 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.277" upstream_response_time="0.276" upstream_connect_time="0.000" upstream_header_time="0.276"; 0.277 GET /tags/recruiting/ HTTP/1.1 200 d5ad7faa-5191-4b13-8c5a-77f97a4fe930 10.1.7.130 157.55.39.144, 108.162.246.139 http 1.1 vegur 11339 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 0.277 0.276 0.0 0.276
138 2021-08-05T19:12:11.898136+00:00 app[web.1]: measure#nginx.service=1.570 request="GET /2004/May/18/eurovision/ HTTP/1.1" status_code=200 request_id=fcdafe94-db39-400b-be1b-c5b9ed6c5da4 remote_addr="10.1.7.130" forwarded_for="157.55.39.144, 108.162.245.74" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=3348 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.570" upstream_response_time="1.572" upstream_connect_time="0.000" upstream_header_time="1.572"; 1.57 GET /2004/May/18/eurovision/ HTTP/1.1 200 fcdafe94-db39-400b-be1b-c5b9ed6c5da4 10.1.7.130 157.55.39.144, 108.162.245.74 http 1.1 vegur 3348 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 1.57 1.572 0.0 1.572
149 2021-08-05T19:12:29.421141+00:00 app[web.1]: measure#nginx.service=3.598 request="GET /search/?tag=webworkers&tag=offlineresources&tag=textshadow&tag=firefox&tag=html5&tag=browsers&tag=tracemonkey&tag=json&type=blogmark&year=2009&month=6 HTTP/1.1" status_code=200 request_id=f842302c-eca6-4f1d-a140-739d2623cb56 remote_addr="10.1.7.130" forwarded_for="54.161.41.102, 172.70.34.11" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14846 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.598" upstream_response_time="3.600" upstream_connect_time="0.000" upstream_header_time="3.600"; 3.598 GET /search/?tag=webworkers&tag=offlineresources&tag=textshadow&tag=firefox&tag=html5&tag=browsers&tag=tracemonkey&tag=json&type=blogmark&year=2009&month=6 HTTP/1.1 200 f842302c-eca6-4f1d-a140-739d2623cb56 10.1.7.130 54.161.41.102, 172.70.34.11 http 1.1 vegur 14846 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.598 3.6 0.0 3.6
163 2021-08-05T19:12:51.967883+00:00 app[web.1]: measure#nginx.service=1.923 request="GET /search/?q%3Dpostgresql&month=12&type=blogmark&tag=rails HTTP/1.1" status_code=200 request_id=63586074-d224-406f-82c9-fd9be2129b5a remote_addr="10.1.7.130" forwarded_for="114.119.143.135, 172.70.142.140" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11085 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.923" upstream_response_time="1.924" upstream_connect_time="0.000" upstream_header_time="1.924"; 1.923 GET /search/?q%3Dpostgresql&month=12&type=blogmark&tag=rails HTTP/1.1 200 63586074-d224-406f-82c9-fd9be2129b5a 10.1.7.130 114.119.143.135, 172.70.142.140 http 1.1 vegur 11085 - 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.923 1.924 0.0 1.924
166 2021-08-05T19:12:54.789260+00:00 app[web.1]: measure#nginx.service=0.121 request="GET /search/?year=2007&tag=textmate&type=blogmark&month=1 HTTP/1.1" status_code=200 request_id=6031fd8c-d238-4389-908a-f5ce660273fe remote_addr="10.1.7.130" forwarded_for="114.119.151.84, 172.70.142.19" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5704 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.121" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; 0.121 GET /search/?year=2007&tag=textmate&type=blogmark&month=1 HTTP/1.1 200 6031fd8c-d238-4389-908a-f5ce660273fe 10.1.7.130 114.119.151.84, 172.70.142.19 http 1.1 vegur 5704 - 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.121 0.12 0.0 0.12
181 2021-08-05T19:13:24.787620+00:00 app[web.1]: measure#nginx.service=6.230 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&year=2007 HTTP/1.1" status_code=200 request_id=0e44a5f1-5852-42f3-8bab-aa90ed815ca8 remote_addr="10.1.7.130" forwarded_for="167.114.100.201, 172.70.126.42" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6787 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="6.230" upstream_response_time="6.232" upstream_connect_time="0.000" upstream_header_time="6.232"; 6.23 GET /search/?tag=amazon&tag=erlang&tag=simpledb&year=2007 HTTP/1.1 200 0e44a5f1-5852-42f3-8bab-aa90ed815ca8 10.1.7.130 167.114.100.201, 172.70.126.42 http 1.1 vegur 6787 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 6.23 6.232 0.0 6.232
215 2021-08-05T19:14:08.821284+00:00 app[web.1]: measure#nginx.service=4.949 request="GET /search/?tag=async&tag=perlbal&tag=eventloop&tag=eventio HTTP/1.1" status_code=200 request_id=1fef589a-8905-4530-b148-f840473508bb remote_addr="10.1.7.130" forwarded_for="158.69.243.99, 172.70.127.9" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6652 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="4.949" upstream_response_time="4.948" upstream_connect_time="0.000" upstream_header_time="4.948"; 4.949 GET /search/?tag=async&tag=perlbal&tag=eventloop&tag=eventio HTTP/1.1 200 1fef589a-8905-4530-b148-f840473508bb 10.1.7.130 158.69.243.99, 172.70.127.9 http 1.1 vegur 6652 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 4.949 4.948 0.0 4.948
230 2021-08-05T19:14:25.870115+00:00 app[web.1]: measure#nginx.service=0.227 request="GET /search/?page=1&tag=github&month=11 HTTP/1.1" status_code=200 request_id=53b1b715-3624-4f2f-b32c-ef7e71a2aa99 remote_addr="10.1.7.130" forwarded_for="114.119.157.236, 172.70.147.162" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=18442 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.227" upstream_response_time="0.228" upstream_connect_time="0.000" upstream_header_time="0.228"; 0.227 GET /search/?page=1&tag=github&month=11 HTTP/1.1 200 53b1b715-3624-4f2f-b32c-ef7e71a2aa99 10.1.7.130 114.119.157.236, 172.70.147.162 http 1.1 vegur 18442 - 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.227 0.228 0.0 0.228
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
275 2021-08-05T19:15:26.227245+00:00 app[web.1]: measure#nginx.service=0.121 request="GET /2007/May/16/upload/ HTTP/1.1" status_code=200 request_id=c13d1a33-2631-48ed-ad3f-ffb29bd57038 remote_addr="10.1.7.130" forwarded_for="54.36.148.169, 141.101.77.127" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=4156 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="0.121" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; 0.121 GET /2007/May/16/upload/ HTTP/1.1 200 c13d1a33-2631-48ed-ad3f-ffb29bd57038 10.1.7.130 54.36.148.169, 141.101.77.127 http 1.1 vegur 4156 - Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) 0.121 0.12 0.0 0.12
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
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
305 2021-08-05T19:15:52.539377+00:00 app[web.1]: measure#nginx.service=0.726 request="GET /2003/ HTTP/1.1" status_code=200 request_id=978870ae-cbbe-4c71-b65a-03ee0ad2ba58 remote_addr="10.1.7.130" forwarded_for="34.147.114.27, 141.101.76.249" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=61959 referer="-" user_agent="newspaper/0.2.8" request_time="0.726" upstream_response_time="0.724" upstream_connect_time="0.000" upstream_header_time="0.724"; 0.726 GET /2003/ HTTP/1.1 200 978870ae-cbbe-4c71-b65a-03ee0ad2ba58 10.1.7.130 34.147.114.27, 141.101.76.249 http 1.1 vegur 61959 - newspaper/0.2.8 0.726 0.724 0.0 0.724
332 2021-08-05T19:16:04.608658+00:00 app[web.1]: measure#nginx.service=4.577 request="GET /search/?page=1&tag=rails&tag=bbc HTTP/1.1" status_code=200 request_id=ec416683-a3da-4927-950d-678b7f4d4577 remote_addr="10.1.7.130" forwarded_for="13.66.139.0, 162.158.106.47" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5506 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="4.577" upstream_response_time="4.576" upstream_connect_time="0.000" upstream_header_time="4.576"; 4.577 GET /search/?page=1&tag=rails&tag=bbc HTTP/1.1 200 ec416683-a3da-4927-950d-678b7f4d4577 10.1.7.130 13.66.139.0, 162.158.106.47 http 1.1 vegur 5506 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 4.577 4.576 0.0 4.576
343 2021-08-05T19:16:18.547002+00:00 app[web.1]: measure#nginx.service=7.719 request="GET /search/?tag=gears&type=blogmark&page=1 HTTP/1.1" status_code=200 request_id=37cc6de9-7c1c-4821-a687-5745e60adf25 remote_addr="10.1.7.130" forwarded_for="114.119.131.93, 172.70.143.79" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11520 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="7.719" upstream_response_time="7.716" upstream_connect_time="0.000" upstream_header_time="7.716"; 7.719 GET /search/?tag=gears&type=blogmark&page=1 HTTP/1.1 200 37cc6de9-7c1c-4821-a687-5745e60adf25 10.1.7.130 114.119.131.93, 172.70.143.79 http 1.1 vegur 11520 - 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) 7.719 7.716 0.0 7.716
429 2021-08-05T19:18:14.262866+00:00 app[web.1]: measure#nginx.service=3.164 request="GET /search/?q=javascript&year=2008&tag=erlang HTTP/1.1" status_code=200 request_id=9cca56df-1939-4b54-9a35-590a118f1042 remote_addr="10.1.7.130" forwarded_for="114.119.151.153, 172.70.143.4" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5882 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.164" upstream_response_time="3.164" upstream_connect_time="0.000" upstream_header_time="3.164"; 3.164 GET /search/?q=javascript&year=2008&tag=erlang HTTP/1.1 200 9cca56df-1939-4b54-9a35-590a118f1042 10.1.7.130 114.119.151.153, 172.70.143.4 http 1.1 vegur 5882 - 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.164 3.164 0.0 3.164
431 2021-08-05T19:18:16.717383+00:00 app[web.1]: measure#nginx.service=2.547 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=2199d195-af33-4ff5-a7f2-cd7d65bc8ec7 remote_addr="10.1.7.130" forwarded_for="20.186.4.103, 173.245.54.244" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="feedparser/6.0.8 +https://github.com/kurtmckee/feedparser/" request_time="2.547" upstream_response_time="2.548" upstream_connect_time="0.000" upstream_header_time="2.544"; 2.547 GET /atom/entries/ HTTP/1.1 200 2199d195-af33-4ff5-a7f2-cd7d65bc8ec7 10.1.7.130 20.186.4.103, 173.245.54.244 http 1.1 vegur 207454 - feedparser/6.0.8 +https://github.com/kurtmckee/feedparser/ 2.547 2.548 0.0 2.544
445 2021-08-05T19:18:44.721501+00:00 app[web.1]: measure#nginx.service=11.891 request="GET /search/?year=2020&month=5&tag=pip HTTP/1.1" status_code=200 request_id=bde3cd19-8c9d-4f7d-b8ae-23224d4875e6 remote_addr="10.1.7.130" forwarded_for="114.119.154.13, 172.68.144.120" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5837 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="11.891" upstream_response_time="11.892" upstream_connect_time="0.000" upstream_header_time="11.892"; 11.891 GET /search/?year=2020&month=5&tag=pip HTTP/1.1 200 bde3cd19-8c9d-4f7d-b8ae-23224d4875e6 10.1.7.130 114.119.154.13, 172.68.144.120 http 1.1 vegur 5837 - 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) 11.891 11.892 0.0 11.892
467 2021-08-05T19:19:17.262804+00:00 app[web.1]: measure#nginx.service=14.379 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=657ff3d2-6e20-40fb-a2a0-fa4ede4833a5 remote_addr="10.1.7.130" 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="14.379" upstream_response_time="14.376" upstream_connect_time="0.000" upstream_header_time="14.372"; 14.379 GET /atom/everything/ HTTP/1.1 200 657ff3d2-6e20-40fb-a2a0-fa4ede4833a5 10.1.7.130 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 14.379 14.376 0.0 14.372
476 2021-08-05T19:19:28.911115+00:00 app[web.1]: measure#nginx.service=11.179 request="GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=scaling HTTP/1.1" status_code=200 request_id=5d6248d0-b9e7-4e2c-8da8-237a4d1859d5 remote_addr="10.1.7.130" forwarded_for="167.114.100.201, 172.70.126.242" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6649 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="11.179" upstream_response_time="11.176" upstream_connect_time="0.000" upstream_header_time="11.176"; 11.179 GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=scaling HTTP/1.1 200 5d6248d0-b9e7-4e2c-8da8-237a4d1859d5 10.1.7.130 167.114.100.201, 172.70.126.242 http 1.1 vegur 6649 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 11.179 11.176 0.0 11.176

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