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
I am on the free tier, not sure if that is part of the problem?
Thank you.
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
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...
