Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PGAdmin gets estimated row count from where?

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

enter image description here

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

like image 211
St.Antario Avatar asked Jun 20 '26 23:06

St.Antario


1 Answers

If it is row count you want, why not try this :

SELECT count(*) as rowCount FROM table
like image 84
Zoran777 Avatar answered Jun 23 '26 14:06

Zoran777