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 <ayub.hp@xxxxxxxxx> wrote:
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
--------------------------------------------------------------------
Sun Certified Enterprise Architect 1.5Sun Certified Java Programmer 1.4
Microsoft Certified Systems Engineer 2000
http://in.linkedin.com/pub/ayub-khan/a/811/b81
mobile:+966-502674604
----------------------------------------------------------------------
It is proved that Hard Work and kowledge will get you close but attitude will get you there. However, it's the Love
of God that will put you over the top!!
It is proved that Hard Work and kowledge will get you close but attitude will get you there. However, it's the Love
of God that will put you over the top!!