Re: dexter on AWS RDS auto tune queries

2021-06-07 Thread Ayub Khan
Julien, Thank you for the pointer. I will change the data type and verify the query again. -Ayub On Mon, Jun 7, 2021 at 7:51 AM Ayub Khan wrote: > > Other than Dexter, Is there an auto tune or query performance indicator > for postgres ? > Also which are the most commonly used monitoring (slow

Re: dexter on AWS RDS auto tune queries

2021-06-07 Thread Julien Rouhaud
Please don't top post here. On Mon, Jun 7, 2021 at 3:50 PM Ayub Khan wrote: > > @Christophe: yes I am using RDS performance insights, however it might be > more helpful if it could give more info about the slowness of the queries and > what improvements could be done to the queries itself. > >

Re: dexter on AWS RDS auto tune queries

2021-06-07 Thread Ayub Khan
Thank you @Julian @Christophe: yes I am using RDS performance insights, however it might be more helpful if it could give more info about the slowness of the queries and what improvements could be done to the queries itself. I am using pgMusted to analyze a slow query and there the suggestion is

Re: dexter on AWS RDS auto tune queries

2021-06-06 Thread Christophe Pettus
> On Jun 6, 2021, at 21:51, Ayub Khan wrote: > Other than Dexter, Is there an auto tune or query performance indicator for > postgres ? Generally, auto-creating indexes isn't a great idea. I respect the work that went into Dexter, but it's much better to find the queries and study them, the

Re: dexter on AWS RDS auto tune queries

2021-06-06 Thread Julien Rouhaud
Hi, On Mon, Jun 7, 2021 at 12:52 PM Ayub Khan wrote: > > Other than Dexter, Is there an auto tune or query performance indicator for > postgres ? It depends. If you're on AWS or any other cloud, probably nothing apart from tools based on logs or standard SQL execution (so nothing based on thir

dexter on AWS RDS auto tune queries

2021-06-06 Thread Ayub Khan
Other than Dexter, Is there an auto tune or query performance indicator for postgres ? Also which are the most commonly used monitoring (slow query, cpu, index creation for missing indexs ) tools being used for postgres ? --Ayub