[Spacewalk-list] Query Continuously Running

[Jan Pazdziora]

On Tue, Jan 24, 2012 at 09:18:16PM +0000, Wojtak, Greg (Superfly) wrote:
> When I run an explain and analyze, I get:
> spaceschema=# EXPLAIN DELETE FROM rhnPackageChangeLogData WHERE id NOT IN ( SELECT changelog_data_id FROM rhnPackageChangeLogRec );
>                                           QUERY PLAN                                           
> -----------------------------------------------------------------------------------------------
>  Seq Scan on rhnpackagechangelogdata  (cost=126110.35..9410672444.95 rows=113191 width=6)
>    Filter: (NOT (SubPlan 1))
>    SubPlan 1
>      ->  Materialize  (cost=126110.35..196580.21 rows=5067486 width=8)
>            ->  Seq Scan on rhnpackagechangelogrec  (cost=0.00..101247.86 rows=5067486 width=8)
> (5 rows)
> 
> spaceschema=# ANALYZE rhnPackageChangeLogData;
> ANALYZE
> spaceschema=# ANALYZE rhnPackageChangeLogRec;
> ANALYZE

And what is the explain plan after these analyzes?

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat