postgresql后端数据统计函数

后端统计函数

函数	返回类型	描述
pg_stat_get_backend_idset()	int	设置当前活动的后端ID号
pg_stat_get_backend_activity(interger)	text	后端最近查询文本
pg_stat_get_backend_activity_start(interger)	timestamp with time zone	最近查询开始时间
pg_stat_get_backend_client_addr(integer)	inet	连接后端的客户端ip地址
pg_stat_get_backend_client_port(integer)	int	客户端用于通讯的TCP端口
pg_stat_get_backend_dbid	oid	连接后端的数据库oid
pg_stat_get_backend_pid(integer)	int	后端进程id
pg_stat_get_backend_start(integer)	timestamp with time zone	进程开始时间
pg_stat_get_backend_userid(integer)	oid	登录到后端的用户oid
pg_stat_get_backend_waiting(integer)	boolean	如果后端正等待锁则为真
pg_stat_get_backend_xact_start(integer)	timestamp with time zone	当前事务的开始时间

##显示pid以及所有后端的当前查询
select pg_stat_get_backend_pid(S.backendid) AS procpid,
pg_stat_get_backend_activity(S.backendid) AS current_query 
from (SELECT pg_stat_get_backend_idset() AS backendid) AS S