hi, Le ven. 3 févr. 2023 à 11:33, chanukya SDS <chanukya...@gmail.com> a écrit :
> 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. > pgsql-hackers isn't a suitable mailing list for this question, you should use psql-general or psql-performance. please also look at https://wiki.postgresql.org/wiki/Slow_Query_Questions for details to provide. note that if you're not really sure of what index would help and don't want to disturb your database too much (and assuming you don't have another environment to test things on), you can use hypopg to create hypothetical indexes and see how many index definitions would behave without actually creating them: https://github.com/HypoPG/hypopg >
