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.
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. |