Object stats

Object stats contains three tables: User Tables stats, User index stats, and Bad lock stats. Columns in the tables are described as follows:

**Table 1** Columns in the User Tables stats report
Column	Description
Node Name	Node name.
DB Name	Database name.
Schema	Schema name.
Relname	Relation 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 updated).
Live Tuple	Estimated number of live rows.
Dead Tuple	Estimated number of dead rows.
Last Vacuum	Last time at which this table was manually vacuumed (not counting 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 the table has been manually vacuumed (not counting VACUUM FULL).
Autovacuum Count	Number of times the table has been vacuumed by the autovacuum daemon.
Analyze Count	Number of times the table has been manually analyzed.
Autoanalyze Count	Number of times the table has been analyzed by the autovacuum daemon.

**Table 2** Columns in the User index stats report
Column	Description
Node Name	Node name.
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 live table rows fetched by simple index scans using the index.