log
9 rows where body_bytes_sent = 16609 sorted by request_time descending
This data as json, CSV (advanced)
Suggested facets: remote_addr, forwarded_for, referer, user_agent, upstream_response_time
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 460 | 460 | 2021-08-05T19:19:15.136925+00:00 app[web.1]: measure#nginx.service=20.592 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=b5bf893d-f88b-4a0f-a677-352c4529b26a remote_addr="10.1.63.160" forwarded_for="144.217.244.188, 172.70.127.10" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Mozilla/5.0 (compatible; YaK/1.0; http://linkfluence.com/; bot@linkfluence.com)" request_time="20.592" upstream_response_time="20.592" upstream_connect_time="0.000" upstream_header_time="20.588"; | 20.592 | GET /atom/links/ HTTP/1.1 | 200 | b5bf893d-f88b-4a0f-a677-352c4529b26a | 10.1.63.160 | 144.217.244.188, 172.70.127.10 | http | 1.1 vegur | 16609 | - | Mozilla/5.0 (compatible; YaK/1.0; http://linkfluence.com/; bot@linkfluence.com) | 20.592 | 20.592 | 0.0 | 20.588 |
| 461 | 461 | 2021-08-05T19:19:15.373123+00:00 app[web.1]: measure#nginx.service=20.028 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=bdd7d61d-caeb-4fe3-93ba-73aa03df9230 remote_addr="10.1.14.97" forwarded_for="94.130.182.203, 162.158.91.132" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app)" request_time="20.028" upstream_response_time="20.028" upstream_connect_time="0.000" upstream_header_time="20.024"; | 20.028 | GET /atom/links/ HTTP/1.1 | 200 | bdd7d61d-caeb-4fe3-93ba-73aa03df9230 | 10.1.14.97 | 94.130.182.203, 162.158.91.132 | http | 1.1 vegur | 16609 | - | Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app) | 20.028 | 20.028 | 0.0 | 20.024 |
| 76 | 76 | 2021-08-05T19:10:41.735312+00:00 app[web.1]: measure#nginx.service=1.293 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=143510c6-47f8-42e2-8260-42b3f2d1f589 remote_addr="10.1.87.198" forwarded_for="8.29.198.26, 172.69.35.175" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Feedly/1.0 (+http://www.feedly.com/fetcher.html; 15 subscribers; like FeedFetcher-Google)" request_time="1.293" upstream_response_time="1.296" upstream_connect_time="0.000" upstream_header_time="1.292"; | 1.293 | GET /atom/links/ HTTP/1.1 | 200 | 143510c6-47f8-42e2-8260-42b3f2d1f589 | 10.1.87.198 | 8.29.198.26, 172.69.35.175 | http | 1.1 vegur | 16609 | - | Feedly/1.0 (+http://www.feedly.com/fetcher.html; 15 subscribers; like FeedFetcher-Google) | 1.293 | 1.296 | 0.0 | 1.292 |
| 389 | 389 | 2021-08-05T19:17:14.876393+00:00 app[web.1]: measure#nginx.service=0.213 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=f82fc09b-1a8f-4fcd-957a-b93c5582c235 remote_addr="10.1.89.90" forwarded_for="168.91.196.173, 172.70.130.51" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app)" request_time="0.213" upstream_response_time="0.212" upstream_connect_time="0.000" upstream_header_time="0.208"; | 0.213 | GET /atom/links/ HTTP/1.1 | 200 | f82fc09b-1a8f-4fcd-957a-b93c5582c235 | 10.1.89.90 | 168.91.196.173, 172.70.130.51 | http | 1.1 vegur | 16609 | - | Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app) | 0.213 | 0.212 | 0.0 | 0.208 |
| 250 | 250 | 2021-08-05T19:14:59.062471+00:00 app[web.1]: measure#nginx.service=0.152 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=b155e8e6-6a43-457b-9ad5-1bb16f7e7599 remote_addr="10.1.3.232" forwarded_for="92.247.181.10, 172.68.50.92" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="https://simonwillison.net/" user_agent="Mozilla/5.0 (compatible; inoreader.com; 7 subscribers)" request_time="0.152" upstream_response_time="0.152" upstream_connect_time="0.000" upstream_header_time="0.152"; | 0.152 | GET /atom/links/ HTTP/1.1 | 200 | b155e8e6-6a43-457b-9ad5-1bb16f7e7599 | 10.1.3.232 | 92.247.181.10, 172.68.50.92 | http | 1.1 vegur | 16609 | https://simonwillison.net/ | Mozilla/5.0 (compatible; inoreader.com; 7 subscribers) | 0.152 | 0.152 | 0.0 | 0.152 |
| 411 | 411 | 2021-08-05T19:17:46.091796+00:00 app[web.1]: measure#nginx.service=0.147 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=63471148-c4d5-458d-a02a-bf2f738dbe5f remote_addr="10.1.27.43" forwarded_for="8.29.198.26, 172.69.35.175" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Feedly/1.0 (+http://www.feedly.com/fetcher.html; 15 subscribers; like FeedFetcher-Google)" request_time="0.147" upstream_response_time="0.148" upstream_connect_time="0.000" upstream_header_time="0.140"; | 0.147 | GET /atom/links/ HTTP/1.1 | 200 | 63471148-c4d5-458d-a02a-bf2f738dbe5f | 10.1.27.43 | 8.29.198.26, 172.69.35.175 | http | 1.1 vegur | 16609 | - | Feedly/1.0 (+http://www.feedly.com/fetcher.html; 15 subscribers; like FeedFetcher-Google) | 0.147 | 0.148 | 0.0 | 0.14 |
| 73 | 73 | 2021-08-05T19:10:38.576473+00:00 app[web.1]: measure#nginx.service=0.136 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=13564551-d7e9-40ab-b2ce-20180333ee9d remote_addr="10.1.87.198" forwarded_for="92.247.181.12, 172.68.110.114" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="https://simonwillison.net/" user_agent="Mozilla/5.0 (compatible; inoreader.com; 9 subscribers)" request_time="0.136" upstream_response_time="0.136" upstream_connect_time="0.000" upstream_header_time="0.132"; | 0.136 | GET /atom/links/ HTTP/1.1 | 200 | 13564551-d7e9-40ab-b2ce-20180333ee9d | 10.1.87.198 | 92.247.181.12, 172.68.110.114 | http | 1.1 vegur | 16609 | https://simonwillison.net/ | Mozilla/5.0 (compatible; inoreader.com; 9 subscribers) | 0.136 | 0.136 | 0.0 | 0.132 |
| 67 | 67 | 2021-08-05T19:10:31.999210+00:00 app[web.1]: measure#nginx.service=0.124 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=633206fa-65ac-4091-937c-01f1cad74504 remote_addr="10.1.12.255" forwarded_for="2a01:e34:ec95:f440:44b3:beed:96e3:1fa6, 108.162.229.192" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="okhttp/4.9.1" request_time="0.124" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; | 0.124 | GET /atom/links/ HTTP/1.1 | 200 | 633206fa-65ac-4091-937c-01f1cad74504 | 10.1.12.255 | 2a01:e34:ec95:f440:44b3:beed:96e3:1fa6, 108.162.229.192 | http | 1.1 vegur | 16609 | - | okhttp/4.9.1 | 0.124 | 0.12 | 0.0 | 0.12 |
| 32 | 32 | 2021-08-05T19:09:35.248154+00:00 app[web.1]: measure#nginx.service=0.119 request="GET /atom/links/ HTTP/1.1" status_code=200 request_id=db74aa41-f5eb-459d-a190-840c9173397a remote_addr="10.1.58.55" forwarded_for="52.207.223.207, 172.70.34.134" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=16609 referer="-" user_agent="Slackbot 1.0 (+https://api.slack.com/robots)" request_time="0.119" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.116"; | 0.119 | GET /atom/links/ HTTP/1.1 | 200 | db74aa41-f5eb-459d-a190-840c9173397a | 10.1.58.55 | 52.207.223.207, 172.70.34.134 | http | 1.1 vegur | 16609 | - | Slackbot 1.0 (+https://api.slack.com/robots) | 0.119 | 0.12 | 0.0 | 0.116 |
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 );