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
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.
>
>
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
> 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
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
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