{"Entry":{"collection":"metric","key":"pg_stat_xact_user_tables-n_tup_hot_upd","name":"pg_stat_xact_user_tables.n_tup_hot_upd","aliases":["n_tup_hot_upd","pg_stat_xact_user_tables"],"metadata":{"aliases":["n_tup_hot_upd","pg_stat_xact_user_tables"],"category":"pg_stat_xact_user_tables","content_hash":"a9697a948f76cae73b0852d8964038d09bf00196159c7ab48d2fc4430bbed930","imported_at":"2026-09-30T00:40:46.72572+08:00","name":"pg_stat_xact_user_tables.n_tup_hot_upd","name_zh":"","slug":"pg_stat_xact_user_tables-n_tup_hot_upd","summary":"Source-defined field pg_stat_xact_user_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below."}},"Definition":{"Collection":"metric","Key":"pg_stat_xact_user_tables-n_tup_hot_upd","SourceDatabase":"center","Version":"18","SourceTable":"statistics_metric","SourceKey":"pg_stat_xact_user_tables-n_tup_hot_upd","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"comparison_data":{"field":"n_tup_hot_upd","source_expression":"pg_stat_get_xact_tuples_hot_updated(C.oid)","source_view":"pg_stat_xact_all_tables","view":"pg_stat_xact_user_tables","view_definition":"CREATE VIEW pg_stat_xact_user_tables AS\nSELECT * FROM pg_stat_xact_all_tables\n    WHERE schemaname NOT IN ('pg_catalog', 'information_schema') AND\n          schemaname !~ '^pg_toast';"},"comparison_hash":"427d96f04d909230126400d8f2e15fe33aeb2e4896c774b971169c2fd678bb19","description":["Source-defined field pg_stat_xact_user_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below."],"documented":false,"facts":[{"label":"View","value":"pg_stat_xact_user_tables"},{"label":"Field","value":"n_tup_hot_upd"},{"label":"Field evidence","value":"Source declaration; not individually enumerated by the manual"},{"label":"Expression declared in","value":"pg_stat_xact_all_tables"}],"field":"n_tup_hot_upd","manual_html":"","manual_path":"/docs/18/monitoring-stats.html","related":[{"label":"pg_stat_xact_user_tables columns","url":"/wiki/catalog/pg_stat_xact_user_tables/?v=18"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[{"paragraphs":["Same as pg_stat_xact_all_tables, except that only user tables are shown.","Similar to pg_stat_all_tables, but counts actions taken so far within the current transaction (which are not yet included in pg_stat_all_tables and related views). The columns for numbers of live and dead rows and vacuum and analyze actions are not present in this view."],"title":"View semantics"},{"paragraphs":["A transaction can also see its own statistics (not yet flushed out to the shared memory statistics) in the views pg_stat_xact_all_tables , pg_stat_xact_sys_tables , pg_stat_xact_user_tables , and pg_stat_xact_user_functions . These numbers do not act as stated above; instead they update continuously throughout the transaction."],"title":"Collection and transaction context"},{"code":"pg_stat_get_xact_tuples_hot_updated(C.oid)","paragraphs":["No per-field definition, effective SQL type, unit, or reset rule is inferred from this expression."],"title":"Exact source expression"},{"code":"CREATE VIEW pg_stat_xact_user_tables AS\nSELECT * FROM pg_stat_xact_all_tables\n    WHERE schemaname NOT IN ('pg_catalog', 'information_schema') AND\n          schemaname !~ '^pg_toast';","paragraphs":[],"title":"Complete source view definition"},{"code":"CREATE VIEW pg_stat_xact_all_tables AS\nSELECT\n            C.oid AS relid,\n            N.nspname AS schemaname,\n            C.relname AS relname,\n            pg_stat_get_xact_numscans(C.oid) AS seq_scan,\n            pg_stat_get_xact_tuples_returned(C.oid) AS seq_tup_read,\n            sum(pg_stat_get_xact_numscans(I.indexrelid))::bigint AS idx_scan,\n            sum(pg_stat_get_xact_tuples_fetched(I.indexrelid))::bigint +\n            pg_stat_get_xact_tuples_fetched(C.oid) AS idx_tup_fetch,\n            pg_stat_get_xact_tuples_inserted(C.oid) AS n_tup_ins,\n            pg_stat_get_xact_tuples_updated(C.oid) AS n_tup_upd,\n            pg_stat_get_xact_tuples_deleted(C.oid) AS n_tup_del,\n            pg_stat_get_xact_tuples_hot_updated(C.oid) AS n_tup_hot_upd,\n            pg_stat_get_xact_tuples_newpage_updated(C.oid) AS n_tup_newpage_upd\n    FROM pg_class C LEFT JOIN\n         pg_index I ON C.oid = I.indrelid\n         LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)\n    WHERE C.relkind IN ('r', 't', 'm', 'p')\n    GROUP BY C.oid, N.nspname, C.relname;","paragraphs":["This view uses SELECT * from pg_stat_xact_all_tables; the displayed expression is declared by that same-version source view."],"title":"Source projection"}],"signature":"SELECT n_tup_hot_upd FROM pg_catalog.pg_stat_xact_user_tables;","source_expression":"pg_stat_get_xact_tuples_hot_updated(C.oid)","source_only":true,"source_view":"pg_stat_xact_all_tables","sources":[{"label":"PostgreSQL 18 English manual","path":"monitoring-stats.html","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","url":"/docs/18/monitoring-stats.html#id-1.6.14.7.6.8.2.2.16.1.2"},{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"18.6 source archive · src/backend/catalog/system_views.sql","path":"src/backend/catalog/system_views.sql","sha256":"418f4ae7472fe0742e6fbdc7a055581602c5131e082aa6f17e2c7269bf711972","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}],"sql_type":"","tables":[],"units_mentioned":[],"view":"pg_stat_xact_user_tables"},"ManualEvidence":{"manual_path":"/docs/18/monitoring-stats.html","release":{"channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"label":"PostgreSQL 18 English manual","path":"monitoring-stats.html","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","url":"/docs/18/monitoring-stats.html#id-1.6.14.7.6.8.2.2.16.1.2"},{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"18.6 source archive · src/backend/catalog/system_views.sql","path":"src/backend/catalog/system_views.sql","sha256":"418f4ae7472fe0742e6fbdc7a055581602c5131e082aa6f17e2c7269bf711972","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}]},"MeasuredEvidence":{}},"Text":{"Collection":"metric","Key":"pg_stat_xact_user_tables-n_tup_hot_upd","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_xact_user_tables.n_tup_hot_upd","Summary":"Source-defined field pg_stat_xact_user_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.","BodyHTML":"\u003cp\u003eSource-defined field pg_stat_xact_user_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"8ca7437b5672c13f69fdd976d14eecf143d5d56346339e97e828293083be4edf","Payload":{"description":["Source-defined field pg_stat_xact_user_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below."],"manual_html":"","related":[{"label":"pg_stat_xact_user_tables columns","url":"/wiki/catalog/pg_stat_xact_user_tables/?v=18"}],"sections":[{"paragraphs":["Same as pg_stat_xact_all_tables, except that only user tables are shown.","Similar to pg_stat_all_tables, but counts actions taken so far within the current transaction (which are not yet included in pg_stat_all_tables and related views). The columns for numbers of live and dead rows and vacuum and analyze actions are not present in this view."],"title":"View semantics"},{"paragraphs":["A transaction can also see its own statistics (not yet flushed out to the shared memory statistics) in the views pg_stat_xact_all_tables , pg_stat_xact_sys_tables , pg_stat_xact_user_tables , and pg_stat_xact_user_functions . These numbers do not act as stated above; instead they update continuously throughout the transaction."],"title":"Collection and transaction context"},{"code":"pg_stat_get_xact_tuples_hot_updated(C.oid)","paragraphs":["No per-field definition, effective SQL type, unit, or reset rule is inferred from this expression."],"title":"Exact source expression"},{"code":"CREATE VIEW pg_stat_xact_user_tables AS\nSELECT * FROM pg_stat_xact_all_tables\n    WHERE schemaname NOT IN ('pg_catalog', 'information_schema') AND\n          schemaname !~ '^pg_toast';","paragraphs":[],"title":"Complete source view definition"},{"code":"CREATE VIEW pg_stat_xact_all_tables AS\nSELECT\n            C.oid AS relid,\n            N.nspname AS schemaname,\n            C.relname AS relname,\n            pg_stat_get_xact_numscans(C.oid) AS seq_scan,\n            pg_stat_get_xact_tuples_returned(C.oid) AS seq_tup_read,\n            sum(pg_stat_get_xact_numscans(I.indexrelid))::bigint AS idx_scan,\n            sum(pg_stat_get_xact_tuples_fetched(I.indexrelid))::bigint +\n            pg_stat_get_xact_tuples_fetched(C.oid) AS idx_tup_fetch,\n            pg_stat_get_xact_tuples_inserted(C.oid) AS n_tup_ins,\n            pg_stat_get_xact_tuples_updated(C.oid) AS n_tup_upd,\n            pg_stat_get_xact_tuples_deleted(C.oid) AS n_tup_del,\n            pg_stat_get_xact_tuples_hot_updated(C.oid) AS n_tup_hot_upd,\n            pg_stat_get_xact_tuples_newpage_updated(C.oid) AS n_tup_newpage_upd\n    FROM pg_class C LEFT JOIN\n         pg_index I ON C.oid = I.indrelid\n         LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)\n    WHERE C.relkind IN ('r', 't', 'm', 'p')\n    GROUP BY C.oid, N.nspname, C.relname;","paragraphs":["This view uses SELECT * from pg_stat_xact_all_tables; the displayed expression is declared by that same-version source view."],"title":"Source projection"}],"tables":[]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}