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 1tdn7q-009VIv-17 for pgsql-admin@arkaria.postgresql.org; Fri, 31 Jan 2025 09:15:46 +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 1tdn7p-00GmhI-6V for pgsql-admin@arkaria.postgresql.org; Fri, 31 Jan 2025 09:15:45 +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 1tdn7o-00GmhA-OU for pgsql-admin@lists.postgresql.org; Fri, 31 Jan 2025 09:15:44 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tdn7l-002UVM-2s for pgsql-admin@lists.postgresql.org; Fri, 31 Jan 2025 09:15:44 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-ab2bb0822a4so331789966b.3 for ; Fri, 31 Jan 2025 01:15:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gisticinc-com.20230601.gappssmtp.com; s=20230601; t=1738314940; x=1738919740; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=9GR8+tehascgtF8ox5F1qG4DR/QkYse+bhjIIOKl5bk=; b=qAruRNXJVbar66mhqm53R7fWSvgBVAfDpt83jhCYreYw6PCUxJ7ZBXFXPfIl+9uQfy KNEUCHPf+jXzeuPbX5oiIiBTs/oCUvoZLUjJjGG8pPA0gC1JE3X9T7JuSPiHtQO5PF0y kJdJFl1I1dYXAKcgwqs7sSMdJTgItlTyokv1LbVz3oEOMQGW2Q5kpA+KhyFYKCqj1jVy afLqAJ5VYCrGRe0S9RaWWHcwTIABGAaXj+V37REJNXt25wHj3kpiylWnK7JSKBtX/FX1 jC7580n8YDI2P9hvr6rzE3dmthar+jV9HyaC9k/WhNVW2T+x1vQKio5Wzr9CRdcf6s/7 g3VQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738314940; x=1738919740; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=9GR8+tehascgtF8ox5F1qG4DR/QkYse+bhjIIOKl5bk=; b=GNJ/C2xzayVRiQYZosWWKXcT6Bt6tJ3aKS4urxPWkSoJSRAFR7rco3FsffyNMaQMvY PaGNb7tAcNiMjwJwR78/gaWkDnvisz7/KkNCUbR+flCqThKjqFfgF7LnOAcJvWouq87l ctEJMO14j/l7GX2zu5U6IDRBQl4cRQn+7G3lGQ3ZfKJLWeYtz62WXO8rjltn60LxHPv3 +Na5wC+mUaseZupef7S/12sD8mkK8sNPnChYrFf0whzyNVgm8pgK8F2kG7PAKmRdDlim ntNxvxuPU9lJTxplCrAyJNRyASrbv8IrAPVcg3dDY/cc5BTRmU+vjqyz4MQCGyPQwBbU DvSg== X-Gm-Message-State: AOJu0YzbvhnUhyZ3+oYtiFXalwBKk9SLxY9wA4MNz/MEohlwsrFMwzrS q2uk9v7zb+G3T1z6vgxAr9RhBlyp+y8DN8EilY/FcHphTRK1ptohIZ9DrF40Zo7V6kXVRjfMl68 LIHXuOJVWLo1Bdqw7TMvLDeawGVOblMY5g3HG/IFk3eLLYRL66FPySw== X-Gm-Gg: ASbGncuu/RqnrBHbR9EuWN1mWQMyNfU6wlp7nEcjLkphQKPn07JP1kPrh3CtbLr4OUk r7XbXQM6cnyw2BZFVvlYQLoIlnZJnH4ITfSPd3G9cDihMkfwENDP76jh88qJiaec09pfSbZE= X-Google-Smtp-Source: AGHT+IFpz6DQBBJyOMUWZZZ9rDq+zH0vyeigO3sn3vtlaNM70PIpX9zo4gzTaNM7i7b/0tdJZNr5/qV2KxW43RvWqZ0= X-Received: by 2002:a17:906:1853:b0:ab6:dd6b:c337 with SMTP id a640c23a62f3a-ab6dd6bc372mr758599766b.10.1738314940498; Fri, 31 Jan 2025 01:15:40 -0800 (PST) MIME-Version: 1.0 From: Bo Guo Date: Fri, 31 Jan 2025 02:15:25 -0700 X-Gm-Features: AWEUYZl7l2qw98n-2nGFBJZXr2gf08pCcg_Y72L4fLRxNGuElofQHQZZNeeyeaY Message-ID: Subject: How to increase the max query history stored To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000896723062cfcfcb5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000896723062cfcfcb5 Content-Type: text/plain; charset="UTF-8" Hello there, The default size of 20 history queries is somewhat limiting. So, I tried to increase the size on my Linux server-installed (Ubuntu 22.04.5 LTS, Linux-6.8.12-7-pve-x86_64-with-glibc2.35) PGAdmn 8.14. I followed the instructions below to no avail. I appreciate any help! 1. Create /var/lib/pgadmin/config_local.py and add ON_DISK_HISTORY = True MAX_QUERY_HIST_STORED = 5000 # Set to your desired number of queries 2. Restart PGAdmin 4 with sudo systemctl restart apache2 Thanks! Bo --000000000000896723062cfcfcb5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello there,

The=C2=A0default size of 20 history quer= ies is somewhat limiting. So, I tried to increase the size on my Linux serv= er-installed (Ubuntu 22.04.5 LTS, Linux-6.8.12-7-pve-x86_64-with-gli= bc2.35)=C2=A0PGAdmn 8.14.=C2=A0 I followed the instructions below to no = avail.=C2=A0 I appreciate any help!

1. Create /var/lib/pgadm= in/config_local.py and add
ON_DISK_HISTORY =3D True
MAX= _QUERY_HIST_STORED =3D 5000 =C2=A0# Set to your desired number of queries

2. Restart PGAdmin 4 with
sudo system= ctl restart apache2

Thanks!

Bo
--000000000000896723062cfcfcb5--