Contains the data provided by FusionReactor request log files. FusionReactor for FusionAnalytics uses this table as a temporary table. Entries are consumed by the Update Request Status job which creates data in the REQUEST_STATUS, REQUEST_AMF, REQUEST_PARAM and REQUEST_URL tables.
| Column Name | Data Type | Unique | Nullable | Description |
|---|---|---|---|---|
| ID | bigint | x | The primary key column | |
| SERVER | smallint | The server ID as stored in the ServerMap | ||
| DT | bigint | The number of milliseconds since the epoch. Timezone adjustments can be made with the timezone attribute of the DataCollector that provided the data. | ||
| VERSION | smallint | The version of the log files being imported. | ||
| SRVSTARTTS | bigint | The time (in milliseconds since the epoch) that the server last came online. | ||
| REQID | bigint | The FusionReactor request id. | ||
| REQSTATUS | varchar(30) | The current state of the request. This will tell you if a request has started, finished, was killed, queued, etc... | ||
| CPREASON | varchar(30) | x | The reason given by Crash Protection for the current action. | |
| THREADID | varchar(35) | The name of the thread responsible for responding to this request. | ||
| CLIENTIP | varchar(39) | The IP address of the machine making the request. | ||
| REQMETHOD | varchar(20) | This will usually be "GET" or "POST" | ||
| REQURL | varchar(2048) | This is the requested URL. The format of this column will change depending on URL Format key which can be found on the Request Settings page. | ||
| REQPATH | varchar(256) | The path for the request, following the domain. | ||
| EXECTIME | bigint | The request execution time. | ||
| MEM_PCT | real | The amount of memory (expressed as a percentage) which was used when this request started or finished. | ||
| MEM_MAX | bigint | The total amount of physical memory available to this instance. | ||
| MEM_USED | bigint | The amount of memory which was used when this request started or finished. | ||
| MEM_TOTAL | bigint | The amount of memory which was allocated by the instance when this request started or finished. | ||
| MEM_FREE | bigint | The amount of free memory (within the allocated block) when this request started or finished. | ||
| QUERYSTRING | varchar(4096) | If the URL has any parameters then they will appear here. | ||
| STATUSCODE | smallint | This is a HTTP return code such as 200 (OK,) 404 (Not found,) or 500 (Internal Server Error.) For "Started:" rows this column will be 200. | ||
| CPUTIME | bigint | This is the amount of actual CPU time which this request required. (For incomplete requests, this column will be 0.) | ||
| AMFREQUEST | varchar(1024) | x | If AMF decoding is enabled (Request Settings) and there is AMF to decode, then the method names will appear here. | |
| JSESSIONID | varchar(100) | x | The J2EE Session Id for this request. | |
| CFID | varchar(50) | x | The CF Id for this request. | |
| CFTOKEN | varchar(70) | x | The CFTOKEN for this request. | |
| JDBC_QUERY_COUNT | bigint | The number of JDBC queries run by this request at the time of this log. | ||
| JDBC_TOTAL_TIME | bigint | The total amount of time spent running JDBC queries at the time of this log. | ||
| JDBC_TOTAL_EXECTIME | bigint | The total amount of time spent by the database running JDBC queries at the time of this log. | ||
| JDBC_TOTAL_ROWS | bigint | The total number of rows returned by JDBC queries at the time of this log. | ||
| BYTES | bigint | The amount of data which was sent back to the client. | ||
| TTFB | bigint | The number of milliseconds it took to deliver the first bit of data. | ||
| TTLB | bigint | The number of milliseconds it took to deliver the complete content. | ||
| STREAM_OPEN | bigint | The number of milliseconds before the data stream was opened. | ||
| STREAM_CLOSED | bigint | The number of milliseconds until the completed data stream was closed. |