pg_stat_get_activity(pid integer, OUT datid oid, OUT pid integer, OUT usesysid oid, OUT application_name text, OUT state text, OUT query text, OUT wait_event_type text, OUT wait_event text, OUT xact_start timestamp with time zone, OUT query_start timestamp with time zone, OUT backend_start timestamp with time zone, OUT state_change timestamp with time zone, OUT client_addr inet, OUT client_hostname text, OUT client_port integer, OUT backend_xid xid, OUT backend_xmin xid, OUT backend_type text, OUT ssl boolean, OUT sslversion text, OUT sslcipher text, OUT sslbits integer, OUT ssl_client_dn text, OUT ssl_client_serial numeric, OUT ssl_issuer_dn text, OUT gss_auth boolean, OUT gss_princ text, OUT gss_enc boolean, OUT leader_pid integer, OUT query_id bigint)


Description

statistics: information about currently active backends

Parameters

Name Type Mode
pid integer IN
datid oid OUT
pid integer OUT
usesysid oid OUT
application_name text OUT
state text OUT
query text OUT
wait_event_type text OUT
wait_event text OUT
xact_start timestamp with time zone OUT
query_start timestamp with time zone OUT
backend_start timestamp with time zone OUT
state_change timestamp with time zone OUT
client_addr inet OUT
client_hostname text OUT
client_port integer OUT
backend_xid xid OUT
backend_xmin xid OUT
backend_type text OUT
ssl boolean OUT
sslversion text OUT
sslcipher text OUT
sslbits integer OUT
ssl_client_dn text OUT
ssl_client_serial numeric OUT
ssl_issuer_dn text OUT
gss_auth boolean OUT
gss_princ text OUT
gss_enc boolean OUT
leader_pid integer OUT
query_id bigint OUT

Definition