Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

PG_STAT_SYS_TABLES

Updated on 2024-09-30 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

Table OID

schemaname

name

Schema name of the table

relname

name

Name of a table

seq_scan

bigint

Number of sequential scans started on the table

seq_tup_read

bigint

Number of rows that have live data fetched by sequential scans

idx_scan

bigint

Number of index scans

idx_tup_fetch

bigint

Number of rows that have live data 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 updated by HOT (no separate index update is 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 (excluding VACUUM FULL)

last_autovacuum

timestamp with time zone

Last time at which this table was automatically vacuumed

last_analyze

timestamp with time zone

Last time at which this table was analyzed

last_autoanalyze

timestamp with time zone

Last time at which this table was automatically analyzed

vacuum_count

bigint

Number of vacuum operations (excluding VACUUM FULL)

autovacuum_count

bigint

Number of autovacuum operations

analyze_count

bigint

Number of analyze operations

autoanalyze_count

bigint

Number of autoanalyze operations

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback