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
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
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot