Re: Index problem Need an urgent fix

On Fri, Feb 3, 2023 at 9:03 AM chanukya SDS <chanukyasds(at)gmail(dot)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