agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedPostgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
5+ messages / 3 participants
[nested] [flat]
* Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
@ 2024-06-18 10:38 Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
0 siblings, 2 replies; 5+ messages in thread
From: Phani Prathyush Somayajula @ 2024-06-18 10:38 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
@ 2024-06-18 11:40 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
1 sibling, 1 reply; 5+ messages in thread
From: Laurenz Albe @ 2024-06-18 11:40 UTC (permalink / raw)
To: Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Tue, 2024-06-18 at 10:38 +0000, Phani Prathyush Somayajula wrote:
> I have an AWS RDS instance
>
> 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.
>
> I just want to analyse if the parameters that I set are optimal to the application or not.
I don't think that twiddling the parameters will make a lot of difference there.
The exception could be if you are retrieving results with a cursor; then setting
"cursor_tuple_fraction" to 1 could make a difference.
Other than that, you should use auto_explain with "auto_explain.log_analyze = on"
and "auto_explain.log_buffers = on" to capture an execution plan from the slow
execution with DBeaver or your application. Examining that plan should show what
is going on.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
@ 2024-06-18 12:10 Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 5+ messages in thread
From: Phani Prathyush Somayajula @ 2024-06-18 12:10 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hello @Laurenz,
Thank you for your quick response. However, the parameters are already in place as you said. Although, there is no issue with the update statement. The Execution Plan and the usage of index is optimal for the query. I just want to verify if any connection pooling is required from database side
Regards,
Phani
-----Original Message-----
From: Laurenz Albe <laurenz.albe@cybertec.at>
Sent: Tuesday, June 18, 2024 5:11 PM
To: Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>; pgsql-admin@lists.postgresql.org
Subject: Re: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
On Tue, 2024-06-18 at 10:38 +0000, Phani Prathyush Somayajula wrote:
> I have an AWS RDS instance
>
> 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.
>
> I just want to analyse if the parameters that I set are optimal to the application or not.
I don't think that twiddling the parameters will make a lot of difference there.
The exception could be if you are retrieving results with a cursor; then setting "cursor_tuple_fraction" to 1 could make a difference.
Other than that, you should use auto_explain with "auto_explain.log_analyze = on"
and "auto_explain.log_buffers = on" to capture an execution plan from the slow execution with DBeaver or your application. Examining that plan should show what is going on.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
@ 2024-06-18 13:22 lennam@incisivetechgroup.com
parent: Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
1 sibling, 1 reply; 5+ messages in thread
From: lennam@incisivetechgroup.com @ 2024-06-18 13:22 UTC (permalink / raw)
To: 'Phani Prathyush Somayajula' <phani.somayajula@pragmaticplay.com>; pgsql-admin@lists.postgresql.org
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@pragmaticplay.com>
Sent: Tuesday, June 18, 2024 6:38 AM
To: pgsql-admin@lists.postgresql.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
Attachments:
[image/png] image002.png (558.4K, ../../03aa01dac182$a4879870$ed96c950$@incisivetechgroup.com/3-image002.png)
download | view image
[image/png] image003.png (57.3K, ../../03aa01dac182$a4879870$ed96c950$@incisivetechgroup.com/4-image003.png)
download | view image
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge
@ 2024-06-18 14:42 Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
parent: lennam@incisivetechgroup.com
0 siblings, 0 replies; 5+ messages in thread
From: Phani Prathyush Somayajula @ 2024-06-18 14:42 UTC (permalink / raw)
To: lennam@incisivetechgroup.com <lennam@incisivetechgroup.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
This is awesome. Thanks Lennam
Regards,
Phani
From: lennam@incisivetechgroup.com <lennam@incisivetechgroup.com>
Sent: Tuesday, June 18, 2024 6:53 PM
To: Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>; pgsql-admin@lists.postgresql.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.png@01DAC1BC.61F37AD0]
From: Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com<mailto:phani.somayajula@pragmaticplay.com>>
Sent: Tuesday, June 18, 2024 6:38 AM
To: pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.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.png@01DAC1BC.61F37AD0]
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 (558.4K, ../../AS4PR10MB55450CE22C30A9BF3D8B5A808DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/3-image001.png)
download | view image
[image/png] image002.png (57.3K, ../../AS4PR10MB55450CE22C30A9BF3D8B5A808DCE2@AS4PR10MB5545.EURPRD10.PROD.OUTLOOK.COM/4-image002.png)
download | view image
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2024-06-18 14:42 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-18 10:38 Postgres RDS DB Parameters ::INSTANCE CLASS : db.m6id.2xlarge Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
2024-06-18 11:40 ` Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-18 12:10 ` Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
2024-06-18 13:22 ` lennam@incisivetechgroup.com
2024-06-18 14:42 ` Phani Prathyush Somayajula <phani.somayajula@pragmaticplay.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox