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

This is awesome. Thanks Lennam

Regards,
Phani

From: lennam(at)incisivetechgroup(dot)com <lennam(at)incisivetechgroup(dot)com>
Sent: Tuesday, June 18, 2024 6:53 PM
To: Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com>; pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge

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/

[cid:image001(dot)png(at)01DAC1BC(dot)61F37AD0]

From: Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com<mailto:phani(dot)somayajula(at)pragmaticplay(dot)com>>
Sent: Tuesday, June 18, 2024 6:38 AM
To: pgsql-admin(at)lists(dot)postgresql(dot)org<mailto:pgsql-admin(at)lists(dot)postgresql(dot)org>
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<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#Compute>
Value
vCPUs
8
Memory (GiB)
32
Physical Processor
Intel Xeon 8375
CPU Architecture
x86

Storage<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#Storage>
Value
EBS Optimized
true
Max Bandwidth (Mbps) on (EBS)<https://handbook.vantage.sh/aws/services/ebs-pricing/>
10000
Max Throughput (MB/s) on EBS
1250.0
Max I/O Operations/second (IOPS)<https://handbook.vantage.sh/aws/concepts/io-operations/>
40000
Baseline Bandwidth (Mbps) on (EBS)<https://handbook.vantage.sh/aws/services/ebs-pricing/>
2500
Baseline Throughput (MB/s) on EBS
312.5
Baseline I/O Operations/second (IOPS)<https://handbook.vantage.sh/aws/concepts/io-operations/>
12000

Networking<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#Networking>
Value
Network Performance (Gibps)
Up to 12.5

Amazon<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#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 :
[cid:image002(dot)png(at)01DAC1BC(dot)61F37AD0]

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

Regards,
Phani