gistfile1.txt

 > Cnam.count
   (31732.4ms)  SELECT COUNT(*) FROM "cnams"
 => 64279448

> Cnam.where(["name like ?", "%Dregges%"])
  Cnam Load (36500.1ms)  SELECT "cnams".* FROM "cnams" WHERE (name like '%Dregges%')
  EXPLAIN (0.7ms)  EXPLAIN SELECT "cnams".* FROM "cnams" WHERE (name like '%Dregges%')
EXPLAIN for: SELECT "cnams".* FROM "cnams"  WHERE (name like '%Dregges%')
                          QUERY PLAN
---------------------------------------------------------------
 Seq Scan on cnams  (cost=0.00..1306450.10 rows=3775 width=29)
   Filter: ((name)::text ~~ '%Dregges%'::text)
(2 rows)

 => []