log

5 rows where user_agent = "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" sorted by request_time descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: status_code

user_agent ✖

  • Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) · 5 ✖
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
486 486 2021-08-05T19:19:46.724627+00:00 app[web.1]: measure#nginx.service=11.864 request="GET /tags/datasette/ HTTP/1.1" status_code=200 request_id=b5f7b276-4562-4a1f-89de-6034c1619695 remote_addr="10.1.93.20" forwarded_for="66.249.73.62, 108.162.221.138" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=32494 referer="-" user_agent="Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" request_time="11.864" upstream_response_time="11.864" upstream_connect_time="0.000" upstream_header_time="11.864"; 11.864 GET /tags/datasette/ HTTP/1.1 200 b5f7b276-4562-4a1f-89de-6034c1619695 10.1.93.20 66.249.73.62, 108.162.221.138 http 1.1 vegur 32494 - Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) 11.864 11.864 0.0 11.864
454 454 2021-08-05T19:18:54.107520+00:00 app[web.1]: measure#nginx.service=6.453 request="GET /atom/everything HTTP/1.1" status_code=301 request_id=5cb47552-b0b1-4151-adad-846f44fe2fb4 remote_addr="10.1.29.75" forwarded_for="168.119.243.5, 162.158.94.84" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=0 referer="-" user_agent="Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" request_time="6.453" upstream_response_time="6.456" upstream_connect_time="0.000" upstream_header_time="6.456"; 6.453 GET /atom/everything HTTP/1.1 301 5cb47552-b0b1-4151-adad-846f44fe2fb4 10.1.29.75 168.119.243.5, 162.158.94.84 http 1.1 vegur 0 - Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) 6.453 6.456 0.0 6.456
257 257 2021-08-05T19:15:08.986165+00:00 app[web.1]: measure#nginx.service=0.724 request="GET /tags/yagni/ HTTP/1.1" status_code=200 request_id=020237d6-3002-4e6a-94eb-da9b35d55539 remote_addr="10.1.58.55" forwarded_for="66.249.73.58, 108.162.221.201" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7631 referer="-" user_agent="Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" request_time="0.724" upstream_response_time="0.724" upstream_connect_time="0.000" upstream_header_time="0.724"; 0.724 GET /tags/yagni/ HTTP/1.1 200 020237d6-3002-4e6a-94eb-da9b35d55539 10.1.58.55 66.249.73.58, 108.162.221.201 http 1.1 vegur 7631 - Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) 0.724 0.724 0.0 0.724
187 187 2021-08-05T19:13:30.428771+00:00 app[web.1]: measure#nginx.service=0.543 request="GET /2020/ HTTP/1.1" status_code=200 request_id=da4c2ad5-4d25-49b9-bb11-75ff4be210f0 remote_addr="10.1.31.190" forwarded_for="66.249.73.55, 172.69.71.170" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13294 referer="-" user_agent="Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" request_time="0.543" upstream_response_time="0.544" upstream_connect_time="0.000" upstream_header_time="0.544"; 0.543 GET /2020/ HTTP/1.1 200 da4c2ad5-4d25-49b9-bb11-75ff4be210f0 10.1.31.190 66.249.73.55, 172.69.71.170 http 1.1 vegur 13294 - Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) 0.543 0.544 0.0 0.544
114 114 2021-08-05T19:11:32.772892+00:00 app[web.1]: measure#nginx.service=0.147 request="GET /2008/Jan/8/ HTTP/1.1" status_code=200 request_id=ff1b91a7-c9b4-4538-a565-3ef1733bcad4 remote_addr="10.1.28.143" forwarded_for="66.249.73.59, 172.69.70.220" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6853 referer="-" user_agent="Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" request_time="0.147" upstream_response_time="0.148" upstream_connect_time="0.000" upstream_header_time="0.148"; 0.147 GET /2008/Jan/8/ HTTP/1.1 200 ff1b91a7-c9b4-4538-a565-3ef1733bcad4 10.1.28.143 66.249.73.59, 172.69.70.220 http 1.1 vegur 6853 - Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) 0.147 0.148 0.0 0.148

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