log
9 rows where user_agent = "Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" sorted by request_time descending
This data as json, CSV (advanced)
Suggested facets: upstream_response_time, upstream_header_time
remote_addr ✖
- 10.1.58.55 3
- 10.1.29.75 1
- 10.1.7.130 1
- 10.1.7.41 1
- 10.1.92.174 1
- 10.1.93.20 1
- 10.1.94.69 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
462 | 462 | 2021-08-05T19:19:15.597358+00:00 app[web.1]: measure#nginx.service=16.844 request="GET /tags/yelp/ HTTP/1.1" status_code=200 request_id=6a44e4f1-98c8-4126-8210-9624e343b8e9 remote_addr="10.1.94.69" forwarded_for="54.36.148.58, 141.101.104.51" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=8121 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="16.844" upstream_response_time="16.844" upstream_connect_time="0.000" upstream_header_time="16.844"; | 16.844 | GET /tags/yelp/ HTTP/1.1 | 200 | 6a44e4f1-98c8-4126-8210-9624e343b8e9 | 10.1.94.69 | 54.36.148.58, 141.101.104.51 | http | 1.1 vegur | 8121 | - | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) | 16.844 | 16.844 | 0.0 | 16.844 |
342 | 342 | 2021-08-05T19:16:18.408378+00:00 app[web.1]: measure#nginx.service=7.867 request="GET /search/?q=%F0%9F%A6%A5%E2%A5%AE%E2%9D%8B%20www.Getroman.store%20%E2%9D%8B%E2%A5%AE%F0%9F%A6%A5%20Costo%20viagra%20100%20mg%20in%20farmacia%20Viagra%20generico%20acquisto%20senza%20ricetta%20Best%20sites%20to%20buy%20cialis%20online%20Comprare%20cialis%20in%20gel%20online%20Cialis%20generico%2020%20mg%20online%20farmacia%20italia HTTP/1.1" status_code=200 request_id=eddc5bd0-ef90-4309-afd0-5427720409f6 remote_addr="10.1.93.20" forwarded_for="54.36.148.115, 141.101.77.136" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=4136 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="7.867" upstream_response_time="7.868" upstream_connect_time="0.000" upstream_header_time="7.868"; | 7.867 | GET /search/?q=%F0%9F%A6%A5%E2%A5%AE%E2%9D%8B%20www.Getroman.store%20%E2%9D%8B%E2%A5%AE%F0%9F%A6%A5%20Costo%20viagra%20100%20mg%20in%20farmacia%20Viagra%20generico%20acquisto%20senza%20ricetta%20Best%20sites%20to%20buy%20cialis%20online%20Comprare%20cialis%20in%20gel%20online%20Cialis%20generico%2020%20mg%20online%20farmacia%20italia HTTP/1.1 | 200 | eddc5bd0-ef90-4309-afd0-5427720409f6 | 10.1.93.20 | 54.36.148.115, 141.101.77.136 | http | 1.1 vegur | 4136 | - | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) | 7.867 | 7.868 | 0.0 | 7.868 |
162 | 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 |
206 | 206 | 2021-08-05T19:13:59.304389+00:00 app[web.1]: measure#nginx.service=1.872 request="GET /tags/sha1/ HTTP/1.1" status_code=200 request_id=5a8b942c-df1d-4d91-9d39-74d07c2461b5 remote_addr="10.1.92.174" forwarded_for="54.36.148.188, 141.101.104.140" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5983 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="1.872" upstream_response_time="1.872" upstream_connect_time="0.000" upstream_header_time="1.872"; | 1.872 | GET /tags/sha1/ HTTP/1.1 | 200 | 5a8b942c-df1d-4d91-9d39-74d07c2461b5 | 10.1.92.174 | 54.36.148.188, 141.101.104.140 | http | 1.1 vegur | 5983 | - | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) | 1.872 | 1.872 | 0.0 | 1.872 |
210 | 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 |
258 | 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 |
275 | 275 | 2021-08-05T19:15:26.227245+00:00 app[web.1]: measure#nginx.service=0.121 request="GET /2007/May/16/upload/ HTTP/1.1" status_code=200 request_id=c13d1a33-2631-48ed-ad3f-ffb29bd57038 remote_addr="10.1.7.130" forwarded_for="54.36.148.169, 141.101.77.127" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=4156 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="0.121" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; | 0.121 | GET /2007/May/16/upload/ HTTP/1.1 | 200 | c13d1a33-2631-48ed-ad3f-ffb29bd57038 | 10.1.7.130 | 54.36.148.169, 141.101.77.127 | http | 1.1 vegur | 4156 | - | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) | 0.121 | 0.12 | 0.0 | 0.12 |
101 | 101 | 2021-08-05T19:11:14.471730+00:00 app[web.1]: measure#nginx.service=0.116 request="GET /2021/Jul/10/behind-the-scenes-aws-lambda/ HTTP/1.1" status_code=200 request_id=606a4e1f-e5ff-4710-b488-68a679e247a6 remote_addr="10.1.7.41" forwarded_for="54.36.148.177, 141.101.105.235" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=4200 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="0.116" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; | 0.116 | GET /2021/Jul/10/behind-the-scenes-aws-lambda/ HTTP/1.1 | 200 | 606a4e1f-e5ff-4710-b488-68a679e247a6 | 10.1.7.41 | 54.36.148.177, 141.101.105.235 | http | 1.1 vegur | 4200 | - | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) | 0.116 | 0.12 | 0.0 | 0.12 |
91 | 91 | 2021-08-05T19:10:54.952639+00:00 app[web.1]: measure#nginx.service=0.062 request="GET /2017/Nov/14/proxy-cache-lock/ HTTP/1.1" status_code=200 request_id=52387811-56c9-44ef-ba3b-ce8ebb476f5c remote_addr="10.1.29.75" forwarded_for="54.36.148.134, 141.101.76.62" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=4541 referer="-" user_agent="Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)" request_time="0.062" upstream_response_time="0.064" upstream_connect_time="0.000" upstream_header_time="0.064"; | 0.062 | GET /2017/Nov/14/proxy-cache-lock/ HTTP/1.1 | 200 | 52387811-56c9-44ef-ba3b-ce8ebb476f5c | 10.1.29.75 | 54.36.148.134, 141.101.76.62 | http | 1.1 vegur | 4541 | - | Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/) | 0.062 | 0.064 | 0.0 | 0.064 |
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 );