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. Changing the
JOIN to a RIGHT JOIN, & replacing WHERE with ON, also "solves"
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
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
> 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
