postgres fast get query length code example

Example: select count postgres double row count > 1

SELECT
  firstname,
  lastname,
  count(*)
FROM people
GROUP BY
  firstname,
  lastname
HAVING count(*) > 1;