I have an
ALTER TABLE statement that according to
pg_stat is "waiting", and I'm wondering if there is an easy fix to allow the statement to execute?
From my limited understanding I think it's a table level lock that isn't releasing. The table
pg_locks shows a single
AccessExclusiveLock that has its granted column set to
ps aux | grep postgres confirms that there is a postgres
ALTER TABLE waiting.
If it helps the statement is one that's been created by the Django ORM (South in particular).