PostgreSQL

How to see hanging transactions?

select pid, user, query, query_start, age(clock_timestamp(), query_start), wait_event, wait_event_type from pg_stat_activity where age(clock_timestamp(), query_start) > '10 hours';

How to check db locks?

SELECT * FROM pg_locks WHERE NOT GRANTED;