gistfile1.txt

EXPLAIN ANALYZE                                                                 
delete from fact_values where ID NOT IN (SELECT fact_value_id FROM facts);         
                                                                                
EXPLAIN ANALYZE                                                                 
delete from fact_paths where ID NOT IN (SELECT path_id FROM fact_values);          
                                                                                
EXPLAIN ANALYZE                                                                 
delete from resource_params_cache where NOT EXISTS (SELECT * FROM catalog_resources cr WHERE cr.resource=resource_params_cache.resource);
                                                                                
EXPLAIN ANALYZE                                                                 
delete from environments where ID NOT IN                                            
(SELECT environment_id FROM catalogs                                            
    UNION ALL                                                                   
    SELECT environment_id FROM reports                                          
    UNION ALL                                                                   
    SELECT environment_id FROM factsets);                                       
                                                                                
EXPLAIN ANALYZE                                                                 
delete from report_statuses where ID NOT IN (SELECT status_id FROM reports);