Object stats

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 updated)

Live Tuple

Estimated number of live rows

Dead Tuple

Estimated number of dead rows

Last Vacuum

Last time at which the table was manually vacuumed (not counting VACUUM FULL)

Last Autovacuum

Last time at which the table was vacuumed by the autovacuum daemon

Last Analyze

Last time at which the table was manually analyzed

Last Autoanalyze

Last time at which the 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

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 table rows fetched by simple index scans by using the index

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