log

2 rows where user_agent = "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:92.0) Gecko/20100101 Firefox/92.0" sorted by request_time descending

✎ View and edit SQL

This data as json, CSV (advanced)

remote_addr ✖

user_agent ✖

  • Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:92.0) Gecko/20100101 Firefox/92.0 · 2 ✖
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
81 81 2021-08-05T19:10:44.572808+00:00 app[web.1]: measure#nginx.service=0.232 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=0850950a-f011-47d4-970d-a04b0457282d remote_addr="10.1.14.97" forwarded_for="98.37.79.147, 172.69.35.27" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:92.0) Gecko/20100101 Firefox/92.0" request_time="0.232" upstream_response_time="0.232" upstream_connect_time="0.000" upstream_header_time="0.228"; 0.232 GET /atom/everything/ HTTP/1.1 200 0850950a-f011-47d4-970d-a04b0457282d 10.1.14.97 98.37.79.147, 172.69.35.27 http 1.1 vegur 155913 - Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:92.0) Gecko/20100101 Firefox/92.0 0.232 0.232 0.0 0.228
361 361 2021-08-05T19:16:32.780734+00:00 app[web.1]: measure#nginx.service=0.159 request="GET /atom/everything/ HTTP/1.1" status_code=200 request_id=de22b2e2-da0d-4ba6-8d42-b0767d53d5b4 remote_addr="10.1.31.190" forwarded_for="98.37.79.147, 172.69.35.27" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=155913 referer="-" user_agent="Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:92.0) Gecko/20100101 Firefox/92.0" request_time="0.159" upstream_response_time="0.160" upstream_connect_time="0.000" upstream_header_time="0.156"; 0.159 GET /atom/everything/ HTTP/1.1 200 de22b2e2-da0d-4ba6-8d42-b0767d53d5b4 10.1.31.190 98.37.79.147, 172.69.35.27 http 1.1 vegur 155913 - Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:92.0) Gecko/20100101 Firefox/92.0 0.159 0.16 0.0 0.156

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