log

35 rows where user_agent = "Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" sorted by request_time descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forwarded_for, body_bytes_sent

user_agent ✖

  • Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) · 35 ✖
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
443 443 2021-08-05T19:18:44.458707+00:00 app[web.1]: measure#nginx.service=15.178 request="GET /search/?tag=async&tag=promise&tag=node HTTP/1.1" status_code=200 request_id=03226b6d-1829-43ee-8b29-93bc72593258 remote_addr="10.1.57.54" forwarded_for="158.69.243.99, 172.70.126.92" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6052 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="15.178" upstream_response_time="15.176" upstream_connect_time="0.000" upstream_header_time="15.176"; 15.178 GET /search/?tag=async&tag=promise&tag=node HTTP/1.1 200 03226b6d-1829-43ee-8b29-93bc72593258 10.1.57.54 158.69.243.99, 172.70.126.92 http 1.1 vegur 6052 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 15.178 15.176 0.0 15.176
484 484 2021-08-05T19:19:46.277358+00:00 app[web.1]: measure#nginx.service=14.477 request="GET /search/?tag=async&tag=promise&tag=nodejs HTTP/1.1" status_code=200 request_id=7920cf74-7f1e-4327-9a31-5c9e43494063 remote_addr="10.1.31.190" forwarded_for="158.69.243.99, 172.70.126.166" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6082 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="14.477" upstream_response_time="14.476" upstream_connect_time="0.000" upstream_header_time="14.476"; 14.477 GET /search/?tag=async&tag=promise&tag=nodejs HTTP/1.1 200 7920cf74-7f1e-4327-9a31-5c9e43494063 10.1.31.190 158.69.243.99, 172.70.126.166 http 1.1 vegur 6082 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 14.477 14.476 0.0 14.476
453 453 2021-08-05T19:18:54.044727+00:00 app[web.1]: measure#nginx.service=13.893 request="GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=hashtables HTTP/1.1" status_code=200 request_id=2ea3056d-71b5-4643-822f-606514850dfe remote_addr="10.1.17.204" forwarded_for="167.114.100.201, 172.70.126.168" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6703 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="13.893" upstream_response_time="13.892" upstream_connect_time="0.000" upstream_header_time="13.892"; 13.893 GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=hashtables HTTP/1.1 200 2ea3056d-71b5-4643-822f-606514850dfe 10.1.17.204 167.114.100.201, 172.70.126.168 http 1.1 vegur 6703 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 13.893 13.892 0.0 13.892
476 476 2021-08-05T19:19:28.911115+00:00 app[web.1]: measure#nginx.service=11.179 request="GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=scaling HTTP/1.1" status_code=200 request_id=5d6248d0-b9e7-4e2c-8da8-237a4d1859d5 remote_addr="10.1.7.130" forwarded_for="167.114.100.201, 172.70.126.242" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6649 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="11.179" upstream_response_time="11.176" upstream_connect_time="0.000" upstream_header_time="11.176"; 11.179 GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=scaling HTTP/1.1 200 5d6248d0-b9e7-4e2c-8da8-237a4d1859d5 10.1.7.130 167.114.100.201, 172.70.126.242 http 1.1 vegur 6649 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 11.179 11.176 0.0 11.176
426 426 2021-08-05T19:18:13.647472+00:00 app[web.1]: measure#nginx.service=9.805 request="GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=databases HTTP/1.1" status_code=200 request_id=e5a8e3e9-139c-4ac1-9d10-e124e5b97dc7 remote_addr="10.1.55.92" forwarded_for="167.114.100.201, 172.70.126.2" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6685 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="9.805" upstream_response_time="9.808" upstream_connect_time="0.000" upstream_header_time="9.808"; 9.805 GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=databases HTTP/1.1 200 e5a8e3e9-139c-4ac1-9d10-e124e5b97dc7 10.1.55.92 167.114.100.201, 172.70.126.2 http 1.1 vegur 6685 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 9.805 9.808 0.0 9.808
337 337 2021-08-05T19:16:14.618817+00:00 app[web.1]: measure#nginx.service=9.135 request="GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=yarivsadan HTTP/1.1" status_code=200 request_id=c4c8d024-60d0-48d4-9a6f-9627c8d95c29 remote_addr="10.1.3.226" forwarded_for="167.114.100.201, 172.70.126.94" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6758 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="9.135" upstream_response_time="9.132" upstream_connect_time="0.000" upstream_header_time="9.132"; 9.135 GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=yarivsadan HTTP/1.1 200 c4c8d024-60d0-48d4-9a6f-9627c8d95c29 10.1.3.226 167.114.100.201, 172.70.126.94 http 1.1 vegur 6758 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 9.135 9.132 0.0 9.132
181 181 2021-08-05T19:13:24.787620+00:00 app[web.1]: measure#nginx.service=6.230 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&year=2007 HTTP/1.1" status_code=200 request_id=0e44a5f1-5852-42f3-8bab-aa90ed815ca8 remote_addr="10.1.7.130" forwarded_for="167.114.100.201, 172.70.126.42" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6787 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="6.230" upstream_response_time="6.232" upstream_connect_time="0.000" upstream_header_time="6.232"; 6.23 GET /search/?tag=amazon&tag=erlang&tag=simpledb&year=2007 HTTP/1.1 200 0e44a5f1-5852-42f3-8bab-aa90ed815ca8 10.1.7.130 167.114.100.201, 172.70.126.42 http 1.1 vegur 6787 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 6.23 6.232 0.0 6.232
366 366 2021-08-05T19:16:47.972280+00:00 app[web.1]: measure#nginx.service=5.333 request="GET /search/?tag=amazon&tag=erlang&tag=virtualisation&type=blogmark HTTP/1.1" status_code=200 request_id=c195d65a-a698-4f9b-84d0-60714fc7b718 remote_addr="10.1.18.241" forwarded_for="167.114.100.201, 172.70.126.242" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6745 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="5.333" upstream_response_time="5.332" upstream_connect_time="0.000" upstream_header_time="5.332"; 5.333 GET /search/?tag=amazon&tag=erlang&tag=virtualisation&type=blogmark HTTP/1.1 200 c195d65a-a698-4f9b-84d0-60714fc7b718 10.1.18.241 167.114.100.201, 172.70.126.242 http 1.1 vegur 6745 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 5.333 5.332 0.0 5.332
215 215 2021-08-05T19:14:08.821284+00:00 app[web.1]: measure#nginx.service=4.949 request="GET /search/?tag=async&tag=perlbal&tag=eventloop&tag=eventio HTTP/1.1" status_code=200 request_id=1fef589a-8905-4530-b148-f840473508bb remote_addr="10.1.7.130" forwarded_for="158.69.243.99, 172.70.127.9" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6652 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="4.949" upstream_response_time="4.948" upstream_connect_time="0.000" upstream_header_time="4.948"; 4.949 GET /search/?tag=async&tag=perlbal&tag=eventloop&tag=eventio HTTP/1.1 200 1fef589a-8905-4530-b148-f840473508bb 10.1.7.130 158.69.243.99, 172.70.127.9 http 1.1 vegur 6652 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 4.949 4.948 0.0 4.948
43 43 2021-08-05T19:09:55.466234+00:00 app[web.1]: measure#nginx.service=4.684 request="GET /search/?tag=async&tag=node&tag=recovered&tag=json HTTP/1.1" status_code=200 request_id=8f9822ee-d851-4d2b-964b-b0982ffb58c1 remote_addr="10.1.93.20" forwarded_for="158.69.243.99, 172.70.126.210" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6588 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="4.684" upstream_response_time="4.684" upstream_connect_time="0.000" upstream_header_time="4.684"; 4.684 GET /search/?tag=async&tag=node&tag=recovered&tag=json HTTP/1.1 200 8f9822ee-d851-4d2b-964b-b0982ffb58c1 10.1.93.20 158.69.243.99, 172.70.126.210 http 1.1 vegur 6588 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 4.684 4.684 0.0 4.684
134 134 2021-08-05T19:12:07.324230+00:00 app[web.1]: measure#nginx.service=4.266 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=webservices HTTP/1.1" status_code=200 request_id=f0ba19e0-6835-46a5-8ced-086ef5424162 remote_addr="10.1.58.55" forwarded_for="167.114.100.201, 172.70.126.32" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6667 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="4.266" upstream_response_time="4.268" upstream_connect_time="0.000" upstream_header_time="4.268"; 4.266 GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=webservices HTTP/1.1 200 f0ba19e0-6835-46a5-8ced-086ef5424162 10.1.58.55 167.114.100.201, 172.70.126.32 http 1.1 vegur 6667 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 4.266 4.268 0.0 4.268
116 116 2021-08-05T19:11:36.139211+00:00 app[web.1]: measure#nginx.service=3.370 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=schemaless HTTP/1.1" status_code=200 request_id=6eef5379-6c2a-45cd-ad65-cd0f162b95ec remote_addr="10.1.27.43" forwarded_for="167.114.100.201, 172.70.126.218" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6649 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="3.370" upstream_response_time="3.368" upstream_connect_time="0.000" upstream_header_time="3.368"; 3.37 GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=schemaless HTTP/1.1 200 6eef5379-6c2a-45cd-ad65-cd0f162b95ec 10.1.27.43 167.114.100.201, 172.70.126.218 http 1.1 vegur 6649 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 3.37 3.368 0.0 3.368
380 380 2021-08-05T19:17:05.814708+00:00 app[web.1]: measure#nginx.service=3.134 request="GET /search/?tag=async&tag=promise&tag=dojo HTTP/1.1" status_code=200 request_id=24695f47-3e19-4ac2-a15a-f6147bec4452 remote_addr="10.1.12.255" forwarded_for="158.69.243.99, 172.70.126.220" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6052 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="3.134" upstream_response_time="3.132" upstream_connect_time="0.000" upstream_header_time="3.132"; 3.134 GET /search/?tag=async&tag=promise&tag=dojo HTTP/1.1 200 24695f47-3e19-4ac2-a15a-f6147bec4452 10.1.12.255 158.69.243.99, 172.70.126.220 http 1.1 vegur 6052 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 3.134 3.132 0.0 3.132
9 9 2021-08-05T19:09:02.322673+00:00 app[web.1]: measure#nginx.service=3.104 request="GET /search/?tag=amazon&tag=erlang&tag=schemaless&year=2007 HTTP/1.1" status_code=200 request_id=0168f864-24cf-49de-9f8d-0f29663f3ec1 remote_addr="10.1.12.255" forwarded_for="167.114.100.201, 172.70.126.2" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6825 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="3.104" upstream_response_time="3.104" upstream_connect_time="0.000" upstream_header_time="3.104"; 3.104 GET /search/?tag=amazon&tag=erlang&tag=schemaless&year=2007 HTTP/1.1 200 0168f864-24cf-49de-9f8d-0f29663f3ec1 10.1.12.255 167.114.100.201, 172.70.126.2 http 1.1 vegur 6825 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 3.104 3.104 0.0 3.104
27 27 2021-08-05T19:09:30.007437+00:00 app[web.1]: measure#nginx.service=2.783 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=charlesying HTTP/1.1" status_code=200 request_id=337dda72-3914-43e6-b90e-20477ef30e2a remote_addr="10.1.54.152" forwarded_for="167.114.100.201, 172.70.126.130" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6667 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.783" upstream_response_time="2.784" upstream_connect_time="0.000" upstream_header_time="2.784"; 2.783 GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=charlesying HTTP/1.1 200 337dda72-3914-43e6-b90e-20477ef30e2a 10.1.54.152 167.114.100.201, 172.70.126.130 http 1.1 vegur 6667 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.783 2.784 0.0 2.784
213 213 2021-08-05T19:14:06.433031+00:00 app[web.1]: measure#nginx.service=2.713 request="GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=ec2 HTTP/1.1" status_code=200 request_id=07a147d5-f906-4e4f-ab81-19b8192fea7f remote_addr="10.1.18.241" forwarded_for="167.114.100.201, 172.70.126.218" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6632 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.713" upstream_response_time="2.712" upstream_connect_time="0.000" upstream_header_time="2.712"; 2.713 GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=ec2 HTTP/1.1 200 07a147d5-f906-4e4f-ab81-19b8192fea7f 10.1.18.241 167.114.100.201, 172.70.126.218 http 1.1 vegur 6632 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.713 2.712 0.0 2.712
248 248 2021-08-05T19:14:58.374146+00:00 app[web.1]: measure#nginx.service=2.454 request="GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=performance HTTP/1.1" status_code=200 request_id=70b7e4c8-a01c-4dec-8854-1f87b43a6290 remote_addr="10.1.54.152" forwarded_for="167.114.100.201, 172.70.127.7" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6776 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.454" upstream_response_time="2.452" upstream_connect_time="0.000" upstream_header_time="2.452"; 2.454 GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=performance HTTP/1.1 200 70b7e4c8-a01c-4dec-8854-1f87b43a6290 10.1.54.152 167.114.100.201, 172.70.127.7 http 1.1 vegur 6776 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.454 2.452 0.0 2.452
196 196 2021-08-05T19:13:42.520262+00:00 app[web.1]: measure#nginx.service=2.386 request="GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=benchmarks HTTP/1.1" status_code=200 request_id=cec3b56a-c36a-4da1-b9fa-ab0dd7f16717 remote_addr="10.1.87.198" forwarded_for="167.114.100.201, 172.70.126.104" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6758 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.386" upstream_response_time="2.388" upstream_connect_time="0.000" upstream_header_time="2.388"; 2.386 GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=benchmarks HTTP/1.1 200 cec3b56a-c36a-4da1-b9fa-ab0dd7f16717 10.1.87.198 167.114.100.201, 172.70.126.104 http 1.1 vegur 6758 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.386 2.388 0.0 2.388
3 3 2021-08-05T19:08:51.986277+00:00 app[web.1]: measure#nginx.service=2.385 request="GET /search/?tag=async&tag=node&tag=recovered&tag=jameshalliday HTTP/1.1" status_code=200 request_id=a7f9564a-3206-4f1a-b0d3-a1e9c49b1e54 remote_addr="10.1.58.55" forwarded_for="158.69.243.99, 172.70.126.14" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6732 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.385" upstream_response_time="2.384" upstream_connect_time="0.000" upstream_header_time="2.384"; 2.385 GET /search/?tag=async&tag=node&tag=recovered&tag=jameshalliday HTTP/1.1 200 a7f9564a-3206-4f1a-b0d3-a1e9c49b1e54 10.1.58.55 158.69.243.99, 172.70.126.14 http 1.1 vegur 6732 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.385 2.384 0.0 2.384
269 269 2021-08-05T19:15:19.296598+00:00 app[web.1]: measure#nginx.service=2.346 request="GET /search/?tag=async&tag=perlbal&tag=eventloop&tag=node HTTP/1.1" status_code=200 request_id=a6c80dcc-1120-40b8-bb5a-5b08a5b7176d remote_addr="10.1.17.204" forwarded_for="158.69.243.99, 172.70.126.68" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6601 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.346" upstream_response_time="2.347" upstream_connect_time="0.000" upstream_header_time="2.347"; 2.346 GET /search/?tag=async&tag=perlbal&tag=eventloop&tag=node HTTP/1.1 200 a6c80dcc-1120-40b8-bb5a-5b08a5b7176d 10.1.17.204 158.69.243.99, 172.70.126.68 http 1.1 vegur 6601 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.346 2.347 0.0 2.347
42 42 2021-08-05T19:09:52.780382+00:00 app[web.1]: measure#nginx.service=2.073 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=databases HTTP/1.1" status_code=200 request_id=b717566e-6a10-4122-aac2-2ba55dabbc1b remote_addr="10.1.55.92" forwarded_for="167.114.100.201, 172.70.126.150" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6631 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.073" upstream_response_time="2.072" upstream_connect_time="0.000" upstream_header_time="2.072"; 2.073 GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=databases HTTP/1.1 200 b717566e-6a10-4122-aac2-2ba55dabbc1b 10.1.55.92 167.114.100.201, 172.70.126.150 http 1.1 vegur 6631 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.073 2.072 0.0 2.072
85 85 2021-08-05T19:10:49.347841+00:00 app[web.1]: measure#nginx.service=2.025 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=scaling HTTP/1.1" status_code=200 request_id=b3d9c972-a9b2-4237-94cc-fd68e6582358 remote_addr="10.1.94.69" forwarded_for="167.114.100.201, 172.70.126.162" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6595 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="2.025" upstream_response_time="2.028" upstream_connect_time="0.000" upstream_header_time="2.028"; 2.025 GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=scaling HTTP/1.1 200 b3d9c972-a9b2-4237-94cc-fd68e6582358 10.1.94.69 167.114.100.201, 172.70.126.162 http 1.1 vegur 6595 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 2.025 2.028 0.0 2.028
403 403 2021-08-05T19:17:35.135172+00:00 app[web.1]: measure#nginx.service=1.999 request="GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=charlesying HTTP/1.1" status_code=200 request_id=f5b37724-d5aa-4c5a-af87-622165c20057 remote_addr="10.1.89.90" forwarded_for="167.114.100.201, 172.70.126.94" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6721 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="1.999" upstream_response_time="1.996" upstream_connect_time="0.000" upstream_header_time="1.996"; 1.999 GET /search/?tag=amazon&tag=erlang&tag=webservices&tag=charlesying HTTP/1.1 200 f5b37724-d5aa-4c5a-af87-622165c20057 10.1.89.90 167.114.100.201, 172.70.126.94 http 1.1 vegur 6721 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 1.999 1.996 0.0 1.996
57 57 2021-08-05T19:10:16.159569+00:00 app[web.1]: measure#nginx.service=1.732 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=hashtables HTTP/1.1" status_code=200 request_id=fd353f2d-e631-482b-8a0b-e0983e573064 remote_addr="10.1.94.69" forwarded_for="167.114.100.201, 172.70.126.232" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6649 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="1.732" upstream_response_time="1.732" upstream_connect_time="0.000" upstream_header_time="1.732"; 1.732 GET /search/?tag=amazon&tag=erlang&tag=simpledb&tag=hashtables HTTP/1.1 200 fd353f2d-e631-482b-8a0b-e0983e573064 10.1.94.69 167.114.100.201, 172.70.126.232 http 1.1 vegur 6649 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 1.732 1.732 0.0 1.732
282 282 2021-08-05T19:15:34.738291+00:00 app[web.1]: measure#nginx.service=1.332 request="GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=rails HTTP/1.1" status_code=200 request_id=9920fc18-c414-4a6d-a0bc-b85705f1bc93 remote_addr="10.1.14.97" forwarded_for="167.114.100.201, 172.70.126.184" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6668 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="1.332" upstream_response_time="1.332" upstream_connect_time="0.000" upstream_header_time="1.332"; 1.332 GET /search/?tag=amazon&tag=erlang&tag=virtualisation&tag=rails HTTP/1.1 200 9920fc18-c414-4a6d-a0bc-b85705f1bc93 10.1.14.97 167.114.100.201, 172.70.126.184 http 1.1 vegur 6668 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 1.332 1.332 0.0 1.332
347 347 2021-08-05T19:16:19.689561+00:00 app[web.1]: measure#nginx.service=1.019 request="GET /search/?tag=async&tag=postgresql&month=3&year=2018 HTTP/1.1" status_code=200 request_id=5f87b1ea-8db1-4f9e-a36f-c8e8765d458c remote_addr="10.1.31.190" forwarded_for="158.69.243.99, 172.70.126.84" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6132 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="1.019" upstream_response_time="1.020" upstream_connect_time="0.000" upstream_header_time="1.020"; 1.019 GET /search/?tag=async&tag=postgresql&month=3&year=2018 HTTP/1.1 200 5f87b1ea-8db1-4f9e-a36f-c8e8765d458c 10.1.31.190 158.69.243.99, 172.70.126.84 http 1.1 vegur 6132 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 1.019 1.02 0.0 1.02
407 407 2021-08-05T19:17:42.340815+00:00 app[web.1]: measure#nginx.service=0.744 request="GET /search/?tag=async&tag=promise&tag=javascript HTTP/1.1" status_code=200 request_id=0bb6f66d-e9d3-4c5f-a961-aa2dc18a3864 remote_addr="10.1.28.143" forwarded_for="158.69.243.99, 172.70.126.50" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6142 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.744" upstream_response_time="0.744" upstream_connect_time="0.000" upstream_header_time="0.744"; 0.744 GET /search/?tag=async&tag=promise&tag=javascript HTTP/1.1 200 0bb6f66d-e9d3-4c5f-a961-aa2dc18a3864 10.1.28.143 158.69.243.99, 172.70.126.50 http 1.1 vegur 6142 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.744 0.744 0.0 0.744
386 386 2021-08-05T19:17:10.219860+00:00 app[web.1]: measure#nginx.service=0.732 request="GET /search/?tag=amazon&tag=erlang&tag=virtualisation&year=2007 HTTP/1.1" status_code=200 request_id=bd647005-8432-4025-8438-7e6f3f802b2c remote_addr="10.1.31.190" forwarded_for="167.114.100.201, 172.70.126.108" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6902 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.732" upstream_response_time="0.732" upstream_connect_time="0.000" upstream_header_time="0.732"; 0.732 GET /search/?tag=amazon&tag=erlang&tag=virtualisation&year=2007 HTTP/1.1 200 bd647005-8432-4025-8438-7e6f3f802b2c 10.1.31.190 167.114.100.201, 172.70.126.108 http 1.1 vegur 6902 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.732 0.732 0.0 0.732
159 159 2021-08-05T19:12:45.209034+00:00 app[web.1]: measure#nginx.service=0.331 request="GET /search/?tag=amazon&tag=erlang&tag=simpledb&type=blogmark HTTP/1.1" status_code=200 request_id=960bf705-1853-4f35-95b3-9ac8626fc552 remote_addr="10.1.58.55" forwarded_for="167.114.100.201, 172.70.126.32" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6636 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.331" upstream_response_time="0.332" upstream_connect_time="0.000" upstream_header_time="0.332"; 0.331 GET /search/?tag=amazon&tag=erlang&tag=simpledb&type=blogmark HTTP/1.1 200 960bf705-1853-4f35-95b3-9ac8626fc552 10.1.58.55 167.114.100.201, 172.70.126.32 http 1.1 vegur 6636 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.331 0.332 0.0 0.332
130 130 2021-08-05T19:12:00.696759+00:00 app[web.1]: measure#nginx.service=0.318 request="GET /search/?tag=async&tag=performance HTTP/1.1" status_code=200 request_id=d71a7b24-7d0b-4dc6-b985-b6f3f9bccb06 remote_addr="10.1.28.143" forwarded_for="158.69.243.99, 172.70.126.188" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5739 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.318" upstream_response_time="0.320" upstream_connect_time="0.000" upstream_header_time="0.320"; 0.318 GET /search/?tag=async&tag=performance HTTP/1.1 200 d71a7b24-7d0b-4dc6-b985-b6f3f9bccb06 10.1.28.143 158.69.243.99, 172.70.126.188 http 1.1 vegur 5739 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.318 0.32 0.0 0.32
154 154 2021-08-05T19:12:38.291955+00:00 app[web.1]: measure#nginx.service=0.279 request="GET /search/?tag=async&tag=perlbal HTTP/1.1" status_code=200 request_id=02f1c764-66be-4ca2-ade9-6f7d691489b4 remote_addr="10.1.3.226" forwarded_for="158.69.243.99, 172.70.126.134" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=5776 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.279" upstream_response_time="0.280" upstream_connect_time="0.000" upstream_header_time="0.280"; 0.279 GET /search/?tag=async&tag=perlbal HTTP/1.1 200 02f1c764-66be-4ca2-ade9-6f7d691489b4 10.1.3.226 158.69.243.99, 172.70.126.134 http 1.1 vegur 5776 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.279 0.28 0.0 0.28
186 186 2021-08-05T19:13:28.764560+00:00 app[web.1]: measure#nginx.service=0.272 request="GET /search/?tag=async&tag=perlbal&tag=eventio&type=blogmark HTTP/1.1" status_code=200 request_id=679e0514-87a6-4496-b2b3-f5d8e6e2db90 remote_addr="10.1.28.143" forwarded_for="158.69.243.99, 172.70.126.214" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6657 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.272" upstream_response_time="0.272" upstream_connect_time="0.000" upstream_header_time="0.272"; 0.272 GET /search/?tag=async&tag=perlbal&tag=eventio&type=blogmark HTTP/1.1 200 679e0514-87a6-4496-b2b3-f5d8e6e2db90 10.1.28.143 158.69.243.99, 172.70.126.214 http 1.1 vegur 6657 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.272 0.272 0.0 0.272
94 94 2021-08-05T19:10:59.201248+00:00 app[web.1]: measure#nginx.service=0.214 request="GET /search/?tag=async&tag=nosql HTTP/1.1" status_code=200 request_id=930720c7-32b7-4a37-87be-a6871289fe4f remote_addr="10.1.87.198" forwarded_for="158.69.243.99, 172.70.126.6" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=7002 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.214" upstream_response_time="0.212" upstream_connect_time="0.000" upstream_header_time="0.212"; 0.214 GET /search/?tag=async&tag=nosql HTTP/1.1 200 930720c7-32b7-4a37-87be-a6871289fe4f 10.1.87.198 158.69.243.99, 172.70.126.6 http 1.1 vegur 7002 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.214 0.212 0.0 0.212
61 61 2021-08-05T19:10:20.232225+00:00 app[web.1]: measure#nginx.service=0.133 request="GET /search/?tag=async&tag=node&year=2009&type=blogmark HTTP/1.1" status_code=200 request_id=6a776afb-83a2-48da-a41c-6b82d8c35aab remote_addr="10.1.57.54" forwarded_for="158.69.243.99, 172.70.126.2" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6798 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.133" upstream_response_time="0.132" upstream_connect_time="0.000" upstream_header_time="0.132"; 0.133 GET /search/?tag=async&tag=node&year=2009&type=blogmark HTTP/1.1 200 6a776afb-83a2-48da-a41c-6b82d8c35aab 10.1.57.54 158.69.243.99, 172.70.126.2 http 1.1 vegur 6798 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.133 0.132 0.0 0.132
113 113 2021-08-05T19:11:31.607555+00:00 app[web.1]: measure#nginx.service=0.119 request="GET /search/?tag=async&tag=orbited HTTP/1.1" status_code=200 request_id=1afa15ed-4c40-4530-ab5c-9edf817346c2 remote_addr="10.1.58.55" forwarded_for="158.69.243.99, 172.70.127.11" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=6025 referer="-" user_agent="Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)" request_time="0.119" upstream_response_time="0.120" upstream_connect_time="0.000" upstream_header_time="0.120"; 0.119 GET /search/?tag=async&tag=orbited HTTP/1.1 200 1afa15ed-4c40-4530-ab5c-9edf817346c2 10.1.58.55 158.69.243.99, 172.70.127.11 http 1.1 vegur 6025 - Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/) 0.119 0.12 0.0 0.12

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