log
11 rows where body_bytes_sent = 207454 sorted by request_time descending
This data as json, CSV (advanced)
Suggested facets: remote_addr, forwarded_for, user_agent
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 465 | 465 | 2021-08-05T19:19:16.524671+00:00 app[web.1]: measure#nginx.service=17.435 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=ed598f4f-a2dd-43f0-b42f-683163a1f241 remote_addr="10.1.28.143" forwarded_for="94.130.182.203, 162.158.88.113" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app)" request_time="17.435" upstream_response_time="17.436" upstream_connect_time="0.000" upstream_header_time="17.432"; | 17.435 | GET /atom/entries/ HTTP/1.1 | 200 | ed598f4f-a2dd-43f0-b42f-683163a1f241 | 10.1.28.143 | 94.130.182.203, 162.158.88.113 | http | 1.1 vegur | 207454 | - | Mozilla/5.0 (compatible; Miniflux/2.0.31; +https://miniflux.app) | 17.435 | 17.436 | 0.0 | 17.432 |
| 450 | 450 | 2021-08-05T19:18:53.150609+00:00 app[web.1]: measure#nginx.service=11.058 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=e47d692a-32c2-469b-ab6f-ac5768dfdb5d remote_addr="10.1.7.41" forwarded_for="167.71.89.133, 172.70.110.171" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6; +feeder.co) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36" request_time="11.058" upstream_response_time="11.056" upstream_connect_time="0.000" upstream_header_time="11.052"; | 11.058 | GET /atom/entries/ HTTP/1.1 | 200 | e47d692a-32c2-469b-ab6f-ac5768dfdb5d | 10.1.7.41 | 167.71.89.133, 172.70.110.171 | http | 1.1 vegur | 207454 | - | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6; +feeder.co) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36 | 11.058 | 11.056 | 0.0 | 11.052 |
| 339 | 339 | 2021-08-05T19:16:14.922155+00:00 app[web.1]: measure#nginx.service=6.673 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=20b4bbd1-ddc3-4b66-b249-fa66615c2271 remote_addr="10.1.28.143" forwarded_for="8.29.198.27, 172.70.98.91" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Feedly/1.0 (+http://www.feedly.com/fetcher.html; 593 subscribers; like FeedFetcher-Google)" request_time="6.673" upstream_response_time="6.672" upstream_connect_time="0.000" upstream_header_time="6.668"; | 6.673 | GET /atom/entries/ HTTP/1.1 | 200 | 20b4bbd1-ddc3-4b66-b249-fa66615c2271 | 10.1.28.143 | 8.29.198.27, 172.70.98.91 | http | 1.1 vegur | 207454 | - | Feedly/1.0 (+http://www.feedly.com/fetcher.html; 593 subscribers; like FeedFetcher-Google) | 6.673 | 6.672 | 0.0 | 6.668 |
| 344 | 344 | 2021-08-05T19:16:18.664847+00:00 app[web.1]: measure#nginx.service=4.332 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=a9b86ae5-8dd3-43b1-afc3-bfd83ecab6c2 remote_addr="10.1.57.54" forwarded_for="8.29.198.26, 172.70.98.90" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Feedly/1.0 (+http://www.feedly.com/fetcher.html; 34 subscribers; like FeedFetcher-Google)" request_time="4.332" upstream_response_time="4.332" upstream_connect_time="0.000" upstream_header_time="4.328"; | 4.332 | GET /atom/entries/ HTTP/1.1 | 200 | a9b86ae5-8dd3-43b1-afc3-bfd83ecab6c2 | 10.1.57.54 | 8.29.198.26, 172.70.98.90 | http | 1.1 vegur | 207454 | - | Feedly/1.0 (+http://www.feedly.com/fetcher.html; 34 subscribers; like FeedFetcher-Google) | 4.332 | 4.332 | 0.0 | 4.328 |
| 431 | 431 | 2021-08-05T19:18:16.717383+00:00 app[web.1]: measure#nginx.service=2.547 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=2199d195-af33-4ff5-a7f2-cd7d65bc8ec7 remote_addr="10.1.7.130" forwarded_for="20.186.4.103, 173.245.54.244" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="feedparser/6.0.8 +https://github.com/kurtmckee/feedparser/" request_time="2.547" upstream_response_time="2.548" upstream_connect_time="0.000" upstream_header_time="2.544"; | 2.547 | GET /atom/entries/ HTTP/1.1 | 200 | 2199d195-af33-4ff5-a7f2-cd7d65bc8ec7 | 10.1.7.130 | 20.186.4.103, 173.245.54.244 | http | 1.1 vegur | 207454 | - | feedparser/6.0.8 +https://github.com/kurtmckee/feedparser/ | 2.547 | 2.548 | 0.0 | 2.544 |
| 58 | 58 | 2021-08-05T19:10:16.201577+00:00 app[web.1]: measure#nginx.service=0.412 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=df196517-b529-4bce-8fae-fbe8611b55a3 remote_addr="10.1.93.20" forwarded_for="80.241.215.228, 162.158.88.112" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Tiny Tiny RSS/18.12 (http://tt-rss.org/)" request_time="0.412" upstream_response_time="0.412" upstream_connect_time="0.000" upstream_header_time="0.408"; | 0.412 | GET /atom/entries/ HTTP/1.1 | 200 | df196517-b529-4bce-8fae-fbe8611b55a3 | 10.1.93.20 | 80.241.215.228, 162.158.88.112 | http | 1.1 vegur | 207454 | - | Tiny Tiny RSS/18.12 (http://tt-rss.org/) | 0.412 | 0.412 | 0.0 | 0.408 |
| 287 | 287 | 2021-08-05T19:15:41.092319+00:00 app[web.1]: measure#nginx.service=0.185 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=e0cbfac4-bb53-4711-8e5d-23f1c54544b0 remote_addr="10.1.28.143" forwarded_for="108.2.161.198, 172.70.110.171" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="NetNewsWire (RSS Reader; https://netnewswire.com/)" request_time="0.185" upstream_response_time="0.184" upstream_connect_time="0.000" upstream_header_time="0.180"; | 0.185 | GET /atom/entries/ HTTP/1.1 | 200 | e0cbfac4-bb53-4711-8e5d-23f1c54544b0 | 10.1.28.143 | 108.2.161.198, 172.70.110.171 | http | 1.1 vegur | 207454 | - | NetNewsWire (RSS Reader; https://netnewswire.com/) | 0.185 | 0.184 | 0.0 | 0.18 |
| 129 | 129 | 2021-08-05T19:11:59.597446+00:00 app[web.1]: measure#nginx.service=0.103 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=df86a669-dd29-4dc9-a281-2737b73ad7c6 remote_addr="10.1.48.192" forwarded_for="64.71.157.102, 172.70.98.90" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Feedbin feed-id:1347571 - 20 subscribers" request_time="0.103" upstream_response_time="0.104" upstream_connect_time="0.000" upstream_header_time="0.100"; | 0.103 | GET /atom/entries/ HTTP/1.1 | 200 | df86a669-dd29-4dc9-a281-2737b73ad7c6 | 10.1.48.192 | 64.71.157.102, 172.70.98.90 | http | 1.1 vegur | 207454 | - | Feedbin feed-id:1347571 - 20 subscribers | 0.103 | 0.104 | 0.0 | 0.1 |
| 14 | 14 | 2021-08-05T19:09:05.833965+00:00 app[web.1]: measure#nginx.service=0.098 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=56d1fcd0-cff3-41ea-9635-ba3ee20ad153 remote_addr="10.1.29.75" forwarded_for="8.29.198.26, 172.70.98.90" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Feedly/1.0 (+http://www.feedly.com/fetcher.html; 34 subscribers; like FeedFetcher-Google)" request_time="0.098" upstream_response_time="0.096" upstream_connect_time="0.000" upstream_header_time="0.092"; | 0.098 | GET /atom/entries/ HTTP/1.1 | 200 | 56d1fcd0-cff3-41ea-9635-ba3ee20ad153 | 10.1.29.75 | 8.29.198.26, 172.70.98.90 | http | 1.1 vegur | 207454 | - | Feedly/1.0 (+http://www.feedly.com/fetcher.html; 34 subscribers; like FeedFetcher-Google) | 0.098 | 0.096 | 0.0 | 0.092 |
| 290 | 290 | 2021-08-05T19:15:45.623815+00:00 app[web.1]: measure#nginx.service=0.092 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=44a6fe23-dda9-41f4-9741-4a455bbbdaf0 remote_addr="10.1.31.190" forwarded_for="103.137.15.20, 172.69.162.147" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Reeder/5000.79.04 CFNetwork/1240.0.4 Darwin/20.6.0" request_time="0.092" upstream_response_time="0.092" upstream_connect_time="0.000" upstream_header_time="0.088"; | 0.092 | GET /atom/entries/ HTTP/1.1 | 200 | 44a6fe23-dda9-41f4-9741-4a455bbbdaf0 | 10.1.31.190 | 103.137.15.20, 172.69.162.147 | http | 1.1 vegur | 207454 | - | Reeder/5000.79.04 CFNetwork/1240.0.4 Darwin/20.6.0 | 0.092 | 0.092 | 0.0 | 0.088 |
| 271 | 271 | 2021-08-05T19:15:21.474648+00:00 app[web.1]: measure#nginx.service=0.079 request="GET /atom/entries/ HTTP/1.1" status_code=200 request_id=9627c1e1-bdcc-4ee2-9771-cd4c9724387e remote_addr="10.1.57.54" forwarded_for="45.79.29.55, 172.69.70.125" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=207454 referer="-" user_agent="Mozilla/5.0 (compatible; BazQux/2.4; +https://bazqux.com/fetcher; 3 subscribers)" request_time="0.079" upstream_response_time="0.076" upstream_connect_time="0.000" upstream_header_time="0.072"; | 0.079 | GET /atom/entries/ HTTP/1.1 | 200 | 9627c1e1-bdcc-4ee2-9771-cd4c9724387e | 10.1.57.54 | 45.79.29.55, 172.69.70.125 | http | 1.1 vegur | 207454 | - | Mozilla/5.0 (compatible; BazQux/2.4; +https://bazqux.com/fetcher; 3 subscribers) | 0.079 | 0.076 | 0.0 | 0.072 |
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 );