gistfile1.txt

Timing is on.
                                                          QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------
 Delete on fact_values  (cost=0.00..5089117.29 rows=2391 width=6) (actual time=49146.897..49146.897 rows=0 loops=1)
   ->  Seq Scan on fact_values  (cost=0.00..5089117.29 rows=2391 width=6) (actual time=49146.889..49146.889 rows=0 loops=1)
         Filter: (NOT (SubPlan 1))
         Rows Removed by Filter: 4782
         SubPlan 1
           ->  Materialize  (cost=0.00..1930.48 rows=79165 width=8) (actual time=0.002..5.415 rows=35234 loops=4782)
                 ->  Seq Scan on facts  (cost=0.00..1224.65 rows=79165 width=8) (actual time=0.018..16.359 rows=79141 loops=1)
 Total runtime: 49148.089 ms
(8 rows)

Time: 49150.303 ms
                                                        QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------
 Delete on fact_paths  (cost=142.78..267.55 rows=2391 width=6) (actual time=5.047..5.047 rows=0 loops=1)
   ->  Seq Scan on fact_paths  (cost=142.78..267.55 rows=2391 width=6) (actual time=5.046..5.046 rows=0 loops=1)
         Filter: (NOT (hashed SubPlan 1))
         Rows Removed by Filter: 4782
         SubPlan 1
           ->  Seq Scan on fact_values  (cost=0.00..130.82 rows=4782 width=8) (actual time=0.005..1.038 rows=4782 loops=1)
 Total runtime: 5.134 ms
(7 rows)

Time: 5.801 ms
                                                           QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
 Delete on resource_params_cache  (cost=16.75..44.63 rows=255 width=12) (actual time=0.004..0.004 rows=0 loops=1)
   ->  Hash Anti Join  (cost=16.75..44.63 rows=255 width=12) (actual time=0.002..0.002 rows=0 loops=1)
         Hash Cond: ((resource_params_cache.resource)::text = (cr.resource)::text)
         ->  Seq Scan on resource_params_cache  (cost=0.00..15.10 rows=510 width=104) (actual time=0.000..0.000 rows=0 loops=1)
         ->  Hash  (cost=13.00..13.00 rows=300 width=104) (never executed)
               ->  Seq Scan on catalog_resources cr  (cost=0.00..13.00 rows=300 width=104) (never executed)
 Total runtime: 0.035 ms
(7 rows)

Time: 1.544 ms
                                                             QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------
 Delete on environments  (cost=45.38..63.38 rows=200 width=6) (actual time=0.520..0.520 rows=0 loops=1)
   ->  Seq Scan on environments  (cost=45.38..63.38 rows=200 width=6) (actual time=0.520..0.520 rows=0 loops=1)
         Filter: (NOT (hashed SubPlan 1))
         Rows Removed by Filter: 400
         SubPlan 1
           ->  Append  (cost=0.00..44.00 rows=550 width=7) (actual time=0.012..0.170 rows=400 loops=1)
                 ->  Result  (cost=0.00..23.00 rows=150 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                       ->  Append  (cost=0.00..23.00 rows=150 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                             ->  Seq Scan on catalogs  (cost=0.00..11.10 rows=110 width=4) (actual time=0.001..0.001 rows=0 loops=1)
                             ->  Seq Scan on reports  (cost=0.00..10.40 rows=40 width=4) (actual time=0.000..0.000 rows=0 loops=1)
                 ->  Seq Scan on factsets  (cost=0.00..17.00 rows=400 width=8) (actual time=0.011..0.135 rows=400 loops=1)
 Total runtime: 0.562 ms
(12 rows)

Time: 1.971 ms
                                                    QUERY PLAN
-------------------------------------------------------------------------------------------------------------------
 Delete on report_statuses  (cost=10.50..35.00 rows=580 width=6) (actual time=0.001..0.001 rows=0 loops=1)
   ->  Seq Scan on report_statuses  (cost=10.50..35.00 rows=580 width=6) (actual time=0.001..0.001 rows=0 loops=1)
         Filter: (NOT (hashed SubPlan 1))
         SubPlan 1
           ->  Seq Scan on reports  (cost=0.00..10.40 rows=40 width=4) (never executed)
 Total runtime: 0.073 ms
(6 rows)

Time: 0.542 ms