pg_stat_xact_user_functions.funcid

Description

Source-defined field pg_stat_xact_user_functions.funcid. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.

View

pg_stat_xact_user_functions

Field

funcid

Field evidence

Source declaration; not individually enumerated by the manual

Expression declared in

pg_stat_xact_user_functions

Usage

SELECT funcid FROM pg_catalog.pg_stat_xact_user_functions;

View semantics

Similar to pg_stat_user_functions, but counts only calls during the current transaction (which are not yet included in pg_stat_user_functions).

Collection and transaction context

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.

Exact source expression

No per-field definition, effective SQL type, unit, or reset rule is inferred from this expression.

P.oid

Complete source view definition

CREATE VIEW pg_stat_xact_user_functions AS
SELECT
            P.oid AS funcid,
            N.nspname AS schemaname,
            P.proname AS funcname,
            pg_stat_get_xact_function_calls(P.oid) AS calls,
            pg_stat_get_xact_function_total_time(P.oid) AS total_time,
            pg_stat_get_xact_function_self_time(P.oid) AS self_time
    FROM pg_proc P LEFT JOIN pg_namespace N ON (N.oid = P.pronamespace)
    WHERE P.prolang != 12  -- fast check to eliminate built-in functions
          AND pg_stat_get_xact_function_calls(P.oid) IS NOT NULL;

Related entries

• pg_stat_xact_user_functions columns

Documentation and source

• PostgreSQL 18 English manual
• 18.6 source archive · src/backend/catalog/system_views.sql

Compare versions

PostgreSQL 17 → 18: unchanged.

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

• pg_stat_xact_user_functions.calls
• pg_stat_xact_user_functions.funcname
• pg_stat_xact_user_functions.schemaname
• pg_stat_xact_user_functions.self_time
• pg_stat_xact_user_functions.total_time