$hist_plan_prolog_n
The $hist_plan_prolog_n table records the plan history information. This data is collected at the beginning of the plan execution. This table becomes enabled whenever history type is Plan.
| Name | Type | Description |
|---|---|---|
| npsid | integer | This value along with the instance ID (npsInstanceId) and operation ID (opid) form the foreign key into the query table. |
| npsinstanceid | integer | Instance ID of the source system. |
| opid | bigint | Operation ID. Used as a foreign key from query epilog, overflow and plan, table, column access tables to query prolog. |
| logentryid | bigint | This ID is a foreign key into the hist_log_entry_n table with the NPS ID (npsid) and instance ID (npsinstanceid). This ID with npsid and npsinstanceid is also a primary key for this table. |
| sessionid | bigint | Session ID. This ID, together with the NPS ID (npsid) and instance ID (npsinstanceid) form the foreign key from query, plan, table, and column access tables into session tables. |
| planid | integer | Plan ID. This is used to make an equi join in addition to NPS ID (npsid), instance ID (npsinstanceid), and operation ID (opid) to match a plan prolog to a plan epilog record. |
| xid | bigint | DBOS transaction ID. |
| gkpriority | integer | This field is deprecated and is no longer used. |
| submittime | timestamp | Submit time of the plan. |
| queuetime | timestamp | This field is deprecated and is no longer used. |
| preptime | timestamp | Date and time when the first snippet is prepared. |
| gratime | timestamp | Time when the plan is queued to GRA. |
| starttime | Start time of plan execution. | |
| ismainplan | Flag for the main plan of a query. | |
| estimatedcost | The estimated cost of the plan. | |
| estimateddisk | bigint | The estimated disk space of the plan. |
| estimatedmem | bigint | The estimated memory of the plan. |
| totalsnippets | integer | The total number of snippets. |
| signature | bigint | The signature of the plan, which is stored as a checksum value. If two plans have the same signature, especially for the same query, the plans are most likely identical. |
| qcrestart | integer | The count of query restart after a state change. The value is zero if a restart has not occurred. |
| tzoffset | integer | The timezone offset in minutes. This field is available only in database version 2 or later. |