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