supabase / realtime

Broadcast, Presence, and Postgres Changes via WebSockets
https://supabase.com/realtime
Apache License 2.0
6.79k stars 310 forks source link

Performance Advisor foreign key index #1140

Closed jdgamble555 closed 2 weeks ago

jdgamble555 commented 1 month ago

Bug report

Describe the bug

The performance advisor indicates this:

Table _realtime.extensions has a foreign key extensions_tenant_external_id_fkey without a covering index. 
This can lead to suboptimal query performance.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

Run any instance of supabase on the local machine.

Expected behavior

The index would be automatically created by Supabase.

Screenshots

Unindexed foreign keys

System information

Additional context

Should just be automatically created. Easy fix.

J

filipecabaco commented 2 weeks ago

PR was merged, closing the issue