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.
Last modified date: 08/14/2024