GP - Display Lock(s)

SQL to check locks

select lorlocktype as \"Type\",
lorpid         as \"Pid\",
lorrelname as \"Obj Name\",
lormode        as \"Mode\"
from gp_toolkit.gp_locks_on_relation
where lorpid != pg_backend_pid()
order by lorpid;

 List out all PIDs

 select distinct lorpid as \"Pid\"
from gp_toolkit.gp_locks_on_relation
where lorpid != pg_backend_pid()
order by lorpid

 List out select PID(s) details:

 select lorlocktype as \"Type\",
lorpid         as \"Pid\",
lorrelname as \"Obj Name\",
lormode        as \"Mode\",
lorcurrentquery as \"Query\"
from gp_toolkit.gp_locks_on_relation
where lorpid in ( $(echo $PID | tr ' ' ',') ) 
order by lorpid

 Note: for above sql, get PID(s) as an Input

Comments

Post a Comment

Popular posts from this blog

How to set Optimizer at database level in greenplum

How can I turn ON optimizer at Database level? You can set the optimier ON at database level using below command; ALTER DATABASE databasename SET OPTIMIZER = ON; Once this is done, kindly do reconnect to Database to see the change. How do I check if optimizer is set (ON/OFF) in a given database? You can use the show command as below to check psql -d databasename -c 'show optimizer'
Read more

Changing the gpmon Password

Greenplum Command Center manages the gpperfmon database using the gpmon database role. To change the gpmon password, follow these steps: 1. Log in to Greenplum Database as a superuser and change the gpmon password with the ALTER ROLE command: # ALTER ROLE gpmon WITH PASSWORD 'new_password'; 2. Update the password in the .pgpass file, which is used by Greenplum Command Center. The default location for this file is the gpadmin home directory (~/.pgpass). The .pgpass file contains a line with the gpmon password. Replace the existing password with the new password. *:5432:gpperfmon:gpmon:new_password The file should be owned by gpadmin and RW-accessible by gpadmin only. 3. Restart Greenplum Command Center with the gpcmdr utility. $ gpcmdr --restart
Read more

IPMI Tool | IPMI Cheatsheet

To have a better understanding about IPMI Explanation: The Intelligent Platform Management Interface (IPMI) is a standardized computer system interface used by System Administrators for out-of-band management of computer systems and monitoring of their operation. Out-of-band is also referred to the LOM (Lights-Out Management) involves the use of a dedicated management channel for device maintenance. A numbers of options are available to manage the device remotely. There are vendor-specific server management technologies available. HP’s Integrated Lights-out or iLO, Dell’s Dell Remote Access Controller or DRAC and IBM’s Remote Supervisor Adapter (RSA) are a few to list. The above listed modules are vendor specific and proprietary. IPMI whereas is vendor-neutral and cross-platform. It is available on Linux distros. The functionality of IPMI can be accessed via IPMItool. IPMItool is a command prompt, which is used to manage IPMI-enabled devices. IPMItool helps in managing the
Read more