pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFrom: Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
Date: Tue, 18 Jun 2024 10:38:10 +0000
Message-ID: <AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <AS4PR10MB55453EC83E81241722755F8E8D0E2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM>
References: <MAXPR01MB3328F773227E6C76B06CF21BFC22A@MAXPR01MB3328.INDPRD01.PROD.OUTLOOK.COM>
<AS4PR10MB55453EC83E81241722755F8E8D0E2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM>
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.png@01DAC19A.295FA7B0]
I just want to analyse if the parameters that I set are optimal to the application or not.
Regards,
Phani
Attachments:
[image/png] image001.png (57.3K, ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/3-image001.png)
download | view image
[image/png] Screenshot 2024-06-18 154736.png (61.2K, ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/4-Screenshot%202024-06-18%20154736.png)
download | view image
[image/png] Screenshot 2024-06-15 194023.png (23.7K, ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/5-Screenshot%202024-06-15%20194023.png)
download | view image
[image/png] Screenshot 2024-06-15 194035.png (111.0K, ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/6-Screenshot%202024-06-15%20194035.png)
download | view image
[image/png] Screenshot 2024-06-15 194136.png (94.8K, ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/7-Screenshot%202024-06-15%20194136.png)
download | view image
[image/png] Screenshot 2024-06-15 194239.png (112.7K, ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/8-Screenshot%202024-06-15%20194239.png)
download | view image
[image/png] Screenshot 2024-06-15 194330.png (89.9K, ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/9-Screenshot%202024-06-15%20194330.png)
download | view image
[image/png] Screenshot 2024-06-16 172258.png (1.1K, ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/10-Screenshot%202024-06-16%20172258.png)
download | view image
[image/png] Screenshot 2024-06-18 112503.png (52.5K, ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/11-Screenshot%202024-06-18%20112503.png)
download | view image
[image/png] Screenshot 2024-06-18 152249.png (22.1K, ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/12-Screenshot%202024-06-18%20152249.png)
download | view image
[image/png] Screenshot 2024-06-18 152328.png (35.7K, ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/13-Screenshot%202024-06-18%20152328.png)
download | view image
view thread (5+ messages) latest in thread
Message-ID: <AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM>
Permalink: ../AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/
Also on: postgresql.org/message-id/AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: phani.somayajula@pragmaticplay.com, pgsql-admin@lists.postgresql.org
Subject: Re: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
In-Reply-To: <AS4PR10MB55452ECA456BF214261EB8398DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox