You can do a fast, conditionless count that ignores current transaction state and therefore risks being slightly out of date, but usually good enough for most u

You can do a fast, conditionless count that ignores current transaction state and therefore risks being slightly out of date, but usually good enough for most use cases: select n_live_tup from pg_stat_user_tables where relname = 'mytable'