Contains the data provided by the Update Request Status job. This job consumes data from the REQUEST table and creates entries 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 | |
| REQUEST_ID | bigint | x | The ID for the request | |
| SERVER | smallint | The server ID as stored in the ServerMap | ||
| SRVSTARTTS | bigint | The time (in milliseconds since the epoch) that the server last came online. | ||
| REQID | bigint | The actual request ID from FusionReactor | ||
| REQSTATUS | varchar(30) | x | The status of the request | |
| EXECUTED | bigint | x | The datetime (in milliseconds since the epoch) that the request was executed. | |
| COMPLETED | bigint | x | The datetime (in milliseconds since the epoch) that the request completed. | |
| QUEUED | bigint | x | Indicates whether the request was queued. | |
| ABORTED | bigint | x | Indicates whether the request was aborted. | |
| ORPHANED | bigint | x | Indicates whether the request was orphaned. | |
| REQREJECTED | bigint | x | Indicates whether the request was rejected. | |
| STARTED | bigint | x | The datetime (in milliseconds since the epoch) that the request started. | |
| FINISHED | bigint | x | The datetime (in milliseconds since the epoch) that the request finished. | |
| LIFETIME | bigint | x | A calculated value representing the lifetime of the request. | |
| VERSION | smallint | x | The version of the request_status log file being imported. | |
| CPREASON | varchar(30) | x | If this request was subject to Crash Protection, this is the reason why. | |
| THREADID | varchar(35) | x | The ID of the request thread. | |
| CLIENTIP | varchar(39) | x | The IP of the FR client. | |
| REQMETHOD | varchar(20) | x | Indicates whether the request was GET or POST. | |
| REQURL | varchar(2048) | x | The full URL of the request. | |
| REQPATH | varchar(256) | x | The request path following the url and port. | |
| EXECTIME | bigint | x | The request execution time. | |
| MEM_PCT | real | x | The percentage of memory used when the request ran. | |
| MEM_MAX | bigint | x | The total amount of physical memory available to this instance. | |
| MEM_USED | bigint | x | The amount of used memory. | |
| MEM_TOTAL | bigint | x | The amount of allocated memory. | |
| MEM_FREE | bigint | x | The amount of free memory (within the allocated block) | |
| QUERYSTRING | varchar(4096) | x | The post data, if any, for the request. | |
| STATUSCODE | smallint | x | The HTTP return code for the request. | |
| CPUTIME | bigint | x | This is the amount of CPU time used by CF since the last CPU value was measured. It is expressed as a percentage of the total CPU time (across all CPU cores) that was available during that period. | |
| 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 request CFID. | |
| CFTOKEN | varchar(70) | x | The request CD token. | |
| JDBC_QUERY_COUNT | bigint | x | The number of JDBC queries run from this query. | |
| JDBC_TOTAL_TIME | bigint | x | The total JDBC query time. | |
| JDBC_TOTAL_EXECTIME | bigint | x | The total JDBC execution time. | |
| JDBC_TOTAL_ROWS | bigint | x | The total rows returned by the JDBC query. | |
| BYTES | bigint | x | The amount of data which was sent back to the client. | |
| TTFB | bigint | x | The number of milliseconds it took to deliver the first bit of data. | |
| TTLB | bigint | x | The number of milliseconds it took to deliver the complete content. | |
| STREAM_OPEN | bigint | x | The number of milliseconds before the data stream was opened. | |
| STREAM_CLOSED | bigint | x | The number of milliseconds until the completed data stream was closed. |