{"Entry":{"collection":"metric","key":"pg_stat_activity-xact_start","name":"pg_stat_activity.xact_start","aliases":["xact_start","pg_stat_activity"],"metadata":{"aliases":["xact_start","pg_stat_activity"],"category":"pg_stat_activity","content_hash":"40bbd472f9fd429b7bb3fa6b35c855a8f29bb24f9ec78fa0fa552c918337e3ea","imported_at":"2026-09-30T00:40:45.309486+08:00","name":"pg_stat_activity.xact_start","name_zh":"","slug":"pg_stat_activity-xact_start","summary":"Time when this process' current transaction was started, or null if no transaction is active. If the current query is the first of its transaction, this column is equal to the query_start column."}},"Definition":{"Collection":"metric","Key":"pg_stat_activity-xact_start","SourceDatabase":"center","Version":"18","SourceTable":"statistics_metric","SourceKey":"pg_stat_activity-xact_start","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"comparison_data":{"field":"xact_start","sql_type":"timestamp with time zone","units_mentioned":[],"view":"pg_stat_activity"},"comparison_hash":"4762a441445fb0a2e1bd0aeb5fd77224702a17702709e3ef679129eed3914c3f","description":["Time when this process' current transaction was started, or null if no transaction is active. If the current query is the first of its transaction, this column is equal to the query_start column."],"documented":true,"facts":[{"label":"View","value":"pg_stat_activity"},{"label":"Field","value":"xact_start"},{"label":"SQL type","value":"timestamp with time zone"},{"label":"Units named in the field definition","value":"Not specified"},{"label":"Reset observation","value":"No stats_reset field is documented for this view"}],"field":"xact_start","manual_html":"","manual_path":"/docs/18/monitoring-stats.html","related":[{"label":"pg_stat_activity columns","url":"/wiki/catalog/pg_stat_activity/?v=18"},{"label":"Statistics collection and reset functions","url":"/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"},"sections":[{"paragraphs":["The pg_stat_activity view will have one row per server process, showing information related to the current activity of that process."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT xact_start FROM pg_catalog.pg_stat_activity;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"signature":"SELECT xact_start FROM pg_catalog.pg_stat_activity;","source_only":false,"sources":[{"label":"PostgreSQL 18 English manual","path":"monitoring-stats.html","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","url":"/docs/18/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW"}],"sql_type":"timestamp with time zone","tables":[],"units_mentioned":[],"view":"pg_stat_activity"},"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#PG-STAT-ACTIVITY-VIEW"}]},"MeasuredEvidence":{}},"Text":{"Collection":"metric","Key":"pg_stat_activity-xact_start","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_activity.xact_start","Summary":"Time when this process' current transaction was started, or null if no transaction is active. If the current query is the first of its transaction, this column is equal to the query_start column.","BodyHTML":"\u003cp\u003eTime when this process\u0026#39; current transaction was started, or null if no transaction is active. If the current query is the first of its transaction, this column is equal to the query_start column.\u003c/p\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"807fa8423aac553e9e7ffe64ad4768819ec216474e56faa53c355e8a3bdb2f92","Payload":{"description":["Time when this process' current transaction was started, or null if no transaction is active. If the current query is the first of its transaction, this column is equal to the query_start column."],"manual_html":"","related":[{"label":"pg_stat_activity columns","url":"/wiki/catalog/pg_stat_activity/?v=18"},{"label":"Statistics collection and reset functions","url":"/docs/18/monitoring-stats.html"}],"sections":[{"paragraphs":["The pg_stat_activity view will have one row per server process, showing information related to the current activity of that process."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT xact_start FROM pg_catalog.pg_stat_activity;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"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}