$hist_query_epilog_n

The $hist_query_epilog_n table contains the final data that is collected at the end of the query.

Table 1. $hist_query_epilog_n
Name Type Description
npsid integer NPS ID. This ID and the instance ID (npsinstanceid) and operation ID (opid) form the foreign key into the operation table.
npsinstanceid integer Instance ID of the source system.
opid bigint Operation ID. This ID is used as a foreign key from query epilog, overflow and plan, table, column access tables to query prolog.
logentryid bigint This ID and the NPS ID (npsid) and instance ID (npsinstanceid) form:
  • A foreign key into the hist_log_entry_n table
  • A primary key for this table
sessionid bigint Netezza Performance Server session ID. This ID and the NPS ID (npsid) and instance ID (npsinstanceid) form the foreign key from query, plan, table, and column access tables into session tables.
finishtime timestamp The GMT time when the query finished.
resultrows bigint The number of rows affected by the SQL query. This field shows the row count for SELECT, INSERT, UPDATE, DELETE, and CTAS queries on user tables, and SELECT, INSERT, UPDATE, and DELETE queries on system tables or bridge queries. For all other queries, the value is 0.
status integer Completion status of the query:
0
QUERY_EXECUTION_SUCCESS. Query executed successfully.
-1
QUERY_ABORTED. Query execution aborted. nzsession abort or SIGTERM.
-2
QUERY_CANCELLED. Query canceled by the user who is using Control-C. This is recorded in QueryCancelHandler() (postgres.c).
-3
QUERY_FAILED_PARSING. Query failed with parsing error.
-4
QUERY_FAILED_REWRITE. Query failed during Postgres rewrite.
-5
QUERY_FAILED_PLANNING. Query failed during planning.
-6
QUERY_FAILED_EXECUTION. Query failed during execution.
-7
Reserved for future use.
-8
QUERY_FAILED_ACLCHECK. Query failed ACL check.
-9
QUERY_FAILED_GENERIC. Query failed by other generic errors.
tzoffset integer The timezone offset in minutes. This field is available only in database version 2 or later.