When I SELECT * or commit any query for this particular database all that pgadmin returns is 1000 rows even thought there are over 225000. This hasn't been the case since I imported the data but began suddenly and I am unsure of the cause. I have the latest version(4.23). This doesn't happen on another database that has over 1000 rows. The row limit drop down is greyed out. I've check the documentation for an answers in the documentation and checked around for similar questions elsewhere but I have not found any answers. Any suggestions?
Changing the parameter in config.py pgAdmin4/web folder
##########################################################################
# Number of records to fetch in one batch in query tool when query result
# set is large.
##########################################################################
ON_DEMAND_RECORD_COUNT = 100000000