lboka/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_0770.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

8.1 KiB
Raw Permalink Blame History

PG_STAT_XACT_ALL_TABLES

PG_STAT_XACT_ALL_TABLES displays the transaction status information about all ordinary tables and TOAST tables in the namespaces.

Table 1 PG_STAT_XACT_ALL_TABLES columns

Name

Type

Description

relid

oid

Table OID

schemaname

name

Schema name of the table

relname

name

Table name

seq_scan

bigint

Number of sequential scans started on the table

seq_tup_read

bigint

Number of live rows fetched by sequential scans

idx_scan

bigint

Number of index scans started on the table

idx_tup_fetch

bigint

Number of live rows fetched by index scans

n_tup_ins

bigint

Number of rows inserted

n_tup_upd

bigint

Number of rows updated

n_tup_del

bigint

Number of rows deleted

n_tup_hot_upd

bigint

Number of rows HOT updated (that is, with no separate index update required)
Parent topic: System Views