Jira Link: DB-5092
Initial work will expose lock status information via yb_lock_status stored procedure. We should instead expose this information via pg_locks