Unsupported Media Type on .explain query

[jsbrain]

Bug report

Describe the bug

.explain results in media error.

To Reproduce

const query = await supabase.from('test').select('*').explain();

results in

{
  error: {
    code: 'PGRST107',
    details: null,
    hint: null,
    message: 'None of these media types are available: application/vnd.pgrst.plan+text'
  },
  data: null,
  count: null,
  status: 415,
  statusText: 'Unsupported Media Type'
}

System information

• OS: macOS
• Browser: Chrome
• Version of supabase-js: 2.4.1
• Version of Node.js: 16

[jsbrain]

Might be related to https://github.com/supabase/supabase-js/issues/691

[steve-chavez]

Hello, to use explain first you need to enable server side with:

alter role authenticator set pgrst.db_plan_enabled to true;
notify pgrst, 'reload config';

Let me know if that works.

[jsbrain]

Thanks @steve-chavez for the clarification.

Probably worth adding this to the docs.

Looks like so far .explain isn't documented at all!?

[jsbrain]

And unfortunately no, it did not work ... also restarted the deployment after I ran the commands but no change.

I'm on self-hosted btw. with this config.

[steve-chavez]

If you're on self-hosted, you can add PGRST_DB_PLAN_ENABLED: true here.

[jsbrain]

Still the same error ...

I tried to send a request directly to postgrest via Postman, setting the accept error as: shown here.

Output:

{
    "code": "PGRST107",
    "details": null,
    "hint": null,
    "message": "None of these media types are available: application/vnd.pgrst.plan+json"
}

Something is odd ... 🤔

[steve-chavez]

You're using an old version https://github.com/supabase/supabase/blob/f3031fa24fd4a65e7d48f079db45a0cd3ee0311c/docker/docker-compose.yml#L104

Change it to v10.1.1

[jsbrain]

Well, that solves the mystery. I was somehow under the impression that the docker-compose is up to date with the js clients.

Thanks so much for your help!