24 rows where remote_addr = "10.1.31.190"

View and edit SQL

Suggested facets: request, status_code, body_bytes_sent, user_agent

remote_addr

  • 10.1.31.190 · 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
5 2021-08-05T19:08:57.159513+00:00 app[web.1]: measure#nginx.service=1.914 request="GET /search/?tag=mozilla&tag=video&tag=geolocation&tag=tracemonkey&tag=offlineresources&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=b1ae3982-0aba-467a-89db-717d545be5a9 remote_addr="10.1.31.190" forwarded_for="54.161.41.102, 172.70.35.76" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11458 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.914" upstream_response_time="1.916" upstream_connect_time="0.000" upstream_header_time="1.916"; 1.914 GET /search/?tag=mozilla&tag=video&tag=geolocation&tag=tracemonkey&tag=offlineresources&type=blogmark&year=2009 HTTP/1.1 200 b1ae3982-0aba-467a-89db-717d545be5a9 10.1.31.190 54.161.41.102, 172.70.35.76 http 1.1 vegur 11458 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.914 1.916 0.0 1.916
7 2021-08-05T19:08:57.431732+00:00 app[web.1]: measure#nginx.service=0.468 request="GET /search/?tag=jakobnielsen&page=1&type=quotation HTTP/1.1" status_code=200 request_id=36c464e3-393e-49e1-8613-ce2fd41095e1 remote_addr="10.1.31.190" forwarded_for="114.119.142.125, 172.70.143.14" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5351 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.468" upstream_response_time="0.468" upstream_connect_time="0.000" upstream_header_time="0.468"; 0.468 GET /search/?tag=jakobnielsen&page=1&type=quotation HTTP/1.1 200 36c464e3-393e-49e1-8613-ce2fd41095e1 10.1.31.190 114.119.142.125, 172.70.143.14 http 1.1 vegur 5351 - 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.468 0.468 0.0 0.468
52 2021-08-05T19:10:09.001402+00:00 app[web.1]: measure#nginx.service=1.322 request="GET /search/?tag=performance&tag=audio&tag=textshadow&tag=html5&tag=csstransforms&tag=json&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=640e5ec5-23cd-4db1-97a5-226f2f3c43b4 remote_addr="10.1.31.190" forwarded_for="54.161.41.102, 172.70.34.167" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11949 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.322" upstream_response_time="1.324" upstream_connect_time="0.000" upstream_header_time="1.324"; 1.322 GET /search/?tag=performance&tag=audio&tag=textshadow&tag=html5&tag=csstransforms&tag=json&type=blogmark&year=2009 HTTP/1.1 200 640e5ec5-23cd-4db1-97a5-226f2f3c43b4 10.1.31.190 54.161.41.102, 172.70.34.167 http 1.1 vegur 11949 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.322 1.324 0.0 1.324
112 2021-08-05T19:11:31.105570+00:00 app[web.1]: measure#nginx.service=1.180 request="GET /search/?tag=audio&tag=json&tag=mozilla&tag=browsers&tag=video&tag=dragndrop&month=6&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=3d9fa967-0f0c-4846-a217-29a8e94697c6 remote_addr="10.1.31.190" forwarded_for="54.161.41.102, 172.70.34.161" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12398 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.180" upstream_response_time="1.180" upstream_connect_time="0.000" upstream_header_time="1.180"; 1.18 GET /search/?tag=audio&tag=json&tag=mozilla&tag=browsers&tag=video&tag=dragndrop&month=6&type=blogmark&year=2009 HTTP/1.1 200 3d9fa967-0f0c-4846-a217-29a8e94697c6 10.1.31.190 54.161.41.102, 172.70.34.161 http 1.1 vegur 12398 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.18 1.18 0.0 1.18
117 2021-08-05T19:11:36.234862+00:00 app[web.1]: measure#nginx.service=2.219 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=a1325db0-0fb6-4bac-a05e-527376e6c858 remote_addr="10.1.31.190" forwarded_for="2001:250:5002:8100::6687, 172.68.254.121" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36" request_time="2.219" upstream_response_time="2.216" upstream_connect_time="0.000" upstream_header_time="2.212"; 2.219 GET /atom/everything/ HTTP/1.1 200 a1325db0-0fb6-4bac-a05e-527376e6c858 10.1.31.190 2001:250:5002:8100::6687, 172.68.254.121 http 1.1 vegur 155913 - Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.107 Safari/537.36 2.219 2.216 0.0 2.212
122 2021-08-05T19:11:46.665175+00:00 app[web.1]: measure#nginx.service=4.526 request="GET /search/?tag=firefox35&tag=performance&tag=geolocation&tag=tracemonkey&tag=crossdomain&tag=textshadow&tag=video&tag=offlineresources&tag=browsers&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=ecfce4f8-c27a-41ad-b4e4-efffaf6da629 remote_addr="10.1.31.190" forwarded_for="54.161.41.102, 172.70.34.251" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=15406 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.526" upstream_response_time="4.528" upstream_connect_time="0.000" upstream_header_time="4.528"; 4.526 GET /search/?tag=firefox35&tag=performance&tag=geolocation&tag=tracemonkey&tag=crossdomain&tag=textshadow&tag=video&tag=offlineresources&tag=browsers&type=blogmark&year=2009 HTTP/1.1 200 ecfce4f8-c27a-41ad-b4e4-efffaf6da629 10.1.31.190 54.161.41.102, 172.70.34.251 http 1.1 vegur 15406 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.526 4.528 0.0 4.528
167 2021-08-05T19:12:57.822493+00:00 app[web.1]: measure#nginx.service=3.520 request="GET /search/?tag=textshadow&tag=webworkers&tag=crossdomain&tag=localstorage&tag=json&tag=tracemonkey&tag=geolocation&tag=csstransforms&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=53be17ec-5f65-47a1-9ce4-81e06a2254ea remote_addr="10.1.31.190" forwarded_for="54.161.41.102, 172.70.35.24" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14379 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.520" upstream_response_time="3.520" upstream_connect_time="0.000" upstream_header_time="3.520"; 3.52 GET /search/?tag=textshadow&tag=webworkers&tag=crossdomain&tag=localstorage&tag=json&tag=tracemonkey&tag=geolocation&tag=csstransforms&type=blogmark&year=2009 HTTP/1.1 200 53be17ec-5f65-47a1-9ce4-81e06a2254ea 10.1.31.190 54.161.41.102, 172.70.35.24 http 1.1 vegur 14379 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.52 3.52 0.0 3.52
175 2021-08-05T19:13:18.225912+00:00 app[web.1]: measure#nginx.service=12.317 request="GET /search/?tag=video&tag=dragndrop&tag=audio&tag=offlineresources&tag=crossdomain&tag=mozilla&tag=javascript&tag=html5&tag=browsers&type=blogmark HTTP/1.1" status_code=200 request_id=32cf39dd-e393-4d63-81e6-12afbbece009 remote_addr="10.1.31.190" forwarded_for="54.161.41.102, 172.70.34.249" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13635 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="12.317" upstream_response_time="12.316" upstream_connect_time="0.000" upstream_header_time="12.316"; 12.317 GET /search/?tag=video&tag=dragndrop&tag=audio&tag=offlineresources&tag=crossdomain&tag=mozilla&tag=javascript&tag=html5&tag=browsers&type=blogmark HTTP/1.1 200 32cf39dd-e393-4d63-81e6-12afbbece009 10.1.31.190 54.161.41.102, 172.70.34.249 http 1.1 vegur 13635 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 12.317 12.316 0.0 12.316
177 2021-08-05T19:13:18.605123+00:00 app[web.1]: measure#nginx.service=2.882 request="GET /search/?month=4&tag=scipy HTTP/1.1" status_code=200 request_id=4a3d207f-c3f4-4145-83ed-ea54a5eb42d5 remote_addr="10.1.31.190" forwarded_for="114.119.131.116, 172.70.142.224" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5690 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.882" upstream_response_time="2.884" upstream_connect_time="0.000" upstream_header_time="2.884"; 2.882 GET /search/?month=4&tag=scipy HTTP/1.1 200 4a3d207f-c3f4-4145-83ed-ea54a5eb42d5 10.1.31.190 114.119.131.116, 172.70.142.224 http 1.1 vegur 5690 - 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.882 2.884 0.0 2.884
187 2021-08-05T19:13:30.428771+00:00 app[web.1]: measure#nginx.service=0.543 request="GET /2020/ HTTP/1.1" status_code=200 request_id=da4c2ad5-4d25-49b9-bb11-75ff4be210f0 remote_addr="10.1.31.190" forwarded_for="66.249.73.55, 172.69.71.170" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13294 referer="-" user_agent="Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" request_time="0.543" upstream_response_time="0.544" upstream_connect_time="0.000" upstream_header_time="0.544"; 0.543 GET /2020/ HTTP/1.1 200 da4c2ad5-4d25-49b9-bb11-75ff4be210f0 10.1.31.190 66.249.73.55, 172.69.71.170 http 1.1 vegur 13294 - Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) 0.543 0.544 0.0 0.544
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
199 2021-08-05T19:13:50.889862+00:00 app[web.1]: measure#nginx.service=5.836 request="GET /search/?type=blogmark&tag=video&tag=javascript&tag=csstransforms&tag=webworkers&tag=tracemonkey&tag=browsers&tag=mozilla&tag=audio&month=6&year=2009 HTTP/1.1" status_code=200 request_id=0290ec7c-6b1b-4833-a9f0-b4c597efbc86 remote_addr="10.1.31.190" forwarded_for="54.161.41.102, 172.70.34.225" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14770 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="5.836" upstream_response_time="5.836" upstream_connect_time="0.000" upstream_header_time="5.836"; 5.836 GET /search/?type=blogmark&tag=video&tag=javascript&tag=csstransforms&tag=webworkers&tag=tracemonkey&tag=browsers&tag=mozilla&tag=audio&month=6&year=2009 HTTP/1.1 200 0290ec7c-6b1b-4833-a9f0-b4c597efbc86 10.1.31.190 54.161.41.102, 172.70.34.225 http 1.1 vegur 14770 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 5.836 5.836 0.0 5.836
242 2021-08-05T19:14:47.063152+00:00 app[web.1]: measure#nginx.service=4.821 request="GET /search/?tag=performance&tag=dragndrop&tag=csstransforms&tag=textshadow&tag=mozilla&tag=html5&tag=video&type=blogmark HTTP/1.1" status_code=200 request_id=f41a2d91-61df-4254-ad49-6b017c32f26e remote_addr="10.1.31.190" forwarded_for="54.161.41.102, 172.70.34.181" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11891 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.821" upstream_response_time="4.820" upstream_connect_time="0.000" upstream_header_time="4.820"; 4.821 GET /search/?tag=performance&tag=dragndrop&tag=csstransforms&tag=textshadow&tag=mozilla&tag=html5&tag=video&type=blogmark HTTP/1.1 200 f41a2d91-61df-4254-ad49-6b017c32f26e 10.1.31.190 54.161.41.102, 172.70.34.181 http 1.1 vegur 11891 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.821 4.82 0.0 4.82
264 2021-08-05T19:15:17.111662+00:00 app[web.1]: measure#nginx.service=1.822 request="GET /search/?tag=dragndrop&tag=tracemonkey&tag=json&tag=html5&tag=textshadow&tag=offlineresources&type=blogmark HTTP/1.1" status_code=200 request_id=58c998d8-76b0-46aa-acba-c64bc8fed051 remote_addr="10.1.31.190" forwarded_for="54.161.41.102, 172.70.34.77" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11169 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.822" upstream_response_time="1.824" upstream_connect_time="0.000" upstream_header_time="1.824"; 1.822 GET /search/?tag=dragndrop&tag=tracemonkey&tag=json&tag=html5&tag=textshadow&tag=offlineresources&type=blogmark HTTP/1.1 200 58c998d8-76b0-46aa-acba-c64bc8fed051 10.1.31.190 54.161.41.102, 172.70.34.77 http 1.1 vegur 11169 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.822 1.824 0.0 1.824
290 2021-08-05T19:15:45.623815+00:00 app[web.1]: measure#nginx.service=0.092 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=44a6fe23-dda9-41f4-9741-4a455bbbdaf0 remote_addr="10.1.31.190" forwarded_for="103.137.15.20, 172.69.162.147" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Reeder/5000.79.04 CFNetwork/1240.0.4 Darwin/20.6.0" request_time="0.092" upstream_response_time="0.092" upstream_connect_time="0.000" upstream_header_time="0.088"; 0.092 GET /atom/entries/ HTTP/1.1 200 44a6fe23-dda9-41f4-9741-4a455bbbdaf0 10.1.31.190 103.137.15.20, 172.69.162.147 http 1.1 vegur 207454 - Reeder/5000.79.04 CFNetwork/1240.0.4 Darwin/20.6.0 0.092 0.092 0.0 0.088
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
312 2021-08-05T19:15:53.269524+00:00 app[web.1]: measure#nginx.service=1.124 request="GET /2008/ HTTP/1.1" status_code=200 request_id=259d7cb2-d06c-4a84-8b68-49906431c4f4 remote_addr="10.1.31.190" forwarded_for="34.147.114.27, 172.69.55.28" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5244 referer="-" user_agent="newspaper/0.2.8" request_time="1.124" upstream_response_time="1.124" upstream_connect_time="0.000" upstream_header_time="1.124"; 1.124 GET /2008/ HTTP/1.1 200 259d7cb2-d06c-4a84-8b68-49906431c4f4 10.1.31.190 34.147.114.27, 172.69.55.28 http 1.1 vegur 5244 - newspaper/0.2.8 1.124 1.124 0.0 1.124
347 2021-08-05T19:16:19.689561+00:00 app[web.1]: measure#nginx.service=1.019 request="GET /search/?tag=async&tag=postgresql&month=3&year=2018 HTTP/1.1" status_code=200 request_id=5f87b1ea-8db1-4f9e-a36f-c8e8765d458c remote_addr="10.1.31.190" forwarded_for="158.69.243.99, 172.70.126.84" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6132 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="1.019" upstream_response_time="1.020" upstream_connect_time="0.000" upstream_header_time="1.020"; 1.019 GET /search/?tag=async&tag=postgresql&month=3&year=2018 HTTP/1.1 200 5f87b1ea-8db1-4f9e-a36f-c8e8765d458c 10.1.31.190 158.69.243.99, 172.70.126.84 http 1.1 vegur 6132 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 1.019 1.02 0.0 1.02
361 2021-08-05T19:16:32.780734+00:00 app[web.1]: measure#nginx.service=0.159 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=de22b2e2-da0d-4ba6-8d42-b0767d53d5b4 remote_addr="10.1.31.190" forwarded_for="98.37.79.147, 172.69.35.27" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:92.0) Gecko/20100101 Firefox/92.0" request_time="0.159" upstream_response_time="0.160" upstream_connect_time="0.000" upstream_header_time="0.156"; 0.159 GET /atom/everything/ HTTP/1.1 200 de22b2e2-da0d-4ba6-8d42-b0767d53d5b4 10.1.31.190 98.37.79.147, 172.69.35.27 http 1.1 vegur 155913 - Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:92.0) Gecko/20100101 Firefox/92.0 0.159 0.16 0.0 0.156
372 2021-08-05T19:16:48.914722+00:00 app[web.1]: measure#nginx.service=0.660 request="GET /search/?tag=zoos&type=blogmark&year=2008&page=1 HTTP/1.1" status_code=200 request_id=f0d70808-dea7-4cc0-ac3c-2fb678272440 remote_addr="10.1.31.190" forwarded_for="114.119.135.223, 172.70.142.75" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6950 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.660" upstream_response_time="0.660" upstream_connect_time="0.000" upstream_header_time="0.660"; 0.66 GET /search/?tag=zoos&type=blogmark&year=2008&page=1 HTTP/1.1 200 f0d70808-dea7-4cc0-ac3c-2fb678272440 10.1.31.190 114.119.135.223, 172.70.142.75 http 1.1 vegur 6950 - 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.66 0.66 0.0 0.66
386 2021-08-05T19:17:10.219860+00:00 app[web.1]: measure#nginx.service=0.732 request="GET /search/?tag=amazon&tag=erlang&tag=virtualisation&year=2007 HTTP/1.1" status_code=200 request_id=bd647005-8432-4025-8438-7e6f3f802b2c remote_addr="10.1.31.190" forwarded_for="167.114.100.201, 172.70.126.108" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6902 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.732" upstream_response_time="0.732" upstream_connect_time="0.000" upstream_header_time="0.732"; 0.732 GET /search/?tag=amazon&tag=erlang&tag=virtualisation&year=2007 HTTP/1.1 200 bd647005-8432-4025-8438-7e6f3f802b2c 10.1.31.190 167.114.100.201, 172.70.126.108 http 1.1 vegur 6902 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.732 0.732 0.0 0.732
446 2021-08-05T19:18:49.928756+00:00 app[web.1]: measure#nginx.service=20.823 request="GET /search/?tag=firefox&tag=html5&tag=crossdomain&tag=textshadow&tag=tracemonkey&tag=performance&tag=webworkers&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=81c2030a-b575-4a86-a6b6-04b0177013c9 remote_addr="10.1.31.190" forwarded_for="54.161.41.102, 172.70.35.14" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13138 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="20.823" upstream_response_time="20.824" upstream_connect_time="0.000" upstream_header_time="20.824"; 20.823 GET /search/?tag=firefox&tag=html5&tag=crossdomain&tag=textshadow&tag=tracemonkey&tag=performance&tag=webworkers&type=blogmark&year=2009 HTTP/1.1 200 81c2030a-b575-4a86-a6b6-04b0177013c9 10.1.31.190 54.161.41.102, 172.70.35.14 http 1.1 vegur 13138 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 20.823 20.824 0.0 20.824
483 2021-08-05T19:19:46.073695+00:00 app[web.1]: measure#nginx.service=12.649 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=6ae7aa64-25a6-4905-ab1b-aaa791e35130 remote_addr="10.1.31.190" forwarded_for="81.170.160.113, 162.158.183.234" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="NetNewsWire (RSS Reader; https://netnewswire.com/)" request_time="12.649" upstream_response_time="12.648" upstream_connect_time="0.000" upstream_header_time="12.644"; 12.649 GET /atom/everything/ HTTP/1.1 200 6ae7aa64-25a6-4905-ab1b-aaa791e35130 10.1.31.190 81.170.160.113, 162.158.183.234 http 1.1 vegur 155913 - NetNewsWire (RSS Reader; https://netnewswire.com/) 12.649 12.648 0.0 12.644
484 2021-08-05T19:19:46.277358+00:00 app[web.1]: measure#nginx.service=14.477 request="GET /search/?tag=async&tag=promise&tag=nodejs HTTP/1.1" status_code=200 request_id=7920cf74-7f1e-4327-9a31-5c9e43494063 remote_addr="10.1.31.190" forwarded_for="158.69.243.99, 172.70.126.166" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6082 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="14.477" upstream_response_time="14.476" upstream_connect_time="0.000" upstream_header_time="14.476"; 14.477 GET /search/?tag=async&tag=promise&tag=nodejs HTTP/1.1 200 7920cf74-7f1e-4327-9a31-5c9e43494063 10.1.31.190 158.69.243.99, 172.70.126.166 http 1.1 vegur 6082 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 14.477 14.476 0.0 14.476

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