The $v_hist_incomplete_queries view lists the queries that were not captured completely. The problem might be that there was a system reset at the time of logging or because some epilog/prolog is not loaded into the database yet.
Name | Description |
---|---|
npsid | A unique ID for the IBM® Netezza® system (This value is generated as a sequence on the target database where this view is defined.) |
npsinstanceid | The instance ID of the nzstart command for the source Netezza system |
opid | Operation ID, which is used as a foreign key from query epilog, overflow and plan, table, column access tables. |
logentryid | This ID and the NPS ID (npsid) and instance ID (npsinstanceid) form a foreign key into the hist_log_entry_n table. |
sessionid | The session ID (which is NULL for a failed authentication). |
dbname | The name of the database to which the session is connected. |
queryid | The unique checksum of the query. |
query | The first 8 KB of the query text. |
submittime | The time the query was submitted to Postgres. |
client_user_id | The user ID of the application that submitted the query. This field is available only in database version 3 or later. |
client_application_name | The name of the application that submitted the query associated with the plan. This value is specified for the session, and is usually set by an application. This field is available only in database version 3 or later. |
client_workstation_name | The host name of the workstation on which the application that submitted the query associated with the plan runs. This value is specified for the session, and is usually set by an application. This field is available only in database version 3 or later. |
client_accounting_string | The value of the accounting string. This value is specified for the session, and is usually set by an application. This field is available only in database version 3 or later. |