PostgreSQL - Table Statistics

Wojtek Bialek - Dataedo Team Wojtek Bialek 11th October, 2024

Imported Statistics

Statistics Is imported Description
Row count Indicates the number of rows in table
Last user query -
Number of user queries -
Last user update -
Number of user updates -
Last load time -

Requirements

Dataedo requires access to the following tables and views:

  • pg_class
  • pg_namespace

Limitations

  • Row number in the table is only an estimate used by the planner. It is updated by VACUUM, ANALYZE, and a few DDL commands such as CREATE INDEX. If the table has never yet been vacuumed or analyzed, row count is 0.

Learn more

Read more about table statistics import in main article