count

The count method returns a count of the table

await User.count() // 900

select count("users"."id") as "tablecount" from "users"

Chaining

If desired, one can first provide conditions prior to counting, enabling one to limit the scope of the query before applying count at the sql layer.

await User.limit(10).count() // 10

select count("users"."id") as "tablecount" from "users" limit $1

Similar to other execution methods, count is compatible with all query building mechanisms. Below is a demonstration of utilizing several chained methods to capture a count:

await User.where({ active: true }).whereNot({ email: null }).count() // 5

info

Did you know that count can be pretty expensive to execute if you have a lot of data in your table? Consider using exists instead, if it can fit your use case.