I noticed that the estimated row count isn't updated after removing some rows from the table.

So, I ran VACUUM ANALYZE on the table, but it didn't work either.
Where is the place PGAdmin takes this value from? Does the query planner take the estimated row count from the same place?
Version: PostgreSQL 9.4
If it is row count you want, why not try this :
SELECT count(*) as rowCount FROM table
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With