Thanks for advice about queries, i guess you're talking about those from page
https://wiki.postgresql.org/wiki/Lock_Monitoring . Previously, I was using
"blockedby" template from pgAdmin's "Server Status".
And you are absolutely right suspecting distributed transactions. The most
interesting
=?UTF-8?B?TWlraGFpbA==?= writes:
> I'm running supposedly an easy operation - renaming index and my session
> hangs on it. pg_stat_activity shows that process is active and is waiting for
> lock:
> locktype ¦ relation ¦ relname ¦ virtualtransaction ¦ pid ¦ mode ¦
> granted ¦ fastpath Â
Sorry for my previous message, it went to wrong thread. Creating this as a new
one.
I'm running supposedly an easy operation - renaming index and my session hangs
on it. pg_stat_activity shows that process is active and is waiting for lock:
=# select application_name, waiting, state, query from
Hi,
I'm running supposedly an easy operation - renaming index and my session hangs
on it. pg_stat_activity shows that process is active and is waiting for lock:
=# select application_name, waiting, state, query from pg_stat_activity where
pid = 15179;
application_name │ waiting │ state │ query
