Hello, I have a following question: How should I create an index on my column when I'm using the supabase javascript sdk? I have a following query:

let query = this.supabase.from<SupabaseMessage>('request').select('*').order('created_at', { ascending: false }).limit(limit);

Then I created index in supabase's SQL editor:

CREATE INDEX idx_request_created_at 
ON request(created_at);

It works well in the SQL editor, however it looks like it doesn't work when I'm querying data via the sdk (the index is not used, it takes ages to fetch these data).

Can you check the query that is actually generated by PostgREST - it should be in the logs in the dashboard (Settings -> Logs -> Database)

I can see logs of api requests (when I use the POST/PATCH template), however I can't see any Database logs, there is just: No data returned from the query. I'm not sure how should I search in the Database Logs

Not sure why you don't see any logs - maybe your project is from BEFORE they introduced the logs

my project is aprox. 1 month old

not sure what to tell, I see plenty of log items in this page - I would contact support if I were you

As far as performance, do you have RLS on? That would not be used in UI query editor.

@User I have RLS off

Just to verify that this is the problem - can you run the query from the logs in your sql editor and confirm that it is indeed slow?

yea, I had to add

nullsFirst: true

to the

order

method

👍

thank you for the help guys!

It is interesting supabase imposes the nullslast by default where PostgREST api it is optional to even have the null parameter…

I didn't do it yet, feel free to do it, send the link to the issue to this topic please, I wanna see the conclusion