18. Monitoring : View Information about a Database : vwinfo PDT Usage Display
 
Share this page                  
vwinfo PDT Usage Display
The information provided by vwinfo -M can be used to identify tables that are good candidates for MODIFY...TO COMBINE operations to free main memory used by the PDTs (Positional Delta Trees).
Here is an excerpt from a typical output:
+------------+-----------+------------+------------------+------------------+-------------------+
|schema_name |table_name |pdt_mem     |pdt_inserts_count |pdt_deletes_count |pdt_modifies_count |
+------------+-----------+------------+------------------+------------------+-------------------+
|user1       |part       | 2304       | 3                | 0                | 0                 |
+------------+-----------+------------+------------------+------------------+-------------------+
Fields are as follows:
schema_name
The schema holding the table
table_name
The name of the table
pdt_mem
The amount of memory, in bytes, used by the PDTs for the table
pdt_inserts_count
The number of inserted tuples currently stored in the PDTs for the table
pdt_deletes_count
The number of tuples marked as deleted currently stored in the PDTs for the table
pdt_modifies_count
The number of modified table fields currently stored in the PDTs for the table. The maximum number is: number of tuples times number of columns.