On Fri, Feb 3, 2023 at 9:03 AM chanukya SDS <chanukya...@gmail.com> wrote: > > Hey All, > > I have a query like below > > SELECT * FROM data WHERE val=trunc(val) AND > acc_id='kfd50ed6-0bc3-44a9-881f-ec89713fdd80'::uuid ORDER BY ct DESC LIMIT 10; > > table structure is > > data > (id uuid, > c_id uuid, > acc_id uuid, > val numeric, > ct timestamptz); > > Can you please help me to write an index? > > or Can someone write an index and revert here.. > > its very urgent for me.
Thanks for reaching out. I think the question is more generic without the problem being described. Is the SELECT query taking more time? If yes, why? Have you looked at EXPLAIN (ANALYZE...) output? Have you tried to tune/vary configuration settings to see if it helps? Also, the best place to ask this question is pgsql-general or pgsql-sql. -- Bharath Rupireddy PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com
