log
6 rows where remote_addr = "10.1.63.160" and user_agent = "Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" sorted by referer
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26 | 26 | 2021-08-05T19:09:25.302860+00:00 app[web.1]: measure#nginx.service=2.985 request="GET /search/?tag=tracemonkey&tag=video&tag=offlineresources&tag=browsers&tag=dragndrop&tag=csstransforms&tag=firefox&type=blogmark&month=6&year=2009 HTTP/1.1" status_code=200 request_id=80d278dd-ad0b-4419-ab46-069d4dd9e530 remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.34.237" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=14133 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.985" upstream_response_time="2.984" upstream_connect_time="0.000" upstream_header_time="2.984"; | 2.985 | GET /search/?tag=tracemonkey&tag=video&tag=offlineresources&tag=browsers&tag=dragndrop&tag=csstransforms&tag=firefox&type=blogmark&month=6&year=2009 HTTP/1.1 | 200 | 80d278dd-ad0b-4419-ab46-069d4dd9e530 | 10.1.63.160 | 54.161.41.102, 172.70.34.237 | http | 1.1 vegur | 14133 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 2.985 | 2.984 | 0.0 | 2.984 |
87 | 87 | 2021-08-05T19:10:51.917489+00:00 app[web.1]: measure#nginx.service=2.187 request="GET /search/?tag=textshadow&tag=crossdomain&tag=firefox35&tag=fonts&tag=audio&tag=tracemonkey&tag=dragndrop&type=blogmark&month=6 HTTP/1.1" status_code=200 request_id=b5b4cb17-d48b-479e-a0f8-5a4fbef98fd1 remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.34.143" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12711 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="2.187" upstream_response_time="2.188" upstream_connect_time="0.000" upstream_header_time="2.188"; | 2.187 | GET /search/?tag=textshadow&tag=crossdomain&tag=firefox35&tag=fonts&tag=audio&tag=tracemonkey&tag=dragndrop&type=blogmark&month=6 HTTP/1.1 | 200 | b5b4cb17-d48b-479e-a0f8-5a4fbef98fd1 | 10.1.63.160 | 54.161.41.102, 172.70.34.143 | http | 1.1 vegur | 12711 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 2.187 | 2.188 | 0.0 | 2.188 |
291 | 291 | 2021-08-05T19:15:46.099624+00:00 app[web.1]: measure#nginx.service=1.997 request="GET /search/?tag=webworkers&tag=video&tag=crossdomain&tag=csstransforms&tag=geolocation&tag=offlineresources&tag=dragndrop&type=blogmark&year=2009 HTTP/1.1" status_code=200 request_id=493a4a48-6137-466e-a05c-12d0cfa6b9fc remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.34.57" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13498 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="1.997" upstream_response_time="2.000" upstream_connect_time="0.000" upstream_header_time="2.000"; | 1.997 | GET /search/?tag=webworkers&tag=video&tag=crossdomain&tag=csstransforms&tag=geolocation&tag=offlineresources&tag=dragndrop&type=blogmark&year=2009 HTTP/1.1 | 200 | 493a4a48-6137-466e-a05c-12d0cfa6b9fc | 10.1.63.160 | 54.161.41.102, 172.70.34.57 | http | 1.1 vegur | 13498 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 1.997 | 2.0 | 0.0 | 2.0 |
387 | 387 | 2021-08-05T19:17:14.652086+00:00 app[web.1]: measure#nginx.service=8.044 request="GET /search/?tag=mozilla&tag=performance&tag=localstorage&tag=video&tag=browsers&tag=firefox35&tag=webworkers&tag=textshadow&tag=offlineresources&type=blogmark&year=2009&month=6 HTTP/1.1" status_code=200 request_id=2c61c167-ddb1-4dee-83bb-0eb3afb078be remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.35.58" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16166 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="8.044" upstream_response_time="8.044" upstream_connect_time="0.000" upstream_header_time="8.044"; | 8.044 | GET /search/?tag=mozilla&tag=performance&tag=localstorage&tag=video&tag=browsers&tag=firefox35&tag=webworkers&tag=textshadow&tag=offlineresources&type=blogmark&year=2009&month=6 HTTP/1.1 | 200 | 2c61c167-ddb1-4dee-83bb-0eb3afb078be | 10.1.63.160 | 54.161.41.102, 172.70.35.58 | http | 1.1 vegur | 16166 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 8.044 | 8.044 | 0.0 | 8.044 |
414 | 414 | 2021-08-05T19:17:51.072476+00:00 app[web.1]: measure#nginx.service=0.926 request="GET /search/?tag=offlineresources&tag=json&tag=tracemonkey&type=blogmark HTTP/1.1" status_code=200 request_id=d2a55505-33d2-4950-9bc2-10b144001481 remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.35.40" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8901 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="0.926" upstream_response_time="0.928" upstream_connect_time="0.000" upstream_header_time="0.928"; | 0.926 | GET /search/?tag=offlineresources&tag=json&tag=tracemonkey&type=blogmark HTTP/1.1 | 200 | d2a55505-33d2-4950-9bc2-10b144001481 | 10.1.63.160 | 54.161.41.102, 172.70.35.40 | http | 1.1 vegur | 8901 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 0.926 | 0.928 | 0.0 | 0.928 |
448 | 448 | 2021-08-05T19:18:50.797582+00:00 app[web.1]: measure#nginx.service=16.725 request="GET /search/?tag=browsers&tag=csstransforms&tag=video&tag=localstorage&tag=firefox&tag=html5&tag=fonts&type=blogmark HTTP/1.1" status_code=200 request_id=5068cc02-4444-47a4-95c2-e88bd74b8dae remote_addr="10.1.63.160" forwarded_for="54.161.41.102, 172.70.34.133" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11721 referer="-" user_agent="Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot)" request_time="16.725" upstream_response_time="16.724" upstream_connect_time="0.000" upstream_header_time="16.724"; | 16.725 | GET /search/?tag=browsers&tag=csstransforms&tag=video&tag=localstorage&tag=firefox&tag=html5&tag=fonts&type=blogmark HTTP/1.1 | 200 | 5068cc02-4444-47a4-95c2-e88bd74b8dae | 10.1.63.160 | 54.161.41.102, 172.70.34.133 | http | 1.1 vegur | 11721 | - | Mozilla/5.0 (compatible; Neevabot/1.0; +https://neeva.com/neevabot) | 16.725 | 16.724 | 0.0 | 16.724 |
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 );