Hi J,
Thank you for your detailed response and the practical advice.
To address your points:
*> CPU Utilization*: I understand that CPU consumption is not inherently
bad and can be indicative of the system doing its job. The query
performance from an end-user perspective is acceptable at the mom
Hi Christian,
Thank you for your interest and suggestion.
To give you an idea, here are the approximate row counts for the main
tables involved in the query:
- operations.requisitions: ~50,000 rows
- operations.requisition_items: ~150,000 rows
- operations.products: ~20,000 rows
- op
On 30.07.24 14:04, Kihaguru Gathura wrote:
Hi,
I am seeking advice on optimizing a PostgreSQL query that is consuming
a significant amount of CPU resources on my Dell PowerEdge T340
server. The server has an Intel Xeon E-2124 CPU @ 3.30GHz (4 cores, no
Hyper-Threading) and 16GB RAM, running Ope
On 30.07.24 19:29, Kihaguru Gathura wrote:
> Hi Claudio,
>
> Yes, I did run 'Explain Analyze' on the query to diagnose the
> performance issues. Based on the analysis, I created indexes on the
> relevant columns and ran a VACUUM on the tables. This resulted in an
> improvement, reducing CPU utiliz
On 30.07.24 14:04, Kihaguru Gathura wrote:
Hi,
I am seeking advice on optimizing a PostgreSQL query that is consuming
a significant amount of CPU resources on my Dell PowerEdge T340
server. The server has an Intel Xeon E-2124 CPU @ 3.30GHz (4 cores, no
Hyper-Threading) and 16GB RAM, runni
Hi Claudio,
Yes, I did run 'Explain Analyze' on the query to diagnose the performance
issues. Based on the analysis, I created indexes on the relevant columns
and ran a VACUUM on the tables. This resulted in an improvement, reducing
CPU utilization from 40% to 30%.
I haven't yet delved into expli
On Tue, Jul 30, 2024 at 03:04:54PM +0300, Kihaguru Gathura wrote:
> Hi,
>
> I am seeking advice on optimizing a PostgreSQL query that is consuming a
> significant amount of CPU resources on my Dell PowerEdge T340 server. The
> server has an Intel Xeon E-2124 CPU @ 3.30GHz (4 cores, no Hyper-Thread
Hi,
I am seeking advice on optimizing a PostgreSQL query that is consuming a
significant amount of CPU resources on my Dell PowerEdge T340 server. The
server has an Intel Xeon E-2124 CPU @ 3.30GHz (4 cores, no Hyper-Threading)
and 16GB RAM, running OpenBSD 7.3 (GENERIC.MP) #1125.
The query in que
8 matches
Mail list logo
