30 rows where remote_addr = "10.1.58.55" sorted by request_time descending

View and edit SQL

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

remote_addr

  • 10.1.58.55 · 30

referer

  • - 30
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
463 2021-08-05T19:19:15.736672+00:00 app[web.1]: measure#nginx.service=16.704 request="GET /search/?q%3Dpostgresql&tag=dinoviehland&year=2008&type=blogmark HTTP/1.1" status_code=200 request_id=e79c547e-a639-463e-ad4a-5aa2c21ecfbf remote_addr="10.1.58.55" forwarded_for="114.119.134.220, 172.70.143.25" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7265 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="16.704" upstream_response_time="16.704" upstream_connect_time="0.000" upstream_header_time="16.704"; 16.704 GET /search/?q%3Dpostgresql&tag=dinoviehland&year=2008&type=blogmark HTTP/1.1 200 e79c547e-a639-463e-ad4a-5aa2c21ecfbf 10.1.58.55 114.119.134.220, 172.70.143.25 http 1.1 vegur 7265 - 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) 16.704 16.704 0.0 16.704
238 2021-08-05T19:14:40.831415+00:00 app[web.1]: measure#nginx.service=12.371 request="GET /search/?tag=fonts&tag=offlineresources&tag=performance&tag=textshadow&tag=mozilla&tag=dragndrop&tag=browsers&tag=csstransforms&tag=firefox&tag=crossdomain&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=49e67f0d-0c2a-4a38-971b-0f742316e1d5 remote_addr="10.1.58.55" forwarded_for="54.161.41.102, 172.70.34.171" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16276 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="12.371" upstream_response_time="12.368" upstream_connect_time="0.000" upstream_header_time="12.368"; 12.371 GET /search/?tag=fonts&tag=offlineresources&tag=performance&tag=textshadow&tag=mozilla&tag=dragndrop&tag=browsers&tag=csstransforms&tag=firefox&tag=crossdomain&type=blogmark&year=2009 HTTP/1.1 200 49e67f0d-0c2a-4a38-971b-0f742316e1d5 10.1.58.55 54.161.41.102, 172.70.34.171 http 1.1 vegur 16276 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 12.371 12.368 0.0 12.368
228 2021-08-05T19:14:24.876531+00:00 app[web.1]: measure#nginx.service=9.806 request="GET /search/?tag=browsers&tag=firefox&tag=javascript&tag=geolocation&tag=video&tag=json&tag=html5&tag=webworkers&tag=canvas&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=4900c85f-7ed2-41af-a4bc-dbd73b967950 remote_addr="10.1.58.55" forwarded_for="54.161.41.102, 172.70.35.74" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14143 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="9.806" upstream_response_time="9.808" upstream_connect_time="0.000" upstream_header_time="9.808"; 9.806 GET /search/?tag=browsers&tag=firefox&tag=javascript&tag=geolocation&tag=video&tag=json&tag=html5&tag=webworkers&tag=canvas&type=blogmark&month=6 HTTP/1.1 200 4900c85f-7ed2-41af-a4bc-dbd73b967950 10.1.58.55 54.161.41.102, 172.70.35.74 http 1.1 vegur 14143 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 9.806 9.808 0.0 9.808
474 2021-08-05T19:19:23.013202+00:00 app[web.1]: measure#nginx.service=9.448 request="GET /search/?year=2018&type=blogmark&tag=json HTTP/1.1" status_code=200 request_id=f9150c2d-484b-4efa-8afb-9204cd7a80a5 remote_addr="10.1.58.55" forwarded_for="114.119.150.168, 172.68.144.62" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11057 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="9.448" upstream_response_time="9.448" upstream_connect_time="0.000" upstream_header_time="9.448"; 9.448 GET /search/?year=2018&type=blogmark&tag=json HTTP/1.1 200 f9150c2d-484b-4efa-8afb-9204cd7a80a5 10.1.58.55 114.119.150.168, 172.68.144.62 http 1.1 vegur 11057 - 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) 9.448 9.448 0.0 9.448
326 2021-08-05T19:16:03.767520+00:00 app[web.1]: measure#nginx.service=8.554 request="GET /search/?tag=video&tag=firefox&tag=localstorage&tag=geolocation&tag=html5&tag=crossdomain HTTP/1.1" status_code=200 request_id=574bcb07-bdc8-49ed-897f-dbba75f15628 remote_addr="10.1.58.55" forwarded_for="54.161.41.102, 172.70.35.12" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10214 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="8.554" upstream_response_time="8.556" upstream_connect_time="0.000" upstream_header_time="8.556"; 8.554 GET /search/?tag=video&tag=firefox&tag=localstorage&tag=geolocation&tag=html5&tag=crossdomain HTTP/1.1 200 574bcb07-bdc8-49ed-897f-dbba75f15628 10.1.58.55 54.161.41.102, 172.70.35.12 http 1.1 vegur 10214 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 8.554 8.556 0.0 8.556
327 2021-08-05T19:16:03.947573+00:00 app[web.1]: measure#nginx.service=8.462 request="GET /search/?q=django&tag=opensource&month=7 HTTP/1.1" status_code=200 request_id=01b0fd14-a460-4db5-a797-7dc0b19452ca remote_addr="10.1.58.55" forwarded_for="114.119.141.71, 172.70.142.81" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=9823 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="8.462" upstream_response_time="8.464" upstream_connect_time="0.000" upstream_header_time="8.464"; 8.462 GET /search/?q=django&tag=opensource&month=7 HTTP/1.1 200 01b0fd14-a460-4db5-a797-7dc0b19452ca 10.1.58.55 114.119.141.71, 172.70.142.81 http 1.1 vegur 9823 - 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) 8.462 8.464 0.0 8.464
394 2021-08-05T19:17:27.373309+00:00 app[web.1]: measure#nginx.service=4.823 request="GET /search/?tag=javascript&tag=browsers&tag=mozilla&tag=webworkers&tag=html5&tag=csstransforms&tag=firefox&tag=canvas&tag=audio&type=blogmark HTTP/1.1" status_code=200 request_id=a4a3fa94-fa13-4bc7-8b78-1ff6da641a57 remote_addr="10.1.58.55" forwarded_for="54.161.41.102, 172.70.34.81" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13455 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.823" upstream_response_time="4.824" upstream_connect_time="0.000" upstream_header_time="4.824"; 4.823 GET /search/?tag=javascript&tag=browsers&tag=mozilla&tag=webworkers&tag=html5&tag=csstransforms&tag=firefox&tag=canvas&tag=audio&type=blogmark HTTP/1.1 200 a4a3fa94-fa13-4bc7-8b78-1ff6da641a57 10.1.58.55 54.161.41.102, 172.70.34.81 http 1.1 vegur 13455 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.823 4.824 0.0 4.824
131 2021-08-05T19:12:01.118789+00:00 app[web.1]: measure#nginx.service=4.425 request="GET /search/?tag=mozilla&tag=textshadow&tag=json&tag=browsers&tag=dragndrop&tag=tracemonkey&tag=csstransforms&tag=performance&year=2009&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=cd620ff2-d3f8-4383-9d1e-87a4ccce769e remote_addr="10.1.58.55" forwarded_for="54.161.41.102, 172.70.34.107" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14922 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="4.425" upstream_response_time="4.424" upstream_connect_time="0.000" upstream_header_time="4.424"; 4.425 GET /search/?tag=mozilla&tag=textshadow&tag=json&tag=browsers&tag=dragndrop&tag=tracemonkey&tag=csstransforms&tag=performance&year=2009&type=blogmark&month=6 HTTP/1.1 200 cd620ff2-d3f8-4383-9d1e-87a4ccce769e 10.1.58.55 54.161.41.102, 172.70.34.107 http 1.1 vegur 14922 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 4.425 4.424 0.0 4.424
134 2021-08-05T19:12:07.324230+00:00 app[web.1]: measure#nginx.service=4.266 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=webservices HTTP/1.1" status_code=200 request_id=f0ba19e0-6835-46a5-8ced-086ef5424162 remote_addr="10.1.58.55" forwarded_for="167.114.100.201, 172.70.126.32" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6667 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="4.266" upstream_response_time="4.268" upstream_connect_time="0.000" upstream_header_time="4.268"; 4.266 GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=webservices HTTP/1.1 200 f0ba19e0-6835-46a5-8ced-086ef5424162 10.1.58.55 167.114.100.201, 172.70.126.32 http 1.1 vegur 6667 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 4.266 4.268 0.0 4.268
162 2021-08-05T19:12:51.858686+00:00 app[web.1]: measure#nginx.service=3.829 request="GET /2008/May/28/geobloggers/ HTTP/1.1" status_code=200 request_id=6735bc97-e91d-4ded-bb8d-29994517dcd5 remote_addr="10.1.58.55" forwarded_for="54.36.148.6, 141.101.77.138" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=4537 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="3.829" upstream_response_time="3.828" upstream_connect_time="0.000" upstream_header_time="3.828"; 3.829 GET /2008/May/28/geobloggers/ HTTP/1.1 200 6735bc97-e91d-4ded-bb8d-29994517dcd5 10.1.58.55 54.36.148.6, 141.101.77.138 http 1.1 vegur 4537 - Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) 3.829 3.828 0.0 3.828
235 2021-08-05T19:14:37.221339+00:00 app[web.1]: measure#nginx.service=3.765 request="GET /search/?tag=audio&tag=localstorage&tag=json&tag=video&tag=offlineresources HTTP/1.1" status_code=200 request_id=f79eecb7-8300-4bdf-9145-93ab7273ec7e remote_addr="10.1.58.55" forwarded_for="54.161.41.102, 172.70.34.249" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=9432 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.765" upstream_response_time="3.764" upstream_connect_time="0.000" upstream_header_time="3.764"; 3.765 GET /search/?tag=audio&tag=localstorage&tag=json&tag=video&tag=offlineresources HTTP/1.1 200 f79eecb7-8300-4bdf-9145-93ab7273ec7e 10.1.58.55 54.161.41.102, 172.70.34.249 http 1.1 vegur 9432 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.765 3.764 0.0 3.764
391 2021-08-05T19:17:18.751285+00:00 app[web.1]: measure#nginx.service=3.056 request="GET /search/?tag=dragndrop&tag=html5&tag=csstransforms&tag=javascript&tag=canvas&tag=audio&tag=fonts&tag=crossdomain&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=404244d7-78bc-44fa-9d3a-ad71f0726f95 remote_addr="10.1.58.55" forwarded_for="54.161.41.102, 172.70.35.48" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13713 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="3.056" upstream_response_time="3.052" upstream_connect_time="0.000" upstream_header_time="3.052"; 3.056 GET /search/?tag=dragndrop&tag=html5&tag=csstransforms&tag=javascript&tag=canvas&tag=audio&tag=fonts&tag=crossdomain&year=2009&type=blogmark HTTP/1.1 200 404244d7-78bc-44fa-9d3a-ad71f0726f95 10.1.58.55 54.161.41.102, 172.70.35.48 http 1.1 vegur 13713 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3.056 3.052 0.0 3.052
3 2021-08-05T19:08:51.986277+00:00 app[web.1]: measure#nginx.service=2.385 request="GET /search/?tag=async&tag=node&tag=recovered&tag=jameshalliday HTTP/1.1" status_code=200 request_id=a7f9564a-3206-4f1a-b0d3-a1e9c49b1e54 remote_addr="10.1.58.55" forwarded_for="158.69.243.99, 172.70.126.14" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6732 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.385" upstream_response_time="2.384" upstream_connect_time="0.000" upstream_header_time="2.384"; 2.385 GET /search/?tag=async&tag=node&tag=recovered&tag=jameshalliday HTTP/1.1 200 a7f9564a-3206-4f1a-b0d3-a1e9c49b1e54 10.1.58.55 158.69.243.99, 172.70.126.14 http 1.1 vegur 6732 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.385 2.384 0.0 2.384
382 2021-08-05T19:17:06.207573+00:00 app[web.1]: measure#nginx.service=1.661 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=db8baa13-d5cc-4823-b528-6b5071e1943a remote_addr="10.1.58.55" 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="1.661" upstream_response_time="1.664" upstream_connect_time="0.000" upstream_header_time="1.656"; 1.661 GET /atom/everything/ HTTP/1.1 200 db8baa13-d5cc-4823-b528-6b5071e1943a 10.1.58.55 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 1.661 1.664 0.0 1.656
63 2021-08-05T19:10:20.879872+00:00 app[web.1]: measure#nginx.service=1.000 request="GET /search/?tag=mozilla&tag=dragndrop&tag=audio&tag=fonts&tag=textshadow&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=72385059-2b8c-47b2-816a-493b5326df4e remote_addr="10.1.58.55" forwarded_for="54.161.41.102, 172.70.34.111" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=10982 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.000" upstream_response_time="1.000" upstream_connect_time="0.000" upstream_header_time="1.000"; 1.0 GET /search/?tag=mozilla&tag=dragndrop&tag=audio&tag=fonts&tag=textshadow&type=blogmark&year=2009 HTTP/1.1 200 72385059-2b8c-47b2-816a-493b5326df4e 10.1.58.55 54.161.41.102, 172.70.34.111 http 1.1 vegur 10982 - Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 1.0 1.0 0.0 1.0
322 2021-08-05T19:15:55.126491+00:00 app[web.1]: measure#nginx.service=0.752 request="GET /2011/ HTTP/1.1" status_code=200 request_id=e75d3d2d-6d26-419f-a95a-1f155d055b8e remote_addr="10.1.58.55" forwarded_for="34.147.114.27, 141.101.76.237" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=23150 referer="-" user_agent="newspaper/0.2.8" request_time="0.752" upstream_response_time="0.752" upstream_connect_time="0.000" upstream_header_time="0.752"; 0.752 GET /2011/ HTTP/1.1 200 e75d3d2d-6d26-419f-a95a-1f155d055b8e 10.1.58.55 34.147.114.27, 141.101.76.237 http 1.1 vegur 23150 - newspaper/0.2.8 0.752 0.752 0.0 0.752
257 2021-08-05T19:15:08.986165+00:00 app[web.1]: measure#nginx.service=0.724 request="GET /tags/yagni/ HTTP/1.1" status_code=200 request_id=020237d6-3002-4e6a-94eb-da9b35d55539 remote_addr="10.1.58.55" forwarded_for="66.249.73.58, 108.162.221.201" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7631 referer="-" user_agent="Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" request_time="0.724" upstream_response_time="0.724" upstream_connect_time="0.000" upstream_header_time="0.724"; 0.724 GET /tags/yagni/ HTTP/1.1 200 020237d6-3002-4e6a-94eb-da9b35d55539 10.1.58.55 66.249.73.58, 108.162.221.201 http 1.1 vegur 7631 - Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) 0.724 0.724 0.0 0.724
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
17 2021-08-05T19:09:08.408724+00:00 app[web.1]: measure#nginx.service=0.656 request="GET /search/?tag=java&tag=jython&tag=jvm HTTP/1.1" status_code=200 request_id=99f3c17e-8e09-466e-a87d-d0915eb046ae remote_addr="10.1.58.55" forwarded_for="157.55.39.163, 108.162.246.159" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5350 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.656" upstream_response_time="0.656" upstream_connect_time="0.000" upstream_header_time="0.656"; 0.656 GET /search/?tag=java&tag=jython&tag=jvm HTTP/1.1 200 99f3c17e-8e09-466e-a87d-d0915eb046ae 10.1.58.55 157.55.39.163, 108.162.246.159 http 1.1 vegur 5350 - Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 0.656 0.656 0.0 0.656
159 2021-08-05T19:12:45.209034+00:00 app[web.1]: measure#nginx.service=0.331 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&type=blogmark HTTP/1.1" status_code=200 request_id=960bf705-1853-4f35-95b3-9ac8626fc552 remote_addr="10.1.58.55" forwarded_for="167.114.100.201, 172.70.126.32" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6636 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.331" upstream_response_time="0.332" upstream_connect_time="0.000" upstream_header_time="0.332"; 0.331 GET /search/?tag=amazon&tag=erlang&tag=simpledb&type=blogmark HTTP/1.1 200 960bf705-1853-4f35-95b3-9ac8626fc552 10.1.58.55 167.114.100.201, 172.70.126.32 http 1.1 vegur 6636 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.331 0.332 0.0 0.332
284 2021-08-05T19:15:39.024573+00:00 app[web.1]: measure#nginx.service=0.220 request="GET /search/?q=javascript&year=2007&tag=jquery&month=4 HTTP/1.1" status_code=200 request_id=63251f73-aa2b-42a1-9a30-7d2713eddb99 remote_addr="10.1.58.55" forwarded_for="114.119.140.219, 172.70.143.84" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7916 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.220" upstream_response_time="0.220" upstream_connect_time="0.000" upstream_header_time="0.220"; 0.22 GET /search/?q=javascript&year=2007&tag=jquery&month=4 HTTP/1.1 200 63251f73-aa2b-42a1-9a30-7d2713eddb99 10.1.58.55 114.119.140.219, 172.70.143.84 http 1.1 vegur 7916 - 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.22 0.22 0.0 0.22
210 2021-08-05T19:14:01.204540+00:00 app[web.1]: measure#nginx.service=0.195 request="GET /2003/Jan/27/ HTTP/1.1" status_code=200 request_id=8e7a069c-85e3-4478-a84d-866e95468be5 remote_addr="10.1.58.55" forwarded_for="54.36.148.175, 141.101.77.62" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11278 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="0.195" upstream_response_time="0.196" upstream_connect_time="0.000" upstream_header_time="0.196"; 0.195 GET /2003/Jan/27/ HTTP/1.1 200 8e7a069c-85e3-4478-a84d-866e95468be5 10.1.58.55 54.36.148.175, 141.101.77.62 http 1.1 vegur 11278 - Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) 0.195 0.196 0.0 0.196
359 2021-08-05T19:16:31.735567+00:00 app[web.1]: measure#nginx.service=0.170 request="GET /search/?page=1&tag=forms&year=2009 HTTP/1.1" status_code=200 request_id=7d59472d-8546-4e96-afe5-41b4052a20ce remote_addr="10.1.58.55" forwarded_for="114.119.157.236, 172.70.142.193" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5795 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.170" upstream_response_time="0.172" upstream_connect_time="0.000" upstream_header_time="0.172"; 0.17 GET /search/?page=1&tag=forms&year=2009 HTTP/1.1 200 7d59472d-8546-4e96-afe5-41b4052a20ce 10.1.58.55 114.119.157.236, 172.70.142.193 http 1.1 vegur 5795 - 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.17 0.172 0.0 0.172
258 2021-08-05T19:15:09.534586+00:00 app[web.1]: measure#nginx.service=0.169 request="GET /2009/Jun/20/despair/ HTTP/1.1" status_code=200 request_id=6320a32c-8497-4c5f-910f-9d042d9b92bd remote_addr="10.1.58.55" forwarded_for="54.36.148.8, 172.69.54.40" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=4470 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="0.169" upstream_response_time="0.168" upstream_connect_time="0.000" upstream_header_time="0.168"; 0.169 GET /2009/Jun/20/despair/ HTTP/1.1 200 6320a32c-8497-4c5f-910f-9d042d9b92bd 10.1.58.55 54.36.148.8, 172.69.54.40 http 1.1 vegur 4470 - Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) 0.169 0.168 0.0 0.168
127 2021-08-05T19:11:56.705632+00:00 app[web.1]: measure#nginx.service=0.144 request="GET /search/?type=blogmark&tag=comet&page=1&year=2010 HTTP/1.1" status_code=200 request_id=ee32c3c6-67ce-4f47-820a-cdff8b35d5a3 remote_addr="10.1.58.55" forwarded_for="114.119.138.173, 162.158.165.128" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14369 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.144" upstream_response_time="0.144" upstream_connect_time="0.000" upstream_header_time="0.144"; 0.144 GET /search/?type=blogmark&tag=comet&page=1&year=2010 HTTP/1.1 200 ee32c3c6-67ce-4f47-820a-cdff8b35d5a3 10.1.58.55 114.119.138.173, 162.158.165.128 http 1.1 vegur 14369 - 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.144 0.144 0.0 0.144
108 2021-08-05T19:11:26.126125+00:00 app[web.1]: measure#nginx.service=0.126 request="GET /search/?page=1&type=blogmark&tag=visualisation&month=1 HTTP/1.1" status_code=200 request_id=4ec180ca-b321-4946-9a1f-33642a314dd3 remote_addr="10.1.58.55" forwarded_for="114.119.141.119, 172.70.142.137" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11661 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.126" upstream_response_time="0.124" upstream_connect_time="0.000" upstream_header_time="0.124"; 0.126 GET /search/?page=1&type=blogmark&tag=visualisation&month=1 HTTP/1.1 200 4ec180ca-b321-4946-9a1f-33642a314dd3 10.1.58.55 114.119.141.119, 172.70.142.137 http 1.1 vegur 11661 - 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.126 0.124 0.0 0.124
204 2021-08-05T19:13:53.123385+00:00 app[web.1]: measure#nginx.service=0.123 request="GET /search/?q=javascript&tag=domcontentloaded&type=blogmark&year=2007 HTTP/1.1" status_code=200 request_id=cc31fb03-4995-431b-a653-f575e6f2a07b remote_addr="10.1.58.55" forwarded_for="114.119.147.237, 172.70.142.145" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8964 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.123" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; 0.123 GET /search/?q=javascript&tag=domcontentloaded&type=blogmark&year=2007 HTTP/1.1 200 cc31fb03-4995-431b-a653-f575e6f2a07b 10.1.58.55 114.119.147.237, 172.70.142.145 http 1.1 vegur 8964 - 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.123 0.12 0.0 0.12
32 2021-08-05T19:09:35.248154+00:00 app[web.1]: measure#nginx.service=0.119 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=db74aa41-f5eb-459d-a190-840c9173397a remote_addr="10.1.58.55" forwarded_for="52.207.223.207, 172.70.34.134" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Slackbot 1.0 (+https://api.slack.com/robots)" request_time="0.119" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.116"; 0.119 GET /atom/links/ HTTP/1.1 200 db74aa41-f5eb-459d-a190-840c9173397a 10.1.58.55 52.207.223.207, 172.70.34.134 http 1.1 vegur 16609 - Slackbot 1.0 (+https://api.slack.com/robots) 0.119 0.12 0.0 0.116
113 2021-08-05T19:11:31.607555+00:00 app[web.1]: measure#nginx.service=0.119 request="GET /search/?tag=async&tag=orbited HTTP/1.1" status_code=200 request_id=1afa15ed-4c40-4530-ab5c-9edf817346c2 remote_addr="10.1.58.55" forwarded_for="158.69.243.99, 172.70.127.11" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6025 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.119" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; 0.119 GET /search/?tag=async&tag=orbited HTTP/1.1 200 1afa15ed-4c40-4530-ab5c-9edf817346c2 10.1.58.55 158.69.243.99, 172.70.127.11 http 1.1 vegur 6025 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.119 0.12 0.0 0.12
352 2021-08-05T19:16:27.003937+00:00 app[web.1]: measure#nginx.service=0.040 request="GET /rss HTTP/1.1" status_code=301 request_id=0750a249-359e-4f83-993a-f5cc8a33ff7c remote_addr="10.1.58.55" forwarded_for="2600:3c03::f03c:91ff:fe9d:7b56, 162.158.63.66" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5 referer="-" user_agent="Feed Wrangler/1.0 (3 subscribers; feed-id=272116; http://feedwrangler.net; Allow like Gecko)" request_time="0.040" upstream_response_time="0.040" upstream_connect_time="0.000" upstream_header_time="0.036"; 0.04 GET /rss HTTP/1.1 301 0750a249-359e-4f83-993a-f5cc8a33ff7c 10.1.58.55 2600:3c03::f03c:91ff:fe9d:7b56, 162.158.63.66 http 1.1 vegur 5 - Feed Wrangler/1.0 (3 subscribers; feed-id=272116; http://feedwrangler.net; Allow like Gecko) 0.04 0.04 0.0 0.036

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