RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge

[<lennam@xxxxxxxxxxxxxxxxxxxxx>]

Using following url  provide  PostgreSQL version , type of application ,no CPU  memory , max connection , that will calculate parameter , setup like that ,  re-load the cluster

 

https://pgtune.leopard.in.ua/

 

 

From: Phani Prathyush Somayajula <phani.somayajula@xxxxxxxxxxxxxxxxx>
Sent: Tuesday, June 18, 2024 6:38 AM
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge

 

Hello All,

 

I have an AWS RDS instance of type db.m6id.2xlarge ( 8 vCPU and 32 GB RAM)

 

My Instance specifications are :

 

Compute	Value
vCPUs	8
Memory (GiB)	32
Physical Processor	Intel Xeon 8375
CPU Architecture	x86

 

Storage	Value
EBS Optimized	true
Max Bandwidth (Mbps) on (EBS)	10000
Max Throughput (MB/s) on EBS	1250.0
Max I/O Operations/second (IOPS)	40000
Baseline Bandwidth (Mbps) on (EBS)	2500
Baseline Throughput (MB/s) on EBS	312.5
Baseline I/O Operations/second (IOPS)	12000

 

Networking	Value
Network Performance (Gibps)	Up to 12.5

 

Amazon	Value
Generation	current
Instance Type	db.m6id.2xlarge
Family	General purpose
Name	M6ID Double Extra Large
Normalization Factor	16

 

 

I just want to crosscheck if the parameter that I set are up to the mark. For I’ve verified on couple of portals, and yet the issue is that the CPU consumption is more but not the IOPS, not the EBS throughput / iops

 

 

Now I’ll share my issue:

 

We are seeing a lot of CPU consumption where we’re load testing our application. The query which is taking a lot of time is running less than 1ms if I run through my psql client on the server and is taking 162ms if I run it from dBeaver.

Evidences – attached,

 

Querry :

 

I just want to analyse if the parameters that I set are optimal to the application or not.

 

Regards,

Phani