IBM PureData System for Analytics, Version 7.1

$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 IBM® Netezza® 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 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 that are affected by the SQL query. Applicable for select, insert, update, delete, and CTAS queries. The result rows in the plan epilog are internal to Netezza and specifies the number that the plan returns to the query.
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.