iex(3)> import Ecto.Query
nil
iex(4)> Repo.all(from f in User, select: count(f.id))
[debug] SELECT count(u0."id") FROM "users" AS u0 [] OK query=67.8ms queue=10.5ms
[1]
or alternatively:
iex(5)> Repo.one(from f in User, select: count(f.id))
1
[debug] SELECT count(u0."id") FROM "users" AS u0 [] OK query=0.6ms