How to implement Greenplum Lock query statement
This article will explain in detail how to implement the Greenplum lock query statement. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.
SELECT clock_timestamp (), pg_class.relname, pg_locks.locktype, pg_locks. DATABASE, pg_locks.relation, pg_locks.page, pg_locks.tuple, pg_locks.virtualtransaction, pg_locks.pid, pg_locks. MODE, pg_locks. GRANTEDFROM pg_locksJOIN pg_class ON pg_locks.relation = pg_class.oidWHERE relname! ~'^ pg_'AND relname 'active_locks'; on "how to implement Greenplum lock query statement" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.
