N

Neon•3y ago•

6 replies

brilliant-lime

How to view postgresql function 'explain' with Neon?

I would like to view the execution plan for a function in my postgres db running on Neon. From my understanding the way to do this is to use 'auto_explain'? However when I try to run

LOAD 'auto_explain';

LOAD 'auto_explain';

(https://neon.tech/docs/postgres/auto-explain) I get an error saying that access to auto_explain library is not allowed. Now I think that has to do with my user privileges but my user is part of the neon_superuser group, but when I check the privileges for the neon_superuser that user does not have super user access either and from understanding of the docs the user needs access to the super user role to access this library?

I am on the free tier, not sure if that is part of the problem?

Thank you.

Neon

auto_explain — log execution plans of slow queries - PostgreSQL Docs

id F.4. auto_explain — log execution plans of slow queries F.4.1. Configuration Parameters F.4.2. Example F.4.3. Author The auto_explain module provides a means for logging execution plans of slow st...