Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

GLOBAL_COLUMN_TABLE_IO_STAT

Updated on 2024-12-19 GMT+08:00

GLOBAL_COLUMN_TABLE_IO_STAT provides I/O statistics of all column-store tables in the current database. The names, types, and sequence of the columns are the same as those in the GS_COLUMN_TABLE_IO_STAT view. The value of each statistical column is the sum of the values of the corresponding columns of all nodes.

Table 1 GLOBAL_COLUMN_TABLE_IO_STAT columns

Name

Type

Description

schemaname

name

Table namespace

relname

name

Table name

heap_read

bigint

Number of blocks logically read in the heap

heap_hit

bigint

Number of block hits in the heap

idx_read

bigint

Number of blocks logically read in the index

idx_hit

bigint

Number of block hits in the index

cu_read

bigint

Number of logical reads in the Compression Unit

cu_hit

bigint

Number of hits in the Compression Unit

cidx_read

bigint

Number of indexes logically read in the Compression Unit

cidx_hit

bigint

Number of index hits in the Compression Unit

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback