How to create a process to verify the the row count on the table incre

in psql:

 you could take a look at the various cron like tools for databases as well pg_timetable is the nicest one, though I am certainly biased towards that though depending on the size of your table, count without where could be a little slow You can take a look at the statistics (pg_stat_user_tables) to see how many live tuples there are in the table, that would give you a rough idea on the number of rows.