From: | Phani Prathyush Somayajula <phani(dot)somayajula(at)pragmaticplay(dot)com> |
---|---|
To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge |
Date: | 2024-06-18 10:38:10 |
Message-ID: | AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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:image001(dot)png(at)01DAC19A(dot)295FA7B0]
I just want to analyse if the parameters that I set are optimal to the application or not.
Regards,
Phani
Attachment | Content-Type | Size |
---|---|---|
![]() |
image/png | 61.2 KB |
![]() |
image/png | 23.7 KB |
Screenshot 2024-06-15 194035.png | image/png | 111.0 KB |
Screenshot 2024-06-15 194136.png | image/png | 94.8 KB |
Screenshot 2024-06-15 194239.png | image/png | 112.7 KB |
Screenshot 2024-06-15 194330.png | image/png | 89.9 KB |
![]() |
image/png | 1.1 KB |
![]() |
image/png | 52.5 KB |
![]() |
image/png | 22.1 KB |
![]() |
image/png | 35.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2024-06-18 11:40:32 | Re: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge |
Previous Message | Alexander Lipatov | 2024-06-17 15:40:38 | Re: Custom ordering operator for type xid |