First things first, log in to the Supabase dashboard at app.supabase.io. Make sure you have the right permissions to access the project you want to keep an eye on.

Once you're in the dashboard, pick the project you want to monitor from the list of available projects. Easy peasy.

Now, look at the sidebar and find the "Database" section. Click on it. This is where you'll find all sorts of tools and metrics related to your database's performance.

In the "Database" section, there's a "Status" tab. Click on it to get a snapshot of your database's health. You'll see metrics like database connections, CPU usage, memory usage, and disk space.

Head over to the "Logs" tab within the "Database" section. This is where you'll find logs related to database queries, errors, and other important events. Use this info to spot slow-running queries and potential issues.

While you're in the "Logs" tab, keep an eye out for logs that show slow queries. Supabase logs queries that take longer than a certain threshold to execute. Analyzing these logs can help you identify queries that might be slowing things down.

Supabase might offer a beta or extra feature set for query performance insights. Turning these on gives you detailed performance metrics on specific queries, helping you pinpoint performance bottlenecks.

Think about setting up alerts for your database. Supabase might have integrations with third-party alerting tools that notify you when certain performance thresholds are crossed, like CPU usage going over 80%.

Enable and use the pg_stat_statements extension for a more in-depth query performance analysis. You can do this by running a SQL command via the SQL editor in Supabase:

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

Then, query the pg_stat_statements view to get detailed insights into query performance:

SELECT * FROM pg_stat_statements;

Make it a habit to regularly check the "Status" and "Logs" sections in the Supabase dashboard. This helps you stay on top of any developing issues. Also, periodically review pg_stat_statements for a deeper understanding of query performance trends.

Use the info you gathered from logs, performance insights, and pg_stat_statements to optimize your database. This might involve indexing, query optimization, or tweaking the schema to boost performance.