hi,
>From pg_stat_activity I can find a query is at waiting state, and from pg_locks and pg_class can find which relation the query is waiting for, But how to find witch query is lock the relation?
hi,
>From pg_stat_activity I can find a query is at waiting state, and from pg_locks and pg_class can find which relation the query is waiting for, But how to find witch query is lock the relation?