PostgreSQL 9.2 ← 9.1
~ self_time: bigint → double precision~ total_time: bigint → double precision6 column description updatesCatalog description updated
← Catalog atlas / pg_stat_xact_user_functions
STATISTICS VIEW · Statistics view
pg_stat_xact_user_functions
Similar to pg_stat_user_functions, but counts only calls during the current transaction (which are not yet included in pg_stat_user_functions).
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_stat_xact_user_functionsPostgreSQL 19 beta 3 is a preview snapshot; the structure can still change before release.
| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
funcid |
oid |
OID of a function |
schemaname |
name |
Name of the schema this function is in |
funcname |
name |
Name of this function |
calls |
bigint |
Number of times this function has been called This view reports counters for the current transaction. |
total_time |
double precision |
Total time spent in this function and all other functions called by it, in milliseconds This view reports counters for the current transaction. |
self_time |
double precision |
Total time spent in this function itself, not including other functions called by it, in milliseconds This view reports counters for the current transaction. |
Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.
Common system columns 0
System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.
| Columns | Type | attnum |
|---|
Column evolution matrix
Hover a cell for the column typePresentAdded / type or attribute changeRemoved
| COLUMN | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
funcid |
– | ||||||||||||||||
schemaname |
– | ||||||||||||||||
funcname |
– | ||||||||||||||||
calls |
– | ||||||||||||||||
total_time |
– | ||||||||||||||||
self_time |
– |
9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.
Evolution timeline
Changes between adjacent majorsPostgreSQL 9.2 ← 9.1
PostgreSQL 9.1 ← 9.0Catalog added
Compare any two versions
Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.