log
3 rows where remote_addr = "10.1.3.226" and 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)" sorted by request_time descending
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 459 | 459 | 2021-08-05T19:19:14.954421+00:00 app[web.1]: measure#nginx.service=20.716 request="GET /search/?q=javascript&type=blogmark&month=1&tag=bayeux HTTP/1.1" status_code=200 request_id=f8d7cc1f-fc7c-4eeb-8a6f-697691402263 remote_addr="10.1.3.226" forwarded_for="114.119.155.233, 172.70.147.164" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8006 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="20.716" upstream_response_time="20.716" upstream_connect_time="0.000" upstream_header_time="20.716"; | 20.716 | GET /search/?q=javascript&type=blogmark&month=1&tag=bayeux HTTP/1.1 | 200 | f8d7cc1f-fc7c-4eeb-8a6f-697691402263 | 10.1.3.226 | 114.119.155.233, 172.70.147.164 | http | 1.1 vegur | 8006 | - | 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) | 20.716 | 20.716 | 0.0 | 20.716 |
| 31 | 31 | 2021-08-05T19:09:32.833352+00:00 app[web.1]: measure#nginx.service=0.328 request="GET /search/?year=2008&month=6&tag=basecamp HTTP/1.1" status_code=200 request_id=b74ef974-52f8-49ce-92d7-92e76b287165 remote_addr="10.1.3.226" forwarded_for="114.119.152.149, 162.158.166.166" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6280 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.328" upstream_response_time="0.328" upstream_connect_time="0.000" upstream_header_time="0.328"; | 0.328 | GET /search/?year=2008&month=6&tag=basecamp HTTP/1.1 | 200 | b74ef974-52f8-49ce-92d7-92e76b287165 | 10.1.3.226 | 114.119.152.149, 162.158.166.166 | http | 1.1 vegur | 6280 | - | 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.328 | 0.328 | 0.0 | 0.328 |
| 399 | 399 | 2021-08-05T19:17:29.717055+00:00 app[web.1]: measure#nginx.service=0.118 request="GET /search/?tag=flickrplaces&year=2008&page=1&month=1 HTTP/1.1" status_code=200 request_id=2aa2e65e-0573-40f6-99e8-d8396ee7cb42 remote_addr="10.1.3.226" forwarded_for="114.119.144.85, 172.70.147.75" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7172 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.118" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; | 0.118 | GET /search/?tag=flickrplaces&year=2008&page=1&month=1 HTTP/1.1 | 200 | 2aa2e65e-0573-40f6-99e8-d8396ee7cb42 | 10.1.3.226 | 114.119.144.85, 172.70.147.75 | http | 1.1 vegur | 7172 | - | 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.118 | 0.12 | 0.0 | 0.12 |
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 );