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

PV_RUNTIME_RELSTATS

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.