27 rows where remote_addr = "10.1.12.255" sorted by request_time descending

View and edit SQL

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

status_code

remote_addr

  • 10.1.12.255 · 27
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
440 2021-08-05T19:18:43.630715+00:00 app[web.1]: measure#nginx.service=17.009 request="GET /search/?tag=amazon&year=2009&month=5 HTTP/1.1" status_code=200 request_id=cea48a58-024f-4dc8-a797-c0fd71624d11 remote_addr="10.1.12.255" forwarded_for="114.119.137.232, 162.158.165.22" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8573 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="17.009" upstream_response_time="17.008" upstream_connect_time="0.000" upstream_header_time="17.008"; 17.009 GET /search/?tag=amazon&year=2009&month=5 HTTP/1.1 200 cea48a58-024f-4dc8-a797-c0fd71624d11 10.1.12.255 114.119.137.232, 162.158.165.22 http 1.1 vegur 8573 - 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) 17.009 17.008 0.0 17.008
470 2021-08-05T19:19:20.569539+00:00 app[web.1]: measure#nginx.service=15.836 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=c11a66eb-624b-4555-8b13-19afc5f7afc1 remote_addr="10.1.12.255" forwarded_for="104.244.193.6, 172.70.130.249" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Tiny Tiny RSS/DragonFly:g20210123:6c546f37b (Unsupported) (http://tt-rss.org/)" request_time="15.836" upstream_response_time="15.836" upstream_connect_time="0.000" upstream_header_time="15.832"; 15.836 GET /atom/everything/ HTTP/1.1 200 c11a66eb-624b-4555-8b13-19afc5f7afc1 10.1.12.255 104.244.193.6, 172.70.130.249 http 1.1 vegur 155913 - Tiny Tiny RSS/DragonFly:g20210123:6c546f37b (Unsupported) (http://tt-rss.org/) 15.836 15.836 0.0 15.832
444 2021-08-05T19:18:44.529329+00:00 app[web.1]: measure#nginx.service=14.894 request="GET /favicon.ico HTTP/1.1" status_code=200 request_id=581f3ca8-90b9-4290-9ee9-256df22d70a6 remote_addr="10.1.12.255" forwarded_for="46.183.103.17,66.249.93.2, 108.162.229.233" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=318 referer="-" user_agent="Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 Google Favicon" request_time="14.894" upstream_response_time="14.892" upstream_connect_time="0.000" upstream_header_time="14.892"; 14.894 GET /favicon.ico HTTP/1.1 200 581f3ca8-90b9-4290-9ee9-256df22d70a6 10.1.12.255 46.183.103.17,66.249.93.2, 108.162.229.233 http 1.1 vegur 318 - Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.75 Safari/537.36 Google Favicon 14.894 14.892 0.0 14.892
447 2021-08-05T19:18:50.027765+00:00 app[web.1]: measure#nginx.service=12.045 request="GET /search/?tag=flickr&page=2&type=entry HTTP/1.1" status_code=404 request_id=98778c98-6e2e-4f6f-83fd-8f63007304e7 remote_addr="10.1.12.255" forwarded_for="114.119.147.73, 172.70.143.17" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=179 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="12.045" upstream_response_time="12.048" upstream_connect_time="0.000" upstream_header_time="12.048"; 12.045 GET /search/?tag=flickr&page=2&type=entry HTTP/1.1 404 98778c98-6e2e-4f6f-83fd-8f63007304e7 10.1.12.255 114.119.147.73, 172.70.143.17 http 1.1 vegur 179 - 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) 12.045 12.048 0.0 12.048
164 2021-08-05T19:12:53.053002+00:00 app[web.1]: measure#nginx.service=6.793 request="GET /search/?tag=video&tag=firefox&tag=crossdomain&tag=browsers&tag=performance&tag=javascript HTTP/1.1" status_code=200 request_id=c1b48b45-dd6b-42d3-ae2a-4dec07fd4191 remote_addr="10.1.12.255" forwarded_for="54.161.41.102, 172.70.34.55" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10246 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="6.793" upstream_response_time="6.792" upstream_connect_time="0.000" upstream_header_time="6.792"; 6.793 GET /search/?tag=video&tag=firefox&tag=crossdomain&tag=browsers&tag=performance&tag=javascript HTTP/1.1 200 c1b48b45-dd6b-42d3-ae2a-4dec07fd4191 10.1.12.255 54.161.41.102, 172.70.34.55 http 1.1 vegur 10246 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 6.793 6.792 0.0 6.792
262 2021-08-05T19:15:15.450660+00:00 app[web.1]: measure#nginx.service=5.159 request="GET /search/?tag=json&tag=video&tag=dragndrop&tag=tracemonkey&tag=canvas&tag=webworkers&tag=firefox&tag=mozilla&tag=textshadow&type=blogmark&month=6&year=2009 HTTP/1.1" status_code=200 request_id=d4ee2536-1069-4539-83c6-78a04e0ad374 remote_addr="10.1.12.255" forwarded_for="54.161.41.102, 172.70.34.105" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=15425 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="5.159" upstream_response_time="5.156" upstream_connect_time="0.000" upstream_header_time="5.156"; 5.159 GET /search/?tag=json&tag=video&tag=dragndrop&tag=tracemonkey&tag=canvas&tag=webworkers&tag=firefox&tag=mozilla&tag=textshadow&type=blogmark&month=6&year=2009 HTTP/1.1 200 d4ee2536-1069-4539-83c6-78a04e0ad374 10.1.12.255 54.161.41.102, 172.70.34.105 http 1.1 vegur 15425 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 5.159 5.156 0.0 5.156
373 2021-08-05T19:16:49.060712+00:00 app[web.1]: measure#nginx.service=4.678 request="GET /search/?tag=fonts&tag=dragndrop&tag=crossdomain&tag=performance&tag=browsers&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=5f67e715-0b1d-40da-8414-140d78c5424b remote_addr="10.1.12.255" forwarded_for="54.161.41.102, 172.70.34.249" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11254 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.678" upstream_response_time="4.680" upstream_connect_time="0.000" upstream_header_time="4.680"; 4.678 GET /search/?tag=fonts&tag=dragndrop&tag=crossdomain&tag=performance&tag=browsers&type=blogmark&year=2009 HTTP/1.1 200 5f67e715-0b1d-40da-8414-140d78c5424b 10.1.12.255 54.161.41.102, 172.70.34.249 http 1.1 vegur 11254 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.678 4.68 0.0 4.68
425 2021-08-05T19:18:11.711215+00:00 app[web.1]: measure#nginx.service=4.430 request="GET /favicon.ico HTTP/1.1" status_code=200 request_id=cf2e3b51-48a7-49e1-a894-6a2daad9fa09 remote_addr="10.1.12.255" forwarded_for="74.102.98.235, 172.70.110.129" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=318 referer="-" user_agent="com.slack.slackmdm/21.07.20 (iPhone; iOS 14.7.1; Scale/3.00)" request_time="4.430" upstream_response_time="4.428" upstream_connect_time="0.000" upstream_header_time="4.428"; 4.43 GET /favicon.ico HTTP/1.1 200 cf2e3b51-48a7-49e1-a894-6a2daad9fa09 10.1.12.255 74.102.98.235, 172.70.110.129 http 1.1 vegur 318 - com.slack.slackmdm/21.07.20 (iPhone; iOS 14.7.1; Scale/3.00) 4.43 4.428 0.0 4.428
47 2021-08-05T19:10:03.388811+00:00 app[web.1]: measure#nginx.service=4.245 request="GET /search/?tag=html5&tag=canvas&tag=tracemonkey&tag=dragndrop&tag=offlineresources&tag=geolocation&tag=webworkers&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=1c60f588-9c28-4331-8c53-201db34f282a remote_addr="10.1.12.255" forwarded_for="54.161.41.102, 172.70.34.127" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12991 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.245" upstream_response_time="4.244" upstream_connect_time="0.000" upstream_header_time="4.244"; 4.245 GET /search/?tag=html5&tag=canvas&tag=tracemonkey&tag=dragndrop&tag=offlineresources&tag=geolocation&tag=webworkers&type=blogmark&month=6 HTTP/1.1 200 1c60f588-9c28-4331-8c53-201db34f282a 10.1.12.255 54.161.41.102, 172.70.34.127 http 1.1 vegur 12991 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.245 4.244 0.0 4.244
49 2021-08-05T19:10:03.675325+00:00 app[web.1]: measure#nginx.service=3.850 request="GET /search/?tag=conferences&month=2&year=2013 HTTP/1.1" status_code=200 request_id=3a467373-f000-4b25-b0a5-c75d99785b5a remote_addr="10.1.12.255" forwarded_for="114.119.134.41, 172.70.143.11" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11427 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.850" upstream_response_time="3.848" upstream_connect_time="0.000" upstream_header_time="3.848"; 3.85 GET /search/?tag=conferences&month=2&year=2013 HTTP/1.1 200 3a467373-f000-4b25-b0a5-c75d99785b5a 10.1.12.255 114.119.134.41, 172.70.143.11 http 1.1 vegur 11427 - 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.85 3.848 0.0 3.848
437 2021-08-05T19:18:24.052369+00:00 app[web.1]: measure#nginx.service=3.535 request="GET /search/?tag=html5&tag=csstransforms&tag=browsers&tag=localstorage&tag=tracemonkey&tag=audio&tag=offlineresources&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=bf92ccb6-38d7-4d6b-9023-a4d87228956f remote_addr="10.1.12.255" forwarded_for="54.161.41.102, 172.70.35.54" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13061 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.535" upstream_response_time="3.536" upstream_connect_time="0.000" upstream_header_time="3.536"; 3.535 GET /search/?tag=html5&tag=csstransforms&tag=browsers&tag=localstorage&tag=tracemonkey&tag=audio&tag=offlineresources&type=blogmark&month=6 HTTP/1.1 200 bf92ccb6-38d7-4d6b-9023-a4d87228956f 10.1.12.255 54.161.41.102, 172.70.35.54 http 1.1 vegur 13061 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.535 3.536 0.0 3.536
380 2021-08-05T19:17:05.814708+00:00 app[web.1]: measure#nginx.service=3.134 request="GET /search/?tag=async&tag=promise&tag=dojo HTTP/1.1" status_code=200 request_id=24695f47-3e19-4ac2-a15a-f6147bec4452 remote_addr="10.1.12.255" forwarded_for="158.69.243.99, 172.70.126.220" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6052 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="3.134" upstream_response_time="3.132" upstream_connect_time="0.000" upstream_header_time="3.132"; 3.134 GET /search/?tag=async&tag=promise&tag=dojo HTTP/1.1 200 24695f47-3e19-4ac2-a15a-f6147bec4452 10.1.12.255 158.69.243.99, 172.70.126.220 http 1.1 vegur 6052 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 3.134 3.132 0.0 3.132
9 2021-08-05T19:09:02.322673+00:00 app[web.1]: measure#nginx.service=3.104 request="GET /search/?tag=amazon&tag=erlang&tag=schemaless&year=2007 HTTP/1.1" status_code=200 request_id=0168f864-24cf-49de-9f8d-0f29663f3ec1 remote_addr="10.1.12.255" forwarded_for="167.114.100.201, 172.70.126.2" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6825 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="3.104" upstream_response_time="3.104" upstream_connect_time="0.000" upstream_header_time="3.104"; 3.104 GET /search/?tag=amazon&tag=erlang&tag=schemaless&year=2007 HTTP/1.1 200 0168f864-24cf-49de-9f8d-0f29663f3ec1 10.1.12.255 167.114.100.201, 172.70.126.2 http 1.1 vegur 6825 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 3.104 3.104 0.0 3.104
273 2021-08-05T19:15:23.495495+00:00 app[web.1]: measure#nginx.service=2.106 request="GET /search/?tag=geolocation&tag=audio&tag=textshadow&tag=json&tag=canvas&tag=performance&tag=dragndrop&type=blogmark HTTP/1.1" status_code=200 request_id=57a19bff-495f-4dcc-ae63-f63492e714fb remote_addr="10.1.12.255" forwarded_for="54.161.41.102, 172.70.34.3" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11755 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.106" upstream_response_time="2.108" upstream_connect_time="0.000" upstream_header_time="2.108"; 2.106 GET /search/?tag=geolocation&tag=audio&tag=textshadow&tag=json&tag=canvas&tag=performance&tag=dragndrop&type=blogmark HTTP/1.1 200 57a19bff-495f-4dcc-ae63-f63492e714fb 10.1.12.255 54.161.41.102, 172.70.34.3 http 1.1 vegur 11755 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 2.106 2.108 0.0 2.108
169 2021-08-05T19:12:59.585052+00:00 app[web.1]: measure#nginx.service=1.739 request="GET /search/?tag=fonts&tag=firefox35&tag=tracemonkey&tag=performance&tag=json&tag=javascript&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=1aa76ffc-183c-40e5-945e-f4d74d4b6afa remote_addr="10.1.12.255" forwarded_for="54.161.41.102, 172.70.35.88" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12019 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.739" upstream_response_time="1.740" upstream_connect_time="0.000" upstream_header_time="1.740"; 1.739 GET /search/?tag=fonts&tag=firefox35&tag=tracemonkey&tag=performance&tag=json&tag=javascript&year=2009&type=blogmark HTTP/1.1 200 1aa76ffc-183c-40e5-945e-f4d74d4b6afa 10.1.12.255 54.161.41.102, 172.70.35.88 http 1.1 vegur 12019 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.739 1.74 0.0 1.74
292 2021-08-05T19:15:48.367985+00:00 app[web.1]: measure#nginx.service=1.212 request="GET /search/?tag=json&tag=canvas&tag=javascript&tag=html5&tag=localstorage&tag=webworkers&type=blogmark HTTP/1.1" status_code=200 request_id=54032ba3-840c-42e4-a20d-babd8b327867 remote_addr="10.1.12.255" forwarded_for="54.161.41.102, 172.70.35.24" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10905 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.212" upstream_response_time="1.212" upstream_connect_time="0.000" upstream_header_time="1.212"; 1.212 GET /search/?tag=json&tag=canvas&tag=javascript&tag=html5&tag=localstorage&tag=webworkers&type=blogmark HTTP/1.1 200 54032ba3-840c-42e4-a20d-babd8b327867 10.1.12.255 54.161.41.102, 172.70.35.24 http 1.1 vegur 10905 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.212 1.212 0.0 1.212
323 2021-08-05T19:15:55.503328+00:00 app[web.1]: measure#nginx.service=1.065 request="GET /2019/ HTTP/1.1" status_code=200 request_id=0d9251fd-926d-4da7-a089-30fd9384ad1d remote_addr="10.1.12.255" forwarded_for="34.147.114.27, 141.101.76.5" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7664 referer="-" user_agent="newspaper/0.2.8" request_time="1.065" upstream_response_time="1.064" upstream_connect_time="0.000" upstream_header_time="1.064"; 1.065 GET /2019/ HTTP/1.1 200 0d9251fd-926d-4da7-a089-30fd9384ad1d 10.1.12.255 34.147.114.27, 141.101.76.5 http 1.1 vegur 7664 - newspaper/0.2.8 1.065 1.064 0.0 1.064
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
211 2021-08-05T19:14:02.840918+00:00 app[web.1]: measure#nginx.service=0.312 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=47b310c3-f10f-4bb3-97f8-537e80a96006 remote_addr="10.1.12.255" 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.312" upstream_response_time="0.312" upstream_connect_time="0.000" upstream_header_time="0.308"; 0.312 GET /atom/everything/ HTTP/1.1 200 47b310c3-f10f-4bb3-97f8-537e80a96006 10.1.12.255 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.312 0.312 0.0 0.308
192 2021-08-05T19:13:36.051456+00:00 app[web.1]: measure#nginx.service=0.238 request="GET /search/?month=10&tag=twitter&year=2007 HTTP/1.1" status_code=200 request_id=905b4475-8f0e-4e38-a152-102ca9634297 remote_addr="10.1.12.255" forwarded_for="114.119.137.8, 172.70.142.162" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7038 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.238" upstream_response_time="0.240" upstream_connect_time="0.000" upstream_header_time="0.240"; 0.238 GET /search/?month=10&tag=twitter&year=2007 HTTP/1.1 200 905b4475-8f0e-4e38-a152-102ca9634297 10.1.12.255 114.119.137.8, 172.70.142.162 http 1.1 vegur 7038 - 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.238 0.24 0.0 0.24
294 2021-08-05T19:15:50.308982+00:00 app[web.1]: measure#nginx.service=0.221 request="GET / HTTP/1.1" status_code=200 request_id=2c59e9f2-0659-487e-b7b5-9fb321e06c20 remote_addr="10.1.12.255" forwarded_for="34.147.114.27, 141.101.76.110" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=108589 referer="-" user_agent="newspaper/0.2.8" request_time="0.221" upstream_response_time="0.220" upstream_connect_time="0.000" upstream_header_time="0.220"; 0.221 GET / HTTP/1.1 200 2c59e9f2-0659-487e-b7b5-9fb321e06c20 10.1.12.255 34.147.114.27, 141.101.76.110 http 1.1 vegur 108589 - newspaper/0.2.8 0.221 0.22 0.0 0.22
72 2021-08-05T19:10:37.889885+00:00 app[web.1]: measure#nginx.service=0.208 request="GET /search/?type=entry&month=1&tag=identity HTTP/1.1" status_code=200 request_id=2673d6bf-a388-464d-b0a9-3c0fa9401115 remote_addr="10.1.12.255" forwarded_for="114.119.152.195, 172.70.142.54" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5827 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.208" upstream_response_time="0.208" upstream_connect_time="0.000" upstream_header_time="0.208"; 0.208 GET /search/?type=entry&month=1&tag=identity HTTP/1.1 200 2673d6bf-a388-464d-b0a9-3c0fa9401115 10.1.12.255 114.119.152.195, 172.70.142.54 http 1.1 vegur 5827 - 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.208 0.208 0.0 0.208
78 2021-08-05T19:10:42.028561+00:00 app[web.1]: measure#nginx.service=0.151 request="GET /2007/Aug/15/jquery/ HTTP/1.1" status_code=200 request_id=60858f4f-477a-436e-bb7d-2b973098e96b remote_addr="10.1.12.255" forwarded_for="49.12.12.219, 162.158.91.83" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=24248 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="0.151" upstream_response_time="0.152" upstream_connect_time="0.000" upstream_header_time="0.152"; 0.151 GET /2007/Aug/15/jquery/ HTTP/1.1 200 60858f4f-477a-436e-bb7d-2b973098e96b 10.1.12.255 49.12.12.219, 162.158.91.83 http 1.1 vegur 24248 - 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 0.151 0.152 0.0 0.152
374 2021-08-05T19:16:53.269300+00:00 app[web.1]: measure#nginx.service=0.133 request="GET /search/?tag=svnpubsub&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=6bc604d2-2c83-4fa5-baab-e0aa9dd75256 remote_addr="10.1.12.255" forwarded_for="114.119.129.57, 172.70.143.24" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5880 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.133" upstream_response_time="0.132" upstream_connect_time="0.000" upstream_header_time="0.132"; 0.133 GET /search/?tag=svnpubsub&type=blogmark&year=2009 HTTP/1.1 200 6bc604d2-2c83-4fa5-baab-e0aa9dd75256 10.1.12.255 114.119.129.57, 172.70.143.24 http 1.1 vegur 5880 - 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.133 0.132 0.0 0.132
67 2021-08-05T19:10:31.999210+00:00 app[web.1]: measure#nginx.service=0.124 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=633206fa-65ac-4091-937c-01f1cad74504 remote_addr="10.1.12.255" forwarded_for="2a01:e34:ec95:f440:44b3:beed:96e3:1fa6, 108.162.229.192" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="okhttp/4.9.1" request_time="0.124" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; 0.124 GET /atom/links/ HTTP/1.1 200 633206fa-65ac-4091-937c-01f1cad74504 10.1.12.255 2a01:e34:ec95:f440:44b3:beed:96e3:1fa6, 108.162.229.192 http 1.1 vegur 16609 - okhttp/4.9.1 0.124 0.12 0.0 0.12
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
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

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