Re: Postgres hangs for the query "lock table <Tablename> in exclusive mode"

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thursday, February 22, 2018, Vinodh NV <linktovinodh@xxxxxxxxx> wrote:

Postgres hangs for the query "lock table <Tablename> in exclusive mode"

Can you please let me know what could be the reason and how to resolve it?

Not readily, but that's why the pg_locks view exists.

https://www.postgresql.org/docs/9.6/static/view-pg-locks.html

David J.