you can do “select count(id) from logs”, for example, but this is slow, because the database engine must check the visibility of each row.
in PostGres, you can do “SELECT reltuples AS approximate_row_count FROM pg_class WHERE relname = ‘logs’;” to get an estimate.
but this doesn’t work in CockRoach (obviously)
is there a way to get a quick estimate?
my table currently has 8061251 rows, which took maybe 5 minutes to count.