I have a process that appears to hang every night. I ran the following
query and results, and it looks like an autoanalyze and query are
waiting on a lock that's being exclusively held by a transaction that is
IDLE. Any ideas? Any additional queries I should run to shed light on
the issue?


SELECT pg_database.datname AS database, pg_class.relname AS table,
transaction, pid, mode, granted, usename, current_query, backend_start
FROM pg_locks, pg_class, pg_database, pg_stat_activity
WHERE pg_locks.relation = pg_class.oid
AND pg_locks.database = pg_database.oid
and pg_locks.pid = pg_stat_activity.procpid
order by pg_database.datname, pg_class.relname, granted

"dashboard";"activity_log_transition";18291984;158 8;"ShareUpdateExclusiveLock";f;"postgres";"ANALY ZE
public.activity_log_transition";"2007-01-17 00:06:03.281-05"
"dashboard";"activity_log_transition";18291982;287 2;"AccessShareLock";f;"dashboard";"select
distinct strDescription from activity_log_transition";"2007-01-17
00:05:03.281-05"
"dashboard";"activity_log_transition";18291979;147 2;"ShareLock";t;"dashboard";"<IDLE>
in transaction";"2007-01-17 00:05:00.968-05"
"dashboard";"activity_log_transition";18291979;147 2;"AccessExclusiveLock";t;"dashboard";"<IDLE>
in transaction";"2007-01-17 00:05:00.968-05"
"dashboard";"activity_log_transition_pkey";1829197 9;1472;"AccessExclusiveLock";t;"dashboard";"<IDLE>
in transaction";"2007-01-17 00:05:00.968-05"

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq