{"Entry":{"collection":"catalog","key":"pg_stat_user_functions","name":"pg_stat_user_functions","aliases":[],"metadata":{"changed_in":["9.2","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.3","order":false,"removed":[],"status":"added","to":"8.4","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.4","order":false,"removed":[],"status":"coverage","to":"9.0","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.1","listing":[],"order":false,"removed":[],"status":"changed","to":"9.2","types":[{"from":"bigint","name":"self_time","to":"double precision"},{"from":"bigint","name":"total_time","to":"double precision"}],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":["stats_reset"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":7,"content_hash":"18413d3f6484f439b507389b4d65b4fd5ba45faca9e7b3dd32bb54210d064f28","first_version":"8.4","imported_at":"2026-09-30T00:40:56.017554+08:00","kind":"statistics","last_version":"20","name":"pg_stat_user_functions","position":112,"present_in":["8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:75025596ce1ba1eac56711e4679ba5f91a61e2fc8e773b682dd9f8ce345b82cb","summary":"The pg_stat_user_functions view will contain one row for each tracked function, showing statistics about executions of that function.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_user_functions","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_user_functions","SourceRevision":"english-manuals:75025596ce1ba1eac56711e4679ba5f91a61e2fc8e773b682dd9f8ce345b82cb","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of a function","description_zh":"","documented":true,"documented_name":"funcid","hidden":false,"name":"funcid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"Name of the schema this function is in","description_zh":"","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":3,"description":"Name of this function","description_zh":"","documented":true,"documented_name":"funcname","hidden":false,"name":"funcname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":4,"description":"Number of times this function has been called","description_zh":"","documented":true,"documented_name":"calls","hidden":false,"name":"calls","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":5,"description":"Total time spent in this function and all other functions called by it, in milliseconds","description_zh":"","documented":true,"documented_name":"total_time","hidden":false,"name":"total_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701},{"array_dimensions":0,"attnum":6,"description":"Total time spent in this function itself, not including other functions called by it, in milliseconds","description_zh":"","documented":true,"documented_name":"self_time","hidden":false,"name":"self_time","not_null":false,"references":"","type":"double precision","type_modifier":-1,"type_oid":701}],"description":"The pg_stat_user_functions view will contain one row for each tracked function, showing statistics about executions of that function. The track_functions parameter controls exactly which functions are tracked.","description_zh":"","doc":{"anchor":"PG-STAT-USER-FUNCTIONS-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["funcid","schemaname","funcname","calls","total_time","self_time"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-USER-FUNCTIONS-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["funcid","schemaname","funcname","calls","total_time","self_time"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_user_functions","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_user_functions","Summary":"pg_stat_user_functions视图将为每一个被追踪的函数包含一行，该行显示有关该函数执行的统计信息。track_functions参数控制到底哪些函数被跟踪。","BodyHTML":"\u003cp\u003epg_stat_user_functions视图将为每一个被追踪的函数包含一行，该行显示有关该函数执行的统计信息。track_functions参数控制到底哪些函数被跟踪。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"eda90ea14f4f9b345745e8171288b32989610a63a55d5e562a3757b2082cfaa6","Payload":{"columns":[{"description_zh":"函数的OID","name":"funcid","type":"oid","zh_from":"doc"},{"description_zh":"这个函数所在的模式的名称","name":"schemaname","type":"name","zh_from":"doc"},{"description_zh":"这个函数的名称","name":"funcname","type":"name","zh_from":"doc"},{"description_zh":"这个函数已经被调用的次数","name":"calls","type":"bigint","zh_from":"doc"},{"description_zh":"在这个函数以及它所调用的其他函数中花费的总时间，以毫秒计","name":"total_time","type":"double precision","zh_from":"doc"},{"description_zh":"在这个函数本身花费的总时间，不包括被它调用的其他函数，以毫秒计","name":"self_time","type":"double precision","zh_from":"doc"}],"description_zh":"pg_stat_user_functions视图将为每一个被追踪的函数包含一行，该行显示有关该函数执行的统计信息。track_functions参数控制到底哪些函数被跟踪。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}