log

9 rows where remote_addr = "10.1.94.69" 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 referer

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: upstream_response_time, upstream_header_time

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) · 9 ✖

remote_addr ✖

  • 10.1.94.69 · 9 ✖
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
20 20 2021-08-05T19:09:12.214395+00:00 app[web.1]: measure#nginx.service=0.125 request="GET /search/?page=1&tag=dmigrations&month=9&type=entry HTTP/1.1" status_code=200 request_id=3c1bb05c-d3af-4d38-823a-bdf46207d092 remote_addr="10.1.94.69" forwarded_for="114.119.138.140, 172.70.142.159" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6695 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.125" upstream_response_time="0.124" upstream_connect_time="0.000" upstream_header_time="0.124"; 0.125 GET /search/?page=1&tag=dmigrations&month=9&type=entry HTTP/1.1 200 3c1bb05c-d3af-4d38-823a-bdf46207d092 10.1.94.69 114.119.138.140, 172.70.142.159 http 1.1 vegur 6695 - 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.125 0.124 0.0 0.124
39 39 2021-08-05T19:09:48.067805+00:00 app[web.1]: measure#nginx.service=0.205 request="GET /search/?year=2010&month=1&tag=osx HTTP/1.1" status_code=200 request_id=cd566e13-465a-4219-b55b-61b6b8a8c610 remote_addr="10.1.94.69" forwarded_for="114.119.131.203, 172.70.143.3" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6860 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.205" upstream_response_time="0.208" upstream_connect_time="0.000" upstream_header_time="0.208"; 0.205 GET /search/?year=2010&month=1&tag=osx HTTP/1.1 200 cd566e13-465a-4219-b55b-61b6b8a8c610 10.1.94.69 114.119.131.203, 172.70.143.3 http 1.1 vegur 6860 - 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.205 0.208 0.0 0.208
46 46 2021-08-05T19:09:55.837905+00:00 app[web.1]: measure#nginx.service=1.197 request="GET /search/?type=blogmark&tag=browserplus&year=2010&month=2 HTTP/1.1" status_code=200 request_id=ab032f98-8ded-4e93-a5bd-e26d00e6ca8f remote_addr="10.1.94.69" forwarded_for="114.119.157.236, 172.70.142.224" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7195 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="1.197" upstream_response_time="1.196" upstream_connect_time="0.000" upstream_header_time="1.196"; 1.197 GET /search/?type=blogmark&tag=browserplus&year=2010&month=2 HTTP/1.1 200 ab032f98-8ded-4e93-a5bd-e26d00e6ca8f 10.1.94.69 114.119.157.236, 172.70.142.224 http 1.1 vegur 7195 - 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) 1.197 1.196 0.0 1.196
89 89 2021-08-05T19:10:53.832858+00:00 app[web.1]: measure#nginx.service=0.132 request="GET /search/?q%3Dpostgresql&page=1&type=blogmark&year=2009&tag=facebook HTTP/1.1" status_code=200 request_id=605906b8-67d8-4041-825d-3414a346da5d remote_addr="10.1.94.69" forwarded_for="114.119.154.59, 172.70.142.222" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=19251 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.132" upstream_response_time="0.132" upstream_connect_time="0.000" upstream_header_time="0.132"; 0.132 GET /search/?q%3Dpostgresql&page=1&type=blogmark&year=2009&tag=facebook HTTP/1.1 200 605906b8-67d8-4041-825d-3414a346da5d 10.1.94.69 114.119.154.59, 172.70.142.222 http 1.1 vegur 19251 - 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.132 0.132 0.0 0.132
123 123 2021-08-05T19:11:47.285191+00:00 app[web.1]: measure#nginx.service=0.267 request="GET /search/?page=1&tag=scaling&year=2009 HTTP/1.1" status_code=200 request_id=0b9d7ab9-8761-41b7-a6f3-cb55d26461c5 remote_addr="10.1.94.69" forwarded_for="114.119.140.64, 172.70.143.104" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=25358 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.267" upstream_response_time="0.268" upstream_connect_time="0.000" upstream_header_time="0.268"; 0.267 GET /search/?page=1&tag=scaling&year=2009 HTTP/1.1 200 0b9d7ab9-8761-41b7-a6f3-cb55d26461c5 10.1.94.69 114.119.140.64, 172.70.143.104 http 1.1 vegur 25358 - 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.267 0.268 0.0 0.268
136 136 2021-08-05T19:12:09.142208+00:00 app[web.1]: measure#nginx.service=1.464 request="GET /search/?tag=zeppelins&year=2008&page=1&month=10 HTTP/1.1" status_code=200 request_id=277b6160-32f4-4fa2-bb16-fb1794b216d6 remote_addr="10.1.94.69" forwarded_for="114.119.150.252, 172.70.143.124" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6271 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="1.464" upstream_response_time="1.464" upstream_connect_time="0.000" upstream_header_time="1.464"; 1.464 GET /search/?tag=zeppelins&year=2008&page=1&month=10 HTTP/1.1 200 277b6160-32f4-4fa2-bb16-fb1794b216d6 10.1.94.69 114.119.150.252, 172.70.143.124 http 1.1 vegur 6271 - 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) 1.464 1.464 0.0 1.464
229 229 2021-08-05T19:14:25.176877+00:00 app[web.1]: measure#nginx.service=0.209 request="GET /search/?page=1&tag=github&month=11 HTTP/1.1" status_code=200 request_id=2e2f9705-6895-4cc7-9bb8-87e1e9c285db remote_addr="10.1.94.69" forwarded_for="114.119.157.236, 172.70.147.2" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=18442 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.209" upstream_response_time="0.208" upstream_connect_time="0.000" upstream_header_time="0.208"; 0.209 GET /search/?page=1&tag=github&month=11 HTTP/1.1 200 2e2f9705-6895-4cc7-9bb8-87e1e9c285db 10.1.94.69 114.119.157.236, 172.70.147.2 http 1.1 vegur 18442 - 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.209 0.208 0.0 0.208
404 404 2021-08-05T19:17:35.236062+00:00 app[web.1]: measure#nginx.service=0.495 request="GET /search/?page=1&type=blogmark&year=2010&tag=orm HTTP/1.1" status_code=200 request_id=9c287af4-b181-4956-9467-5b825d1bdbbe remote_addr="10.1.94.69" forwarded_for="114.119.140.219, 172.70.147.171" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=12374 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.495" upstream_response_time="0.496" upstream_connect_time="0.000" upstream_header_time="0.496"; 0.495 GET /search/?page=1&type=blogmark&year=2010&tag=orm HTTP/1.1 200 9c287af4-b181-4956-9467-5b825d1bdbbe 10.1.94.69 114.119.140.219, 172.70.147.171 http 1.1 vegur 12374 - 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.495 0.496 0.0 0.496
480 480 2021-08-05T19:19:43.766503+00:00 app[web.1]: measure#nginx.service=19.408 request="GET /search/?page=1&year=2019&tag=genetics&month=9 HTTP/1.1" status_code=200 request_id=ddac726d-e5d9-4d02-9c0f-5aa214bbe766 remote_addr="10.1.94.69" forwarded_for="114.119.147.73, 172.70.143.12" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8505 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="19.408" upstream_response_time="19.408" upstream_connect_time="0.000" upstream_header_time="19.408"; 19.408 GET /search/?page=1&year=2019&tag=genetics&month=9 HTTP/1.1 200 ddac726d-e5d9-4d02-9c0f-5aa214bbe766 10.1.94.69 114.119.147.73, 172.70.143.12 http 1.1 vegur 8505 - 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) 19.408 19.408 0.0 19.408

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