A history database provides views that users can use to access a subset of the history data. These views have names of the form $v_hist_* (for query history data) or $v_sig_hist_* (for audit history data). Users can access the remaining history data directly in the history tables. These tables have names of the form $hist_*.
Description | View or table | View for audit history data |
---|---|---|
The names of all columns, collected during table access. | $v_hist_column_access_stats | |
Queries that were not captured completely. | $v_hist_incomplete_queries | |
Information about events that occurred. | $v_hist_log_events | |
Information about completed queries. | $v_hist_queries | |
The same information as in $v_hist_queries, but only for successful queries. | $v_hist_successful_queries | |
The names of all the tables that are captured in table access | $v_hist_table_access_stats | |
The same information as in $v_hist_queries, but only for unsuccessful queries. | $v_hist_unsuccessful_queries | |
The column access history for a query. | $hist_column_access_n | $v_sig_hist_column_access_n |
The failed authentication attempts for every authenticated operation. | $hist_failed_authentication_n | $v_sig_hist_failed_authentication_n |
The log entries for all history operations. | $hist_log_entry_n | $v_sig_hist_log_entry_n |
The systems that story history data in the history database. | $hist_nps_n | |
Plan history information collected at the end of the plan execution. | $hist_plan_epilog_n | $v_sig_hist_plan_epilog_n |
Plan history information collected at the beginning of plan execution. | $hist_plan_prolog_n | $v_sig_hist_plan_prolog_n |
Data collected at the end of the query. | $hist_query_epilog_n | $v_sig_hist_query_epilog_n |
The remaining characters of the query string that was stored in the querytext column of the $hist_query_prolog_n table. | $hist_query_overflow_n | $v_sig_hist_query_overflow_n |
Initial data collected at the start of a query. | $hist_query_prolog_n | $v_sig_hist_query_prolog_n |
Information about CLI usage from the localhost or remote client. | $hist_service_n | $v_sig_hist_service_n |
Information about each session, collected during session termination. | $hist_session_epilog_n | $v_sig_hist_session_epilog_n |
Information about each created session. | $hist_session_prolog_n | $v_sig_hist_session_prolog_n |
The state changes in the system. | $hist_state_change_n | $v_sig_hist_state_change_n |
The table access history for a query. | $hist_table_access_n | $v_sig_hist_table_access_n |
The version number and type of the history database. | $hist_version | |
Note:
|
The audit history views use row-level security to restrict access to the audit information. Each has a name of the form $v_sig_hist_*. Each has the same columns as its corresponding $hist_* table, but also has an additional security label (sec_label) column that contains the security descriptor string.
The views _v_qryhist, _v_qrystat, _v_querystatus, and _v_planstatus were provided in early Netezza® releases but are now deprecated. They are provided for compatibility, but whenever possible, use the other history data views and tables instead.
MYDB.SCHEMA(USER)=> select * from "$hist_version";