# Pastebin yMXdpjva
puppetdb=# explain analyze verbose SELECT DISTINCT fact_value_id FROM facts;
                                                         QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------
 HashAggregate  (cost=18290.80..18387.45 rows=9665 width=8) (actual time=712.285..802.908 rows=169524 loops=1)
   Output: fact_value_id
   ->  Seq Scan on public.facts  (cost=0.00..15937.44 rows=941344 width=8) (actual time=0.011..265.903 rows=941344 loops=1)
         Output: fact_value_id
 Total runtime: 820.193 ms
(5 rows)