Skip to main content

Rows display a wrong count

This topic contains 1 reply, has 2 voices, and was last updated by  Cristi S. 10 months, 4 weeks ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #1736

    Marc Lapointe
    Participant

    After I connect to my Postgres database, I see Rows 0 in Objects for a table I know does not have zero rows. Is this a bug? How can I get the right count?

    #1738

    Cristi S.
    Keymaster

    Both Rows and Size columns from the Objects browser are initially just estimates collected from your database on the first import. Some platforms give us the exact row count, others (like PostgreSQL) provide an just approximate number. For 1-2 rows in the table, collected Rows could be 0.

    Rows value is never automatically updated when rows are added or removed. But, whenever you need a refresh, you can select one or more tables, and execute the contextual Update Row Count command, as in the image below. A SELECT COUNT(*) will be executed right away for each selected table, and Row value updated. Be careful with this command, because the query may be slow on very big tables.

    Update Row Count

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close