log
13 rows where remote_addr = "10.1.27.43" sorted by upstream_header_time
This data as json, CSV (advanced)
Suggested facets: request, body_bytes_sent
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) 4
- Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) 3
- Feedly/1.0 (+http://www.feedly.com/fetcher.html; 15 subscribers; like FeedFetcher-Google) 1
- Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:89.0) Gecko/20100101 Firefox/89.0 1
- Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 1
- Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) 1
- NextCloud-News/1.0 1
- newspaper/0.2.8 1
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80 | 80 | 2021-08-05T19:10:44.106852+00:00 app[web.1]: measure#nginx.service=0.112 request="GET /search/?type=blogmark&month=9&tag=wiki&year=2007 HTTP/1.1" status_code=200 request_id=0bff7c11-5d36-4d1b-95bf-38516d0d570a remote_addr="10.1.27.43" forwarded_for="114.119.135.163, 172.70.143.95" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8060 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.112" upstream_response_time="0.112" upstream_connect_time="0.000" upstream_header_time="0.112"; | 0.112 | GET /search/?type=blogmark&month=9&tag=wiki&year=2007 HTTP/1.1 | 200 | 0bff7c11-5d36-4d1b-95bf-38516d0d570a | 10.1.27.43 | 114.119.135.163, 172.70.143.95 | http | 1.1 vegur | 8060 | - | 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.112 | 0.112 | 0.0 | 0.112 |
411 | 411 | 2021-08-05T19:17:46.091796+00:00 app[web.1]: measure#nginx.service=0.147 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=63471148-c4d5-458d-a02a-bf2f738dbe5f remote_addr="10.1.27.43" forwarded_for="8.29.198.26, 172.69.35.175" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Feedly/1.0 (+http://www.feedly.com/fetcher.html; 15 subscribers; like FeedFetcher-Google)" request_time="0.147" upstream_response_time="0.148" upstream_connect_time="0.000" upstream_header_time="0.140"; | 0.147 | GET /atom/links/ HTTP/1.1 | 200 | 63471148-c4d5-458d-a02a-bf2f738dbe5f | 10.1.27.43 | 8.29.198.26, 172.69.35.175 | http | 1.1 vegur | 16609 | - | Feedly/1.0 (+http://www.feedly.com/fetcher.html; 15 subscribers; like FeedFetcher-Google) | 0.147 | 0.148 | 0.0 | 0.14 |
281 | 281 | 2021-08-05T19:15:34.052655+00:00 app[web.1]: measure#nginx.service=0.224 request="GET /search/?q%3Dpostgresql&tag=javascript&month=6&year=2010 HTTP/1.1" status_code=200 request_id=d3511bb1-81fb-43c2-bcb0-cd7740c54ad5 remote_addr="10.1.27.43" forwarded_for="114.119.146.244, 172.70.142.4" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8481 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.224" upstream_response_time="0.224" upstream_connect_time="0.000" upstream_header_time="0.224"; | 0.224 | GET /search/?q%3Dpostgresql&tag=javascript&month=6&year=2010 HTTP/1.1 | 200 | d3511bb1-81fb-43c2-bcb0-cd7740c54ad5 | 10.1.27.43 | 114.119.146.244, 172.70.142.4 | http | 1.1 vegur | 8481 | - | 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.224 | 0.224 | 0.0 | 0.224 |
421 | 421 | 2021-08-05T19:18:01.038637+00:00 app[web.1]: measure#nginx.service=0.416 request="GET /search/?q%3Dpostgresql&type=blogmark&tag=changeset HTTP/1.1" status_code=200 request_id=546397c4-098e-4752-b17d-6388f74bb850 remote_addr="10.1.27.43" forwarded_for="114.119.134.231, 172.70.143.35" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5679 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.416" upstream_response_time="0.416" upstream_connect_time="0.000" upstream_header_time="0.416"; | 0.416 | GET /search/?q%3Dpostgresql&type=blogmark&tag=changeset HTTP/1.1 | 200 | 546397c4-098e-4752-b17d-6388f74bb850 | 10.1.27.43 | 114.119.134.231, 172.70.143.35 | http | 1.1 vegur | 5679 | - | 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.416 | 0.416 | 0.0 | 0.416 |
321 | 321 | 2021-08-05T19:15:54.752233+00:00 app[web.1]: measure#nginx.service=0.780 request="GET /2010/ HTTP/1.1" status_code=200 request_id=ea187806-84ae-4285-9e3b-030547e0ed17 remote_addr="10.1.27.43" forwarded_for="34.147.114.27, 172.69.54.123" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=25139 referer="-" user_agent="newspaper/0.2.8" request_time="0.780" upstream_response_time="0.780" upstream_connect_time="0.000" upstream_header_time="0.780"; | 0.78 | GET /2010/ HTTP/1.1 | 200 | ea187806-84ae-4285-9e3b-030547e0ed17 | 10.1.27.43 | 34.147.114.27, 172.69.54.123 | http | 1.1 vegur | 25139 | - | newspaper/0.2.8 | 0.78 | 0.78 | 0.0 | 0.78 |
219 | 219 | 2021-08-05T19:14:09.829984+00:00 app[web.1]: measure#nginx.service=0.861 request="GET /search/?tag=libraries&year=2008&page=1&month=2 HTTP/1.1" status_code=200 request_id=1bb21746-6e74-4d57-8a1d-06edebc3bb83 remote_addr="10.1.27.43" forwarded_for="114.119.157.22, 172.70.142.229" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7259 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.861" upstream_response_time="0.860" upstream_connect_time="0.000" upstream_header_time="0.860"; | 0.861 | GET /search/?tag=libraries&year=2008&page=1&month=2 HTTP/1.1 | 200 | 1bb21746-6e74-4d57-8a1d-06edebc3bb83 | 10.1.27.43 | 114.119.157.22, 172.70.142.229 | http | 1.1 vegur | 7259 | - | 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.861 | 0.86 | 0.0 | 0.86 |
351 | 351 | 2021-08-05T19:16:25.138595+00:00 app[web.1]: measure#nginx.service=1.204 request="GET /search/?tag=localstorage&tag=textshadow&tag=canvas&tag=tracemonkey&tag=json&tag=geolocation&year=2009&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=b03eec85-fe95-4584-a6f4-6a9dbf790466 remote_addr="10.1.27.43" forwarded_for="54.161.41.102, 172.70.35.66" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12974 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.204" upstream_response_time="1.204" upstream_connect_time="0.000" upstream_header_time="1.204"; | 1.204 | GET /search/?tag=localstorage&tag=textshadow&tag=canvas&tag=tracemonkey&tag=json&tag=geolocation&year=2009&type=blogmark&month=6 HTTP/1.1 | 200 | b03eec85-fe95-4584-a6f4-6a9dbf790466 | 10.1.27.43 | 54.161.41.102, 172.70.35.66 | http | 1.1 vegur | 12974 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 1.204 | 1.204 | 0.0 | 1.204 |
413 | 413 | 2021-08-05T19:17:50.781175+00:00 app[web.1]: measure#nginx.service=1.247 request="GET /search/?tag=fbml&tag=xfbml&tag=security HTTP/1.1" status_code=200 request_id=63ca0c3b-c93a-4871-b986-cff7fe7bc861 remote_addr="10.1.27.43" forwarded_for="13.66.139.0, 108.162.246.200" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6100 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.247" upstream_response_time="1.248" upstream_connect_time="0.000" upstream_header_time="1.248"; | 1.247 | GET /search/?tag=fbml&tag=xfbml&tag=security HTTP/1.1 | 200 | 63ca0c3b-c93a-4871-b986-cff7fe7bc861 | 10.1.27.43 | 13.66.139.0, 108.162.246.200 | http | 1.1 vegur | 6100 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 1.247 | 1.248 | 0.0 | 1.248 |
116 | 116 | 2021-08-05T19:11:36.139211+00:00 app[web.1]: measure#nginx.service=3.370 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=schemaless HTTP/1.1" status_code=200 request_id=6eef5379-6c2a-45cd-ad65-cd0f162b95ec remote_addr="10.1.27.43" forwarded_for="167.114.100.201, 172.70.126.218" 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="3.370" upstream_response_time="3.368" upstream_connect_time="0.000" upstream_header_time="3.368"; | 3.37 | GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=schemaless HTTP/1.1 | 200 | 6eef5379-6c2a-45cd-ad65-cd0f162b95ec | 10.1.27.43 | 167.114.100.201, 172.70.126.218 | http | 1.1 vegur | 6649 | - | Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) | 3.37 | 3.368 | 0.0 | 3.368 |
259 | 259 | 2021-08-05T19:15:10.267726+00:00 app[web.1]: measure#nginx.service=3.426 request="GET /search/?tag=offlineresources&tag=webworkers&tag=tracemonkey&tag=json&tag=firefox&tag=javascript&tag=mozilla&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=3ade3112-639b-4395-9c30-5de928cccf28 remote_addr="10.1.27.43" forwarded_for="54.161.41.102, 172.70.34.109" 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="3.426" upstream_response_time="3.428" upstream_connect_time="0.000" upstream_header_time="3.428"; | 3.426 | GET /search/?tag=offlineresources&tag=webworkers&tag=tracemonkey&tag=json&tag=firefox&tag=javascript&tag=mozilla&type=blogmark&year=2009 HTTP/1.1 | 200 | 3ade3112-639b-4395-9c30-5de928cccf28 | 10.1.27.43 | 54.161.41.102, 172.70.34.109 | http | 1.1 vegur | 13138 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 3.426 | 3.428 | 0.0 | 3.428 |
427 | 427 | 2021-08-05T19:18:13.909067+00:00 app[web.1]: measure#nginx.service=4.494 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=87e736e7-921e-44cf-99c4-92be5a072e23 remote_addr="10.1.27.43" forwarded_for="140.238.240.248, 172.68.155.147" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="NextCloud-News/1.0" request_time="4.494" upstream_response_time="4.496" upstream_connect_time="0.000" upstream_header_time="4.492"; | 4.494 | GET /atom/everything/ HTTP/1.1 | 200 | 87e736e7-921e-44cf-99c4-92be5a072e23 | 10.1.27.43 | 140.238.240.248, 172.68.155.147 | http | 1.1 vegur | 155913 | - | NextCloud-News/1.0 | 4.494 | 4.496 | 0.0 | 4.492 |
8 | 8 | 2021-08-05T19:09:01.529601+00:00 app[web.1]: measure#nginx.service=11.287 request="GET /search/?tag=audio&tag=dragndrop&tag=fonts&tag=firefox&tag=html5&tag=mozilla&tag=offlineresources&tag=javascript&tag=canvas&tag=tracemonkey&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=c5e60a6c-d8c5-4220-8a57-e0aa9630e545 remote_addr="10.1.27.43" forwarded_for="54.161.41.102, 172.70.34.51" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=15652 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="11.287" upstream_response_time="11.288" upstream_connect_time="0.000" upstream_header_time="11.288"; | 11.287 | GET /search/?tag=audio&tag=dragndrop&tag=fonts&tag=firefox&tag=html5&tag=mozilla&tag=offlineresources&tag=javascript&tag=canvas&tag=tracemonkey&year=2009&type=blogmark HTTP/1.1 | 200 | c5e60a6c-d8c5-4220-8a57-e0aa9630e545 | 10.1.27.43 | 54.161.41.102, 172.70.34.51 | http | 1.1 vegur | 15652 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 11.287 | 11.288 | 0.0 | 11.288 |
438 | 438 | 2021-08-05T19:18:43.005610+00:00 app[web.1]: measure#nginx.service=19.921 request="GET /search/?tag=audio&tag=dragndrop&tag=fonts&tag=firefox&tag=html5&tag=mozilla&tag=offlineresources&tag=javascript&tag=canvas&tag=tracemonkey&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=81b87f0b-ceba-404c-ae19-7648cccaf335 remote_addr="10.1.27.43" forwarded_for="73.189.212.18, 172.70.98.73" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=15652 referer="-" user_agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:89.0) Gecko/20100101 Firefox/89.0" request_time="19.921" upstream_response_time="19.920" upstream_connect_time="0.000" upstream_header_time="19.920"; | 19.921 | GET /search/?tag=audio&tag=dragndrop&tag=fonts&tag=firefox&tag=html5&tag=mozilla&tag=offlineresources&tag=javascript&tag=canvas&tag=tracemonkey&year=2009&type=blogmark HTTP/1.1 | 200 | 81b87f0b-ceba-404c-ae19-7648cccaf335 | 10.1.27.43 | 73.189.212.18, 172.70.98.73 | http | 1.1 vegur | 15652 | - | Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:89.0) Gecko/20100101 Firefox/89.0 | 19.921 | 19.92 | 0.0 | 19.92 |
Advanced export
JSON shape: default, array, newline-delimited
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 );