1 row where referer = "http://popsmart.cn/Build/Cesium/Cesium.js" sorted by upstream_connect_time

View and edit SQL

status_code

referer

  • http://popsmart.cn/Build/Cesium/Cesium.js · 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
103 2021-08-05T19:11:15.963362+00:00 app[web.1]: measure#nginx.service=0.522 request="GET / HTTP/1.1" status_code=200 request_id=ef823985-b58b-4129-894d-3388768c1a56 remote_addr="10.1.55.92" forwarded_for="122.228.19.71, 172.69.35.208" forwarded_proto="http" via="1.1 vegur" body_bytes_sent=108578 referer="http://popsmart.cn/Build/Cesium/Cesium.js" user_agent="Baiduspider+(+http://www.baidu.com/search/spider.htm)" request_time="0.522" upstream_response_time="0.524" upstream_connect_time="0.000" upstream_header_time="0.520"; 0.522 GET / HTTP/1.1 200 ef823985-b58b-4129-894d-3388768c1a56 10.1.55.92 122.228.19.71, 172.69.35.208 http 1.1 vegur 108578 http://popsmart.cn/Build/Cesium/Cesium.js Baiduspider+(+http://www.baidu.com/search/spider.htm) 0.522 0.524 0.0 0.52

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