Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Does anyone know if there are docs on all the possible fields that can be displayed from the log explorer?

Hello <@886735405884522526>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.

**Want to change the title?**
Use the ``/title`` command!

**We have solved your problem?**
Click the button below to archive it.

I've seen this page but it seems extremely basic: https://supabase.com/docs/guides/platform/logs

The templates should give you a good idea of things to do:

https://app.supabase.com/project/_/logs-explorer/templates

if you want more, then I would suggest accessing postgres using PSQL. You can check PSQL commands here:
https://supabase-cheatsheet.vercel.app/guide/basic/sql/psql-commands.html#edit-function

my problem is NOT how to structure a query - my problem is how to display particular fields from the logs, because you cannot just use a wildcard, you must list each field expclicitly

for example, from the page I listed I know that to see the IP of the client, I need to use x_real_ip - how do I know the names of all other headers present in the request?

for example, do you know how I can show the JWT that was sent with a request (which should be present in the Authorization header)?

These are the fields in postgres_logs:

I've talked with the team and requested it to be included in that guide page.

thanks, <@468156876727517225> but that doesn't look like the complete list. For example, this list does NOT include the ```x_real_ip``` field that is present in the example from the docs I listed above

this might be the list from the parsed metadata, but form example I see that there is quite a bit more that can be extracted from the metadata - for example, request info, response info, etc

(x_real_ip seems to be coming from the data related to request headers)

These are the fields from postgres_logs. I did request them to add the fields for all the log tables (edge_logs, metadata, auth_logs, etc), but I am still waiting to get more info