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
Node Name	Node name.
DB Name	Database name.
Schema	Schema name.
Relname	Relationship name.
Seq Scan	Number of sequential scans initiated on this table.
Seq Tup Read	Number of live rows fetched by sequential scans.
Index Scan	Number of index scans initiated on 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 this table was manually vacuumed (excluding VACUUM FULL).
Last Autovacuum	Last time at which this table was vacuumed by the autovacuum daemon.
Last Analyze	Last time at which this table was manually analyzed.
Last Autoanalyze	Last time at which this table was analyzed by the autovacuum daemon.
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 process.

User index stats

**Table 2** Contents in the User index stats table
Column	Description
Node Name	Node name.
DB Name	Database name.
Schema	Schema name.
Relname	Relationship 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 live 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	Database OID.
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.