Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ Other System Catalogs/ GS_TABLESTATS_HISTORY
Updated on 2025-08-19 GMT+08:00
View PDF

GS_TABLESTATS_HISTORY

GS_TABLESTATS_HISTORY is a table for managing historical statistics at the table, index, and partition levels. It stores historical statistics about tables, indexes, and partitions in a database. This table is visible and unavailable in distributed mode.

Table 1 GS_TABLESTATS_HISTORY columns

Name

Type

Description

relid

oid

Unique ID of a table, index, or partition in PG_CLASS or PG_PARTITION.

relname

name

Name of a table, index, or partition.

relnamespace

oid

OID of the namespace that contains this object.

relkind

"char"

Object type.

  • r: ordinary table.
  • I: table-level index.
  • i: partitioned index.
  • p: level-1 partition.
  • s: level-2 partition.

reltimestamp

timestamp with time zone

Time when the statistics are collected.

relpages

double precision

Size of the table on disk in pages. 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.
Parent topic: Other System Catalogs