How to increase the max query history stored

From: Bo Guo <bo(dot)guo(at)gisticinc(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: How to increase the max query history stored
Date: 2025-01-31 09:15:25
Message-ID: CADHFRcio+ziZ-j07dobdNPWpf8484UQJUKCLS=ptqh0PMY0Hbw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Fabrice Chapuis 2025-01-31 14:45:17 wal buffer optimisation
Previous Message Laurenz Albe 2025-01-31 06:37:00 Re: PostgreSQL Timeline Issue After Switchover with Pacemaker