PV_RUNTIME_RELSTATS

Updated on 2024-09-02 GMT+08:00

View PDF

PV_RUNTIME_RELSTATS displays table-level statistics in the memory generated by autoanalyze. The descriptions of the columns in PV_RUNTIME_RELSTATS are the same as those in PG_CLASS. This view is used only by clusters of version 8.2.0 or later.

**Table 1** PV_RUNTIME_RELSTATS columns
Name	Type	Description
nspname	name	Schema name.
relname	name	Name of an object, such as a table or index.
relpages	double precision	Size of the on-disk representation of this table in pages (of size BLCKSZ). This is only an estimate used by the optimizer.
reltuples	double precision	Number of rows in the table. This is only an estimate used by the optimizer.
relallvisible	integer	Number of pages marked as all visible in the table. This column is used by the optimizer for optimizing SQL execution.
relhasindex	boolean	Its value is true if this column is a table and has (or recently had) at least one index. It is set by CREATE INDEX but is not immediately cleared by DROP INDEX. If the VACUUM process detects that a table has no index, it clears the relhasindex column and sets the value to false.
changes	bigint	Total historical modifications in the table by the time the lightweight autoanalyze is triggered.
level	text	Current phase of the memory statistics generated by the lightweight autoanalyze. It can be local, sendlist, or global.