CODEWITHSUNDEEP
databasepostgresqlpostgresql-9.2
Aman Aggarwal
Aman Aggarwal

Reputation: 18469

Why the table pg_stat_user_tables is blank?

I am new to postgres.

I am checking the stats in table pg_stat_user_tables but i didn't get any results. It says 0 rows found.

Any idea how this table get updated? Is there any parameter to enable the stats ?

Thanks

Upvotes: 3

Views: 7069

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247445

That is because there are no user tables in that database (the database contains only system tables).

Use pg_stat_all_tables to get information about all tables in the database.

Upvotes: 4

Related Questions