# Pastebin T9KeIZWp
puppetdb=# explain analyze verbose SELECT ID FROM fact_values WHERE ID NOT IN (SELECT DISTINCT fact_value_id FROM facts);
                                                             QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
 Seq Scan on public.fact_values  (cost=18411.61..27423.11 rows=126060 width=8) (actual time=829.708..966.202 rows=93810 loops=1)
   Output: fact_values.id
   Filter: (NOT (hashed SubPlan 1))
   SubPlan 1
     ->  HashAggregate  (cost=18290.80..18387.45 rows=9665 width=8) (actual time=679.225..745.266 rows=169524 loops=1)
           Output: facts.fact_value_id
           ->  Seq Scan on public.facts  (cost=0.00..15937.44 rows=941344 width=8) (actual time=0.033..291.486 rows=941344 loops=1)
                 Output: facts.fact_value_id
 Total runtime: 973.761 ms
(9 rows)