Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tqb6n-007VoE-Tp for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Mar 2025 17:03:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tqb6m-00C7Gf-LT for pgsql-hackers@arkaria.postgresql.org; Fri, 07 Mar 2025 17:03:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tqb6m-00C7GV-BO for pgsql-hackers@lists.postgresql.org; Fri, 07 Mar 2025 17:03:36 +0000 Received: from mail-qv1-xf36.google.com ([2607:f8b0:4864:20::f36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tqb6i-001XDt-25 for pgsql-hackers@postgresql.org; Fri, 07 Mar 2025 17:03:35 +0000 Received: by mail-qv1-xf36.google.com with SMTP id 6a1803df08f44-6e8f7019422so17405526d6.1 for ; Fri, 07 Mar 2025 09:03:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1741367011; x=1741971811; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=n4a4MVuVUgPkE/4aT3yBgppKmWq9hVefy812426n6wc=; b=GR+1r0FfIB3yUjbacmIqBssOZ3KWIspZ8t94gO+O6HW58RIHqmNJ2/8yG5XK6jUSi1 jKkJbNhyKsDC/Zkrf3NxVmhEXaDBYvNF6jIIc2SI4+yGNGjdDy6gy9lzkwi364Kf8VlB UgrlakaRbwcR/slzotQ1WvEKSP2tXGlBQ3gqJEZjLu83wtBS+18lRnuiMTuvlJn7+dJ/ dPFCxbdL1MZ06Qb9L+xBbbxvPf9ildfP9PD8RfNor07P7ljqEFwJ+8VoQrECJEUK1ZNn qOk+7XEgEcN9SVrAF68YEbgLU5AW7GKtogxwh+mXMmF7xk4A/y23UI+aZh3Yzztp/fsb 8eTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741367011; x=1741971811; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=n4a4MVuVUgPkE/4aT3yBgppKmWq9hVefy812426n6wc=; b=SXNvvBgYXW3JqUyCzsZJfNACXGKZDkhVU7LE+8dtKgipMxSkgzPJjxa4aTOwIHJ4fO +yV2yKcFYtHCHp0LkSd7PcQPKCNZgJ/WYaRdvFP3s46E5eDmDPCZq9s4lmiHtGLLzWsF 3xxq4uHQIA3MJA9gc0u0tiNzkBFG3KC6foRFTf5VyzvNZDA1SCLDA5vOg2UEKStoDpfw v1EyA2TmOcITuL0fa9oxI0H4A1sU2VNtxt8KNRwK/dfRAqLJtFwXSZVpYJaQUN0cXjmJ PI6hDwngR5BxtnHwSaY/y6s4l1iIaH36Hp4k8/3UKkA76hDIPREztFEojQceCqGuO9rM kCbg== X-Forwarded-Encrypted: i=1; AJvYcCWs0zpI4UB0xw0E6vAClB8ceBTusJPqjofzyUtRStVxuHdBhijqu6oZPUUIX49HRGkt8vliSwVV+Ij1uy6Z@postgresql.org X-Gm-Message-State: AOJu0Yz06xhceSsJE96QynqQLWzs8Jk+eJ51Ue8Bj8eAF6ZS2lTr6+ZJ ZJkcHUM6HytKHXkus/0Wu4VaeYg718V06e25GvqnFMcf6S2G4dc7OGlSLOLd5PoSD8dulgRcm+n V2CZvwJptHyMgD3hyqstcTeBxs4mOQ6GrHVpN X-Gm-Gg: ASbGncsvHsymLCasmJKVJwgIdTKpk+0fVmh8FMNxxW/qylQK02k9UAMVxdub4B60MxE mU1HvTpDiceiMol5N22ZiHeSbUWdXpoPmBbvES5FcTcS1Yu0I/vDhi/2DOCVKtLm/+BxxryN6St ZpXLs1039LxsFwSjFPjRS8bI+6 X-Google-Smtp-Source: AGHT+IFEd4e0+wUhw1sA6OLZNNiaXnGKu/ywE0RUjqi2eEzNXgmv3U/zrJitT0MSbHRDZbvM3qUD5JHfdo0DsMTfIaM= X-Received: by 2002:a05:6214:230b:b0:6e8:c713:321f with SMTP id 6a1803df08f44-6e9006ad612mr50999596d6.35.1741367011331; Fri, 07 Mar 2025 09:03:31 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Jacob Champion Date: Fri, 7 Mar 2025 09:03:18 -0800 X-Gm-Features: AQ5f1Jplrcr88l1Pvotn78r9CwOpO8wlpXjispDosDlOKNtV3C86wrb8n5qv7ig Message-ID: Subject: Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible To: Andres Freund Cc: Michael Paquier , Robert Haas , Noah Misch , Andrew Dunstan , PostgreSQL Hackers , Euler Taveira , Daniel Gustafsson Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Mar 7, 2025 at 8:38=E2=80=AFAM Andres Freund w= rote: > FWIW, I continue to think that this is a misuse of wait events. We should= n't > use them as a poor man's general purpose tracing framework. Well, okay. That's frustrating. If I return to the original design, but replace all of the high-level wait events with calls to pgstat_report_activity(), does that work? --Jacob