Re: [EXTERNAL] Need help with performance tuning pg12 on linux

2023-12-27 Thread Wilson, Maria Louise (LARC-E301)[RSES]
-> Seq Scan on visibility visibility_1 (cost=0.00..1.52 rows=52 width=16) (actual time=0.026..0.029 rows=52 loops=1) Buffers: shared hit=1 Planning Time: 7.354 ms Execution Time: 64789.927 ms (52 rows) From: Ranier Vilela Date: Wednesday, December 27, 2023

Re: [EXTERNAL] Need help with performance tuning pg12 on linux

2023-12-27 Thread Wilson, Maria Louise (LARC-E301)[RSES]
t;Wilson, Maria Louise (LARC-E301)[RSES]" Cc: Frits Hoogland , "pgsql-performance@lists.postgresql.org" Subject: Re: [EXTERNAL] Need help with performance tuning pg12 on linux CAUTION: This email originated from outside of NASA. Please take care when clicking links or opening

Need help with performance tuning pg12 on linux

2023-12-27 Thread Wilson, Maria Louise (LARC-E301)[RSES]
Hello folks! I am having a complex query slowing over time increasing in duration. If anyone has a few cycles that they could lend a hand or just point me in the right direction with this – I would surely appreciate it! Fairly beefy Linux server with Postgres 12 (latest) – this particular