Netezza Performance Server stats tables

You can use the nzstats command to view sets of related operational information. These sets are organized as groups of related statistics or tables that contain rows of related statistics.

Note: The terms group and table are based on Simple Network Management Protocol (SNMP) concepts and are not associated with database groups or tables.

The following table lists the Netezza Performance Server core groups and tables that you can view by using the nzstats command.

Table 1. Netezza® Groups and Tables
Group/Table	Description	See
Database Table	Provides information about databases.	Database Table.
DBMS Group	Provides information about the database server.	DBMS Group.
Host CPU Table	Provides information about each host processor.	Host CPU Table.
Host Filesystem Table	Provides information about each local host file system.	Host File System Table.
Host Interface Table	Provides information about the host's interface.	Host Interface Table.
Host Mgmt Channel Table	Provides information about the system's management channel from the host viewpoint.	Host Mgmt Channel Table.
Host Network Table	Provides information about the system's main UDP network layer from the host viewpoint.	Host Network Table.
Host Table	Provides information about each host.	Host Table.
HW Mgmt Channel Table	Provides information about each SPU management channel from the SPU's viewpoint.	Hardware Management Channel Table
Per Table Per Data Slice Table	Provides information about tables on a per-data slice basis.	Per Table Per Data Slice Table.
Query Table	Provides information about active queries as obtained from the _v_qrystat view.	Query Table.
Query History Table	Provides a list of the last 2000 queries that completed as recorded in the _v_qryhist view.	Query History Table.
SPU Partition Table	Provides information about a SPU's disk partitions.	SPU Partition Table.
SPU Table	Provides information about each SPU's memory.	SPU Table.
System Group	Provides information about the system as a whole.	System Group.
Table Table	Provides information about database tables and views.	Table Table.