How to check table lock using query ??

HyeontaeJu

How to check table lock using query ??

Jim_Knicely

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