Table of Contents Previous Next


7 Performance Analysis and Tuning : 7.2 Infinite Cache : 7.2.7 Retrieving Table Statistics

The pg_statio_all_tables view contains one row for each table in the database. The view contains the following information:
The pg_statio_sys_tables view contains one row for each table in a system-defined schema. The statistical information included in this view is the same as for pg_statio_all_tables.
The pg_statio_user_tables view contains one row for each table in a user-defined schema. The statistical information in this view is the same as for pg_statio_all_tables.
The pg_statio_all_indexes view contains one row for each index in the current database. The view contains the following information:
The pg_statio_sys_indexes view contains one row for each index on the system tables. The statistical information in this view is the same as in pg_statio_all_indexes.
The pg_statio_user_indexes view contains one row for each index on a table that resides in a user-defined schema. The statistical information in this view is the same as in pg_statio_all_indexes.

7 Performance Analysis and Tuning : 7.2 Infinite Cache : 7.2.7 Retrieving Table Statistics

Table of Contents Previous Next