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...@gmail.com> 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.5 Sun 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!!
