I am trying to find a way to figure out why a query i'm running is waiting. When running
select * from pg_stat_activity;
I can see my query is waiting, but there is no autovacuum or anything that seems to use the specific table i'm querying. Is there a way to find out what lock is the query waiting for?
