DIRECTED_QUERY_STATUS
Returns information about execution of directed queries.
Returns information about executions of directed queries.
| Column Name | Data Type | Description |
|---|---|---|
| NODE_NAME | VARCHAR | Node on which the directed query ran. |
| OID | INTEGER | Unique numeric ID assigned by the Vertica catalog, which identifies the specific directed query. |
| QUERY_NAME | VARCHAR | Directed query's unique identifier, used by statements such as ACTIVATE DIRECTED QUERY. |
| DIGEST | INTEGER | Hash of the saved query plan data, used by the optimizer to map identical input queries to the same active directed query. |
| HITS | INTEGER | Number of times this query has been executed since the last reset. Use CLEAR_DIRECTED_QUERY_USAGE to reset this counter to 0. |