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 1t0mYN-00DB6A-Pf for pgsql-admin@arkaria.postgresql.org; Tue, 15 Oct 2024 18:45:55 +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 1t0mYL-00AEla-Dj for pgsql-admin@arkaria.postgresql.org; Tue, 15 Oct 2024 18:45:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0mYL-00AEjc-0m for pgsql-admin@lists.postgresql.org; Tue, 15 Oct 2024 18:45:53 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t0mYI-001339-Ta for pgsql-admin@lists.postgresql.org; Tue, 15 Oct 2024 18:45:52 +0000 Received: by mail-ed1-x52d.google.com with SMTP id 4fb4d7f45d1cf-5c9428152c0so7381897a12.1 for ; Tue, 15 Oct 2024 11:45:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729017949; x=1729622749; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=M3jrqusS9S+SCFZOxY0LBNK7lkkcPccED7yp8azKzV8=; b=mi7kFCyPC6zXotxzzkFZWyuJJmvGt3JbKkEI+m0h177ujQh3pjkzMfHt0+8umyLo6S j0O66xSrkG6reh41b0RjD0Ra0ZnvIRuowOP1XlTrJYAiV1IQNPC5Oc9Gqtd2858L/dyl AGXxOZ+p5ZY8mH2EAFN6fllpiIFVEkMH7lH58NPL1z1ErlYa1b45/18nF23iP80bAHET IXx9KaXKLi2N9lrzJtWg5NRkmK0mxEjT2fbv6qxe7hL55uGM6sQWLn+QwwHa63FGsCnb D+fv4PlwjuzOxHPU+oaq9ETZTCdWXcOJXnUa1FqNfyynHSYWfhCkXxmJkmueDCHnj8qn Z7mw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729017949; x=1729622749; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=M3jrqusS9S+SCFZOxY0LBNK7lkkcPccED7yp8azKzV8=; b=fMjTTY46C9cYnClA47Mn5LhVoKgBUZLpZX2eEZ6dply36jflFxwGTwk5DZBo9ar+ZC Rf0TeZDGvpRKvMrJ65WCZTL3RQV/P572zQAF5yje/bqxzKHduBLQqjTVrt8iTOTz7LSx GflAA9bAsAZRFxmcPe82y5pBpX49c1LMUkHZPtg2Y6of3YGdaEX+/yAgqCTmta5MAssC UN+0RlHA0bqHBzsYgAot5c+3tjbBdH6D4Lr76dHVvfrYNmWkq8uKov4PjaJLBBoj1ChU cGt0v+GoiQt+0TykntIBmXRp8dbHs8/b7AGa4kcgEEinvKOmdhJPI4sYQJ9eNbXrnhWc /JiQ== X-Gm-Message-State: AOJu0YwfsVEAQuT/FnRrHK3B3wDbWODmKM1D895p+1Pcyn3zwULh80vt PYvRtfFUPIWsOgGRcZQvZZtby5LfvptN8f0k1vmpBi19pfCjOU+4/88lQ2vfaZfu1bfDE2mVCWH XQC8NPlEexBt2I00t9KjXBDPS8Yagym06 X-Google-Smtp-Source: AGHT+IFNK9f9Q86pzg3RekFe/tdZ6sic3+8I9LFA3Xx9EfH28eDWk7o9MjrG4lMR9JTsJv43cdpEkrFQqt+PwIkjMmA= X-Received: by 2002:a05:6402:84b:b0:5c9:37b5:1090 with SMTP id 4fb4d7f45d1cf-5c9950359c7mr885724a12.9.1729017948826; Tue, 15 Oct 2024 11:45:48 -0700 (PDT) MIME-Version: 1.0 From: Loles Date: Tue, 15 Oct 2024 20:45:30 +0200 Message-ID: Subject: work_mem memory usage statistics To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000a677290624885cd1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a677290624885cd1 Content-Type: text/plain; charset="UTF-8" Hi team, Is there any statistics table or view in the PostgreSQL catalog, extension, or similar that collects and displays work_mem memory usage statistics? It would be interesting to know the use of the work_mem by user, application and/or database. Thanks in advance. Loles --000000000000a677290624885cd1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi team,

Is there any statistics = table or view in the PostgreSQL catalog, extension, or similar that collect= s and displays work_mem memory usage statistics? It would be interesting to= know the use of the work_mem by user, application and/or database.
Thanks in advance.

Loles
--000000000000a677290624885cd1--