Function pgStatGetActivity

  • Parameters

    Returns Setof<
        {
            from: {
                application_name: Text<0 | 1>;
                backend_start: Timestamptz<0 | 1>;
                backend_type: Text<0 | 1>;
                backend_xid: Xid<0 | 1>;
                backend_xmin: Xid<0 | 1>;
                client_addr: Inet<0 | 1>;
                client_hostname: Text<0 | 1>;
                client_port: Int4<0 | 1>;
                datid: Oid<0 | 1>;
                gss_auth: Bool<0 | 1>;
                gss_delegation: Bool<0 | 1>;
                gss_enc: Bool<0 | 1>;
                gss_princ: Text<0 | 1>;
                leader_pid: Int4<0 | 1>;
                pid: Int4<0 | 1>;
                query: Text<0 | 1>;
                query_id: Int8<0 | 1>;
                query_start: Timestamptz<0 | 1>;
                ssl: Bool<0 | 1>;
                ssl_client_dn: Text<0 | 1>;
                ssl_client_serial: Numeric<0 | 1>;
                ssl_issuer_dn: Text<0 | 1>;
                sslbits: Int4<0 | 1>;
                sslcipher: Text<0 | 1>;
                sslversion: Text<0 | 1>;
                state: Text<0 | 1>;
                state_change: Timestamptz<0 | 1>;
                usesysid: Oid<0 | 1>;
                wait_event: Text<0 | 1>;
                wait_event_type: Text<0 | 1>;
                xact_start: Timestamptz<0 | 1>;
            };
        },
    >