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)
Answers
Data Collector tables!
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/RetainingMonitoringInformation.htm