Object stats

The Object stats report consists of three tables, namely, User Tables stats, User index stats, and Bad lock stats. Columns in the tables are described in Table 1, Table 2, and Table 3.

User Tables stats

**Table 1** Contents in the User Tables stats table
Column	Description
DB Name	Database name.
Schema	Schema name.
Relname	Relation name.
Seq Scan	Number of sequential scans initiated in the table.
Seq Tup Read	Number of live rows fetched by sequential scans.
Index Scan	Number of index scans initiated in the table.
Index Tup Fetch	Number of live rows fetched by index scans.
Tuple Insert	Number of rows inserted.
Tuple Update	Number of rows updated.
Tuple Delete	Number of rows deleted.
Tuple Hot Update	Number of rows HOT updated (with no separate index update required).
Live Tuple	Estimated number of live rows.
Dead Tuple	Estimated number of rows without responses.
Last Vacuum	Last time at which the table was manually vacuumed (not counting VACUUM FULL).
Last Autovacuum	Last time when the table was vacuumed by the autovacuum daemon thread.
Last Analyze	Last time at which this table was manually analyzed.
Last Autoanalyze	Last time when the table was analyzed by the autovacuum daemon thread.
Vacuum Count	Number of times that the table has been manually vacuumed (not counting VACUUM FULL).
Autovacuum Count	Number of times that the table has been vacuumed by the autovacuum daemon.
Analyze Count	Number of times that the table has been manually analyzed.
Autoanalyze Count	Number of times that the table has been analyzed by the autovacuum daemon thread.

User index stats

**Table 2** Contents in the User index stats table
Column	Description
DB Name	Database name.
Schema	Schema name.
Relname	Relation name.
Index Relname	Index name.
Index Scan	Number of index scans initiated on the index.
Index Tuple Read	Number of index entries returned by scans on the index.
Index Tuple Fetch	Number of active rows fetched in the original table by a simple index scan that uses the index.

Bad lock stats

**Table 3** Contents in the Bad lock stats table
Column	Description
DB Id	OID of the database.
Tablespace Id	Tablespace OID.
Relfilenode	File object ID.
Fork Number	File type.
Error Count	Number of failures.
First Time	First occurrence time.
Last Time	Last occurrence time.