Hi everyone, need some advice how to create/add indexes on the existing table. I created the table some time ago and need to add indexes on columns as the query is getting heavier. I tried to run

create index

command but I got "ERROR: must be owner of table". Also tried to run

create index concurrently

and got the same error. Turns out the "postgres" user is not an owner and "supabase_admin" is the owner. Of course, I don't have access to "supabase_admin" owner user. need some advice how to do this thanks in advance

You will need to do this from inside the Supabase dashboard’s sql editor. The dashboard uses super_admin as it’s user.