Calculate the Catalog Size in Memory on Each Node
Jim_Knicely
Administrator
The RESOURCE_POOL_STATUS system table provides the current state of built-in and user-defined resource pools on each node, including memory usage. The METADATA built-in pool tracks memory allocated for catalog data and storage data structures.
Knowing those two facts, we can calculate catalog memory usage on all nodes by querying the system table RESOURCE_POOL_STATUS for the METADATA pool!
Example:
dbadmin=> SELECT node_name, pool_name, memory_size_kb/1024^2 AS memory_size_kb_gb dbadmin-> FROM resource_pool_status dbadmin-> WHERE pool_name = 'metadata'; node_name | pool_name | memory_size_kb_gb --------------------+-----------+------------------- v_test_db_node0001 | metadata | 0.104231834411621 v_test_db_node0002 | metadata | 0.104231824231921 v_test_db_node0003 | metadata | 0.104231834213117 (1 row)
Helpful Links:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/RESOURCE_POOL_STATUS.htm
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/Built-inPools.htm
Have fun!
1