log
18 rows where user_agent = "Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" sorted by request_time descending
This data as json, CSV (advanced)
Suggested facets: status_code, forwarded_for, upstream_response_time, upstream_header_time
remote_addr ✖
- 10.1.7.130 3
- 10.1.3.226 2
- 10.1.63.160 2
- 10.1.94.69 2
- 10.1.14.97 1
- 10.1.18.241 1
- 10.1.27.43 1
- 10.1.29.75 1
- 10.1.48.192 1
- 10.1.55.92 1
- 10.1.58.55 1
- 10.1.87.198 1
- 10.1.92.174 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
441 | 441 | 2021-08-05T19:18:43.670499+00:00 app[web.1]: measure#nginx.service=18.878 request="GET /search/?tag=cassandra&tag=digg&tag=nosql HTTP/1.1" status_code=200 request_id=47bf3ddf-0b88-4e51-8f22-f1131304b056 remote_addr="10.1.94.69" forwarded_for="13.66.139.0, 162.158.107.218" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5385 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="18.878" upstream_response_time="18.876" upstream_connect_time="0.000" upstream_header_time="18.876"; | 18.878 | GET /search/?tag=cassandra&tag=digg&tag=nosql HTTP/1.1 | 200 | 47bf3ddf-0b88-4e51-8f22-f1131304b056 | 10.1.94.69 | 13.66.139.0, 162.158.107.218 | http | 1.1 vegur | 5385 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 18.878 | 18.876 | 0.0 | 18.876 |
332 | 332 | 2021-08-05T19:16:04.608658+00:00 app[web.1]: measure#nginx.service=4.577 request="GET /search/?page=1&tag=rails&tag=bbc HTTP/1.1" status_code=200 request_id=ec416683-a3da-4927-950d-678b7f4d4577 remote_addr="10.1.7.130" forwarded_for="13.66.139.0, 162.158.106.47" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5506 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="4.577" upstream_response_time="4.576" upstream_connect_time="0.000" upstream_header_time="4.576"; | 4.577 | GET /search/?page=1&tag=rails&tag=bbc HTTP/1.1 | 200 | ec416683-a3da-4927-950d-678b7f4d4577 | 10.1.7.130 | 13.66.139.0, 162.158.106.47 | http | 1.1 vegur | 5506 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 4.577 | 4.576 | 0.0 | 4.576 |
428 | 428 | 2021-08-05T19:18:14.071115+00:00 app[web.1]: measure#nginx.service=3.619 request="GET /2021/May/3/adding-geodjango-to-an-existing-django-project/ HTTP/1.1" status_code=200 request_id=acb1c2c5-04ff-4aa1-8335-852a3d6dc61c remote_addr="10.1.48.192" forwarded_for="40.77.167.103, 172.70.34.180" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=25363 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="3.619" upstream_response_time="3.616" upstream_connect_time="0.000" upstream_header_time="3.616"; | 3.619 | GET /2021/May/3/adding-geodjango-to-an-existing-django-project/ HTTP/1.1 | 200 | acb1c2c5-04ff-4aa1-8335-852a3d6dc61c | 10.1.48.192 | 40.77.167.103, 172.70.34.180 | http | 1.1 vegur | 25363 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 3.619 | 3.616 | 0.0 | 3.616 |
420 | 420 | 2021-08-05T19:18:00.937678+00:00 app[web.1]: measure#nginx.service=2.998 request="GET /search/?tag=charlesmiller&tag=macbookair&tag=apple&tag=ipodmini&page=1 HTTP/1.1" status_code=200 request_id=6cf4a3be-53e4-40eb-ab98-3d8464f331d1 remote_addr="10.1.55.92" forwarded_for="157.55.39.163, 162.158.107.221" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6372 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="2.998" upstream_response_time="2.996" upstream_connect_time="0.000" upstream_header_time="2.996"; | 2.998 | GET /search/?tag=charlesmiller&tag=macbookair&tag=apple&tag=ipodmini&page=1 HTTP/1.1 | 200 | 6cf4a3be-53e4-40eb-ab98-3d8464f331d1 | 10.1.55.92 | 157.55.39.163, 162.158.107.221 | http | 1.1 vegur | 6372 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 2.998 | 2.996 | 0.0 | 2.996 |
432 | 432 | 2021-08-05T19:18:16.996045+00:00 app[web.1]: measure#nginx.service=2.177 request="GET /tags/gis/ HTTP/1.1" status_code=200 request_id=4b2c19bb-4827-41b3-bef5-2d1d016ef24c remote_addr="10.1.87.198" forwarded_for="207.46.13.186, 108.162.246.141" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=25418 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="2.177" upstream_response_time="2.180" upstream_connect_time="0.000" upstream_header_time="2.180"; | 2.177 | GET /tags/gis/ HTTP/1.1 | 200 | 4b2c19bb-4827-41b3-bef5-2d1d016ef24c | 10.1.87.198 | 207.46.13.186, 108.162.246.141 | http | 1.1 vegur | 25418 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 2.177 | 2.18 | 0.0 | 2.18 |
224 | 224 | 2021-08-05T19:14:18.551893+00:00 app[web.1]: measure#nginx.service=1.980 request="GET /tags/projects/ HTTP/1.1" status_code=200 request_id=812b6003-2ed8-4984-b31f-9172da409c7d remote_addr="10.1.3.226" forwarded_for="207.46.13.87, 108.162.245.224" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=33823 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.980" upstream_response_time="1.980" upstream_connect_time="0.000" upstream_header_time="1.980"; | 1.98 | GET /tags/projects/ HTTP/1.1 | 200 | 812b6003-2ed8-4984-b31f-9172da409c7d | 10.1.3.226 | 207.46.13.87, 108.162.245.224 | http | 1.1 vegur | 33823 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 1.98 | 1.98 | 0.0 | 1.98 |
84 | 84 | 2021-08-05T19:10:49.320410+00:00 app[web.1]: measure#nginx.service=1.798 request="GET /2004/Jun/9/playing/ HTTP/1.1" status_code=200 request_id=0e33731f-9aed-4429-a2c9-e42193fb34b5 remote_addr="10.1.63.160" forwarded_for="207.46.13.98, 108.162.245.120" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=3628 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.798" upstream_response_time="1.800" upstream_connect_time="0.000" upstream_header_time="1.800"; | 1.798 | GET /2004/Jun/9/playing/ HTTP/1.1 | 200 | 0e33731f-9aed-4429-a2c9-e42193fb34b5 | 10.1.63.160 | 207.46.13.98, 108.162.245.120 | http | 1.1 vegur | 3628 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 1.798 | 1.8 | 0.0 | 1.8 |
6 | 6 | 2021-08-05T19:08:57.327840+00:00 app[web.1]: measure#nginx.service=1.625 request="GET /search/?page=3&tag=programming&tag=frontend&type=entry HTTP/1.1" status_code=404 request_id=6787c84f-1d25-405c-b659-39f87fc97ea2 remote_addr="10.1.94.69" forwarded_for="207.46.13.87, 108.162.246.91" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=179 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.625" upstream_response_time="1.628" upstream_connect_time="0.000" upstream_header_time="1.628"; | 1.625 | GET /search/?page=3&tag=programming&tag=frontend&type=entry HTTP/1.1 | 404 | 6787c84f-1d25-405c-b659-39f87fc97ea2 | 10.1.94.69 | 207.46.13.87, 108.162.246.91 | http | 1.1 vegur | 179 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 1.625 | 1.628 | 0.0 | 1.628 |
138 | 138 | 2021-08-05T19:12:11.898136+00:00 app[web.1]: measure#nginx.service=1.570 request="GET /2004/May/18/eurovision/ HTTP/1.1" status_code=200 request_id=fcdafe94-db39-400b-be1b-c5b9ed6c5da4 remote_addr="10.1.7.130" forwarded_for="157.55.39.144, 108.162.245.74" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=3348 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.570" upstream_response_time="1.572" upstream_connect_time="0.000" upstream_header_time="1.572"; | 1.57 | GET /2004/May/18/eurovision/ HTTP/1.1 | 200 | fcdafe94-db39-400b-be1b-c5b9ed6c5da4 | 10.1.7.130 | 157.55.39.144, 108.162.245.74 | http | 1.1 vegur | 3348 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 1.57 | 1.572 | 0.0 | 1.572 |
413 | 413 | 2021-08-05T19:17:50.781175+00:00 app[web.1]: measure#nginx.service=1.247 request="GET /search/?tag=fbml&tag=xfbml&tag=security HTTP/1.1" status_code=200 request_id=63ca0c3b-c93a-4871-b986-cff7fe7bc861 remote_addr="10.1.27.43" forwarded_for="13.66.139.0, 108.162.246.200" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6100 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="1.247" upstream_response_time="1.248" upstream_connect_time="0.000" upstream_header_time="1.248"; | 1.247 | GET /search/?tag=fbml&tag=xfbml&tag=security HTTP/1.1 | 200 | 63ca0c3b-c93a-4871-b986-cff7fe7bc861 | 10.1.27.43 | 13.66.139.0, 108.162.246.200 | http | 1.1 vegur | 6100 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 1.247 | 1.248 | 0.0 | 1.248 |
266 | 266 | 2021-08-05T19:15:17.393441+00:00 app[web.1]: measure#nginx.service=0.761 request="GET /search/?tag=foursquare&tag=yelp&tag=apis&page=1 HTTP/1.1" status_code=200 request_id=bb17f9f4-6338-44cd-b46a-a1c2314e1d1c remote_addr="10.1.29.75" forwarded_for="207.46.13.140, 108.162.246.54" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5922 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.761" upstream_response_time="0.760" upstream_connect_time="0.000" upstream_header_time="0.760"; | 0.761 | GET /search/?tag=foursquare&tag=yelp&tag=apis&page=1 HTTP/1.1 | 200 | bb17f9f4-6338-44cd-b46a-a1c2314e1d1c | 10.1.29.75 | 207.46.13.140, 108.162.246.54 | http | 1.1 vegur | 5922 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 0.761 | 0.76 | 0.0 | 0.76 |
86 | 86 | 2021-08-05T19:10:51.228055+00:00 app[web.1]: measure#nginx.service=0.657 request="GET /search/?page=1&tag=xml&tag=json&tag=javascript HTTP/1.1" status_code=200 request_id=d836b69d-ea45-4c9e-a177-d6076ae0a85e remote_addr="10.1.14.97" forwarded_for="207.46.13.98, 108.162.245.222" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=13640 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.657" upstream_response_time="0.660" upstream_connect_time="0.000" upstream_header_time="0.660"; | 0.657 | GET /search/?page=1&tag=xml&tag=json&tag=javascript HTTP/1.1 | 200 | d836b69d-ea45-4c9e-a177-d6076ae0a85e | 10.1.14.97 | 207.46.13.98, 108.162.245.222 | http | 1.1 vegur | 13640 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 0.657 | 0.66 | 0.0 | 0.66 |
17 | 17 | 2021-08-05T19:09:08.408724+00:00 app[web.1]: measure#nginx.service=0.656 request="GET /search/?tag=java&tag=jython&tag=jvm HTTP/1.1" status_code=200 request_id=99f3c17e-8e09-466e-a87d-d0915eb046ae remote_addr="10.1.58.55" forwarded_for="157.55.39.163, 108.162.246.159" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5350 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.656" upstream_response_time="0.656" upstream_connect_time="0.000" upstream_header_time="0.656"; | 0.656 | GET /search/?tag=java&tag=jython&tag=jvm HTTP/1.1 | 200 | 99f3c17e-8e09-466e-a87d-d0915eb046ae | 10.1.58.55 | 157.55.39.163, 108.162.246.159 | http | 1.1 vegur | 5350 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 0.656 | 0.656 | 0.0 | 0.656 |
133 | 133 | 2021-08-05T19:12:02.599372+00:00 app[web.1]: measure#nginx.service=0.277 request="GET /tags/recruiting/ HTTP/1.1" status_code=200 request_id=d5ad7faa-5191-4b13-8c5a-77f97a4fe930 remote_addr="10.1.7.130" forwarded_for="157.55.39.144, 108.162.246.139" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=11339 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.277" upstream_response_time="0.276" upstream_connect_time="0.000" upstream_header_time="0.276"; | 0.277 | GET /tags/recruiting/ HTTP/1.1 | 200 | d5ad7faa-5191-4b13-8c5a-77f97a4fe930 | 10.1.7.130 | 157.55.39.144, 108.162.246.139 | http | 1.1 vegur | 11339 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 0.277 | 0.276 | 0.0 | 0.276 |
418 | 418 | 2021-08-05T19:17:57.374104+00:00 app[web.1]: measure#nginx.service=0.275 request="GET /search/?tag=politics&tag=sql HTTP/1.1" status_code=200 request_id=aa7fede6-43b2-4479-a411-9957c79f0897 remote_addr="10.1.18.241" forwarded_for="157.55.39.163, 162.158.107.221" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5729 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.275" upstream_response_time="0.276" upstream_connect_time="0.000" upstream_header_time="0.276"; | 0.275 | GET /search/?tag=politics&tag=sql HTTP/1.1 | 200 | aa7fede6-43b2-4479-a411-9957c79f0897 | 10.1.18.241 | 157.55.39.163, 162.158.107.221 | http | 1.1 vegur | 5729 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 0.275 | 0.276 | 0.0 | 0.276 |
274 | 274 | 2021-08-05T19:15:25.162779+00:00 app[web.1]: measure#nginx.service=0.230 request="GET /search/?tag=ssh&tag=douglasbowman&year=2005 HTTP/1.1" status_code=200 request_id=89776c18-3dc3-40ce-8c58-e856f0dfcca5 remote_addr="10.1.3.226" forwarded_for="13.66.139.0, 108.162.246.8" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5654 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.230" upstream_response_time="0.228" upstream_connect_time="0.000" upstream_header_time="0.228"; | 0.23 | GET /search/?tag=ssh&tag=douglasbowman&year=2005 HTTP/1.1 | 200 | 89776c18-3dc3-40ce-8c58-e856f0dfcca5 | 10.1.3.226 | 13.66.139.0, 108.162.246.8 | http | 1.1 vegur | 5654 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 0.23 | 0.228 | 0.0 | 0.228 |
409 | 409 | 2021-08-05T19:17:45.063339+00:00 app[web.1]: measure#nginx.service=0.187 request="GET /search/?tag=softwareengineering&tag=programming&type=entry HTTP/1.1" status_code=200 request_id=605a080a-fc41-4d26-833b-6dff00be8a8c remote_addr="10.1.92.174" forwarded_for="207.46.13.87, 108.162.246.253" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=22686 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.187" upstream_response_time="0.184" upstream_connect_time="0.000" upstream_header_time="0.184"; | 0.187 | GET /search/?tag=softwareengineering&tag=programming&type=entry HTTP/1.1 | 200 | 605a080a-fc41-4d26-833b-6dff00be8a8c | 10.1.92.174 | 207.46.13.87, 108.162.246.253 | http | 1.1 vegur | 22686 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 0.187 | 0.184 | 0.0 | 0.184 |
16 | 16 | 2021-08-05T19:09:07.171562+00:00 app[web.1]: measure#nginx.service=0.148 request="GET /2020/May/22/ HTTP/1.1" status_code=200 request_id=568181f5-70f2-44bd-bdc2-2df2d245200e remote_addr="10.1.63.160" forwarded_for="157.55.39.163, 108.162.245.239" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7074 referer="-" user_agent="Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)" request_time="0.148" upstream_response_time="0.148" upstream_connect_time="0.000" upstream_header_time="0.148"; | 0.148 | GET /2020/May/22/ HTTP/1.1 | 200 | 568181f5-70f2-44bd-bdc2-2df2d245200e | 10.1.63.160 | 157.55.39.163, 108.162.245.239 | http | 1.1 vegur | 7074 | - | Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) | 0.148 | 0.148 | 0.0 | 0.148 |
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 );