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/

From: Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com>
Sent: Tuesday, June 18, 2024 6:38 AM
To: 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 :

<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#Compute> Compute

Value

vCPUs

8

Memory (GiB)

32

Physical Processor

Intel Xeon 8375

CPU Architecture

x86

<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#Storage> Storage

Value

EBS Optimized

true

Max Bandwidth (Mbps) on
<https://handbook.vantage.sh/aws/services/ebs-pricing/> (EBS)

10000

Max Throughput (MB/s) on EBS

1250.0

Max I/O Operations/second
<https://handbook.vantage.sh/aws/concepts/io-operations/> (IOPS)

40000

Baseline Bandwidth (Mbps) on
<https://handbook.vantage.sh/aws/services/ebs-pricing/> (EBS)

2500

Baseline Throughput (MB/s) on EBS

312.5

Baseline I/O Operations/second
<https://handbook.vantage.sh/aws/concepts/io-operations/> (IOPS)

12000

<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#Networking>
Networking

Value

Network Performance (Gibps)

Up to 12.5

<https://instances.vantage.sh/aws/rds/db.m6id.2xlarge#Amazon> 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