PostgreSQL 11 Administration Cookbook

How to do it…

Follow these steps to check if a query is waiting for another query:

1. Run the following query:

SELECT datname, usename, wait_event_type, wait_event, backend_type, queryFROM pg_stat_activityWHERE wait_event_type IS NOT NULLAND wait_event_type NOT IN ('Activity', 'Client');

2. You will receive the following output:

-[ RECORD 1 ]---+-----------------datname         | postgresusename         | gianniwait_event_type | Lockwait_event      | relationbackend_type    | client backendquery           | select * from t;