dbadmin=> SELECT DISTINCT table_name, description FROM data_collector WHERE description ilike '% lock%';
table_name | description
------------------+----------------------------------------------
dc_lock_requests | History of lock requests
dc_lock_releases | History of lock releases
dc_lock_attempts | History of lock attempts (resolved requests)
(3 rows)
HyeontaeJu
Vertica Customer ✭
Answers
Data Collector tables!
dbadmin=> SELECT DISTINCT table_name, description FROM data_collector WHERE description ilike '% lock%'; table_name | description ------------------+---------------------------------------------- dc_lock_requests | History of lock requests dc_lock_releases | History of lock releases dc_lock_attempts | History of lock attempts (resolved requests) (3 rows)https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/RetainingMonitoringInformation.htm