Help Center > > Developer Guide> System Catalogs and System Views> System Views> PG_STAT_SYS_TABLES

PG_STAT_SYS_TABLES

Updated at: Jul 15, 2020 GMT+08:00

PG_STAT_SYS_TABLES displays the statistics about the system catalogs of all the namespaces in pg_catalog and information_schema schemas.

Table 1 PG_STAT_SYS_TABLES columns

Name

Type

Description

relid

oid

OID of the table

schemaname

name

Name of the schema that this table is in

relname

name

Name of the table

seq_scan

bigint

Number of sequential scans initiated on this table

seq_tup_read

bigint

Number of live rows fetched by sequential scans

idx_scan

bigint

Number of index scans initiated on this table

idx_tup_fetch

bigint

Number of live rows fetched by index scans

n_tup_ins

bigint

Number of rows inserted

n_tup_upd

bigint

Number of rows updated

n_tup_del

bigint

Number of rows deleted

n_tup_hot_upd

bigint

Number of rows HOT updated (that is, with no separate index update required)

n_live_tup

bigint

Estimated number of live rows

n_dead_tup

bigint

Estimated number of dead rows

last_vacuum

timestamp with time zone

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

last_autovacuum

timestamp with time zone

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

last_analyze

timestamp with time zone

Last time at which this table was manually analyzed

last_autoanalyze

timestamp with time zone

Last time at which this table was analyzed by the autovacuum daemon

vacuum_count

bigint

Number of times this table has been manually vacuumed (not counting VACUUM FULL)

autovacuum_count

bigint

Number of times this table has been vacuumed by the autovacuum daemon

analyze_count

bigint

Number of times this table has been manually analyzed

autoanalyze_count

bigint

Number of times this table has been analyzed by the autovacuum daemon

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel