psql get total amount of database rows code example

Example: postgresql select fast check no rows

select exists (select 1 from mytable)