This data as json, CSV (advanced)
Link | rowid | start | method | path | query_string | user_agent | referer | accept_language | http_status | content_type | client_ip | duration | body_size ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | 1576529187.141084 | GET | /-/static/app.css 2 | ?cbffc0 1 | Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:70.0) Gecko/20100101 Firefox/70.0 1 | http://127.0.0.1:8855/ 1 | en-US,en;q=0.5 1 | 200 | text/css 2 | 127.0.0.1 | 0.0059969425201416016 | 6104 |
5 | 5 | 1576529188.0266829 | GET | /-/static/app.css 2 | ?cbffc0 1 | Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:70.0) Gecko/20100101 Firefox/70.0 1 | http://127.0.0.1:8855/ 1 | en-US,en;q=0.5 1 | 200 | text/css 2 | 127.0.0.1 | 0.002092123031616211 | 6104 |
8 | 8 | 1576529192.6133409 | GET | /-/static/app.css 2 | ?cbffc0 1 | Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:70.0) Gecko/20100101 Firefox/70.0 1 | http://127.0.0.1:8855/ 1 | en-US,en;q=0.5 1 | 200 | text/css 2 | 127.0.0.1 | 0.0055201053619384766 | 6104 |
JSON shape: default, array, newline-delimited
CREATE TABLE [requests] ( [start] FLOAT, [method] TEXT, [path] INTEGER REFERENCES [paths]([id]), [query_string] INTEGER REFERENCES [query_strings]([id]), [user_agent] INTEGER REFERENCES [user_agents]([id]), [referer] INTEGER REFERENCES [referers]([id]), [accept_language] INTEGER REFERENCES [accept_languages]([id]), [http_status] INTEGER, [content_type] INTEGER REFERENCES [content_types]([id]), [client_ip] TEXT, [duration] FLOAT, [body_size] INTEGER );