目录

pg_stat_xact_user_functions

一个统计视图，显示当前事务期间执行的函数的统计信息

pg_stat_xact_user_functions 是一个 统计视图，显示当前数据库中当前事务期间每个跟踪函数的执行统计信息。

pg_stat_xact_user_functions 在 PostgreSQL 9.1 中添加。

按 PostgreSQL 版本定义

pg_stat_xact_user_functions (PostgreSQL 17)

         View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Collation | Nullable | Default 
------------+------------------+-----------+----------+---------
 funcid     | oid              |           |          | 
 schemaname | name             |           |          | 
 funcname   | name             |           |          | 
 calls      | bigint           |           |          | 
 total_time | double precision |           |          | 
 self_time  | double precision |           |          |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 16)

         View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Collation | Nullable | Default 
------------+------------------+-----------+----------+---------
 funcid     | oid              |           |          | 
 schemaname | name             |           |          | 
 funcname   | name             |           |          | 
 calls      | bigint           |           |          | 
 total_time | double precision |           |          | 
 self_time  | double precision |           |          |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 15)

         View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Collation | Nullable | Default 
------------+------------------+-----------+----------+---------
 funcid     | oid              |           |          | 
 schemaname | name             |           |          | 
 funcname   | name             |           |          | 
 calls      | bigint           |           |          | 
 total_time | double precision |           |          | 
 self_time  | double precision |           |          |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 14)

         View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Collation | Nullable | Default 
------------+------------------+-----------+----------+---------
 funcid     | oid              |           |          | 
 schemaname | name             |           |          | 
 funcname   | name             |           |          | 
 calls      | bigint           |           |          | 
 total_time | double precision |           |          | 
 self_time  | double precision |           |          |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 13)

         View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Collation | Nullable | Default 
------------+------------------+-----------+----------+---------
 funcid     | oid              |           |          | 
 schemaname | name             |           |          | 
 funcname   | name             |           |          | 
 calls      | bigint           |           |          | 
 total_time | double precision |           |          | 
 self_time  | double precision |           |          |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 12)

         View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Collation | Nullable | Default 
------------+------------------+-----------+----------+---------
 funcid     | oid              |           |          | 
 schemaname | name             |           |          | 
 funcname   | name             |           |          | 
 calls      | bigint           |           |          | 
 total_time | double precision |           |          | 
 self_time  | double precision |           |          |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 11)

         View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Collation | Nullable | Default 
------------+------------------+-----------+----------+---------
 funcid     | oid              |           |          | 
 schemaname | name             |           |          | 
 funcname   | name             |           |          | 
 calls      | bigint           |           |          | 
 total_time | double precision |           |          | 
 self_time  | double precision |           |          |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 10)

         View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Collation | Nullable | Default 
------------+------------------+-----------+----------+---------
 funcid     | oid              |           |          | 
 schemaname | name             |           |          | 
 funcname   | name             |           |          | 
 calls      | bigint           |           |          | 
 total_time | double precision |           |          | 
 self_time  | double precision |           |          |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 9.6)

View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Modifiers 
------------+------------------+-----------
 funcid     | oid              | 
 schemaname | name             | 
 funcname   | name             | 
 calls      | bigint           | 
 total_time | double precision | 
 self_time  | double precision |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 9.5)

View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Modifiers 
------------+------------------+-----------
 funcid     | oid              | 
 schemaname | name             | 
 funcname   | name             | 
 calls      | bigint           | 
 total_time | double precision | 
 self_time  | double precision |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 9.4)

View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Modifiers 
------------+------------------+-----------
 funcid     | oid              | 
 schemaname | name             | 
 funcname   | name             | 
 calls      | bigint           | 
 total_time | double precision | 
 self_time  | double precision |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 9.3)

View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Modifiers 
------------+------------------+-----------
 funcid     | oid              | 
 schemaname | name             | 
 funcname   | name             | 
 calls      | bigint           | 
 total_time | double precision | 
 self_time  | double precision |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 9.2)

View "pg_catalog.pg_stat_xact_user_functions"
   Column   |       Type       | Modifiers 
------------+------------------+-----------
 funcid     | oid              | 
 schemaname | name             | 
 funcname   | name             | 
 calls      | bigint           | 
 total_time | double precision | 
 self_time  | double precision |

文档: pg_stat_xact_user_functions

pg_stat_xact_user_functions (PostgreSQL 9.1)

View "pg_catalog.pg_stat_xact_user_functions"
   Column   |  Type  | Modifiers 
------------+--------+-----------
 funcid     | oid    | 
 schemaname | name   | 
 funcname   | name   | 
 calls      | bigint | 
 total_time | bigint | 
 self_time  | bigint |

文档: pg_stat_xact_user_functions

变更历史

分类

统计/监控视图

另请参阅

track_functions，pg_stat_user_functions

反馈

提交您对 "pg_stat_xact_user_functions" 的任何评论、建议或更正 此处。