duplicate index warnings on supabase

[hesoyam-zip]

Describe the Bug

I set up Umami to write data into a Postgres database hosted on Supabase, and it has issued a few warnings regarding indexes in the Umami tables:

name	title	level	facing	categories	description	detail	remediation	metadata	cache_key
duplicate_index	Duplicate Index	WARN	EXTERNAL	["PERFORMANCE"]	Detects cases where two ore more identical indexes exist.	Table `umami.link` has identical indexes {link_link_id_key,link_pkey}. Drop all except one of them	https://supabase.com/docs/guides/database/database-linter?lint=0009_duplicate_index	{"name":"link","type":"table","schema":"umami","indexes":["link_link_id_key","link_pkey"]}	duplicate_index_umami_link_{link_link_id_key,link_pkey}
duplicate_index	Duplicate Index	WARN	EXTERNAL	["PERFORMANCE"]	Detects cases where two ore more identical indexes exist.	Table `umami.pixel` has identical indexes {pixel_pixel_id_key,pixel_pkey}. Drop all except one of them	https://supabase.com/docs/guides/database/database-linter?lint=0009_duplicate_index	{"name":"pixel","type":"table","schema":"umami","indexes":["pixel_pixel_id_key","pixel_pkey"]}	duplicate_index_umami_pixel_{pixel_pixel_id_key,pixel_pkey}
duplicate_index	Duplicate Index	WARN	EXTERNAL	["PERFORMANCE"]	Detects cases where two ore more identical indexes exist.	Table `umami.report` has identical indexes {report_pkey,report_report_id_key}. Drop all except one of them	https://supabase.com/docs/guides/database/database-linter?lint=0009_duplicate_index	{"name":"report","type":"table","schema":"umami","indexes":["report_pkey","report_report_id_key"]}	duplicate_index_umami_report_{report_pkey,report_report_id_key}
duplicate_index	Duplicate Index	WARN	EXTERNAL	["PERFORMANCE"]	Detects cases where two ore more identical indexes exist.	Table `umami.revenue` has identical indexes {revenue_pkey,revenue_revenue_id_key}. Drop all except one of them	https://supabase.com/docs/guides/database/database-linter?lint=0009_duplicate_index	{"name":"revenue","type":"table","schema":"umami","indexes":["revenue_pkey","revenue_revenue_id_key"]}	duplicate_index_umami_revenue_{revenue_pkey,revenue_revenue_id_key}
duplicate_index	Duplicate Index	WARN	EXTERNAL	["PERFORMANCE"]	Detects cases where two ore more identical indexes exist.	Table `umami.segment` has identical indexes {segment_pkey,segment_segment_id_key}. Drop all except one of them	https://supabase.com/docs/guides/database/database-linter?lint=0009_duplicate_index	{"name":"segment","type":"table","schema":"umami","indexes":["segment_pkey","segment_segment_id_key"]}	duplicate_index_umami_segment_{segment_pkey,segment_segment_id_key}
duplicate_index	Duplicate Index	WARN	EXTERNAL	["PERFORMANCE"]	Detects cases where two ore more identical indexes exist.	Table `umami.session` has identical indexes {session_pkey,session_session_id_key}. Drop all except one of them	https://supabase.com/docs/guides/database/database-linter?lint=0009_duplicate_index	{"name":"session","type":"table","schema":"umami","indexes":["session_pkey","session_session_id_key"]}	duplicate_index_umami_session_{session_pkey,session_session_id_key}
duplicate_index	Duplicate Index	WARN	EXTERNAL	["PERFORMANCE"]	Detects cases where two ore more identical indexes exist.	Table `umami.team` has identical indexes {team_pkey,team_team_id_key}. Drop all except one of them	https://supabase.com/docs/guides/database/database-linter?lint=0009_duplicate_index	{"name":"team","type":"table","schema":"umami","indexes":["team_pkey","team_team_id_key"]}	duplicate_index_umami_team_{team_pkey,team_team_id_key}
duplicate_index	Duplicate Index	WARN	EXTERNAL	["PERFORMANCE"]	Detects cases where two ore more identical indexes exist.	Table `umami.team_user` has identical indexes {team_user_pkey,team_user_team_user_id_key}. Drop all except one of them	https://supabase.com/docs/guides/database/database-linter?lint=0009_duplicate_index	{"name":"team_user","type":"table","schema":"umami","indexes":["team_user_pkey","team_user_team_user_id_key"]}	duplicate_index_umami_team_user_{team_user_pkey,team_user_team_user_id_key}
duplicate_index	Duplicate Index	WARN	EXTERNAL	["PERFORMANCE"]	Detects cases where two ore more identical indexes exist.	Table `umami.user` has identical indexes {user_pkey,user_user_id_key}. Drop all except one of them	https://supabase.com/docs/guides/database/database-linter?lint=0009_duplicate_index	{"name":"user","type":"table","schema":"umami","indexes":["user_pkey","user_user_id_key"]}	duplicate_index_umami_user_{user_pkey,user_user_id_key}
duplicate_index	Duplicate Index	WARN	EXTERNAL	["PERFORMANCE"]	Detects cases where two ore more identical indexes exist.	Table `umami.website` has identical indexes {website_pkey,website_website_id_key}. Drop all except one of them	https://supabase.com/docs/guides/database/database-linter?lint=0009_duplicate_index	{"name":"website","type":"table","schema":"umami","indexes":["website_pkey","website_website_id_key"]}	duplicate_index_umami_website_{website_pkey,website_website_id_key}

Database

PostgreSQL

Relevant log output

Which Umami version are you using? (if relevant)

umami@3.0.3

Which browser are you using? (if relevant)

No response

How are you deploying your application? (if relevant)

No response

[franciscao633]

Thanks for the insight. We removed the redundant keys in this commit.