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
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.
>
>
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
On 6/6/21 7:49 PM, Dean Gibson (DB Administrator) wrote:
> On 2021-05-29 13:35, Andrew Dunstan wrote:
>> On 5/29/21 3:59 PM, Dean Gibson (DB Administrator) wrote:
>>> Meanwhile, I've been doing some checking. If I remove "CAST(
>>> license_status AS CHAR ) = 'A'", the problem disappears. Changi
On 2021-06-07 04:52, Andrew Dunstan wrote:
On 6/6/21 7:49 PM, Dean Gibson (DB Administrator) wrote:
On 2021-05-29 13:35, Andrew Dunstan wrote:
On 5/29/21 3:59 PM, Dean Gibson (DB Administrator) wrote:
... If I remove "CAST( license_status AS CHAR ) = 'A'", ...
Why are you using this expressi
