[Spacewalk-list] Query Continuously Running

[Wojtak, Greg (Superfly)]

Spacewalk 1.5 (PostgreSQL) on Cent 6

I've been seeing a process keep popping up that uses as much cpu as it can get.  It appears to be a delete transaction.  I've run the following query in psql:

 select current_query from pg_stat_activity where current_query <> '<IDLE>' and current_query not like '%pg_stat_activity%';

It appears that the query that is hanging is:

 DELETE FROM rhnPackageChangeLogData
         WHERE id NOT IN ( SELECT changelog_data_id FROM rhnPackageChangeLogRec )

Any insight into this?

Thanks,

Greg