Skip to content

Instantly share code, notes, and snippets.

@seansong327

seansong327/Postgresql -- Print function execution plan

Created June 24, 2016 14:34
Show Gist options
  • Save seansong327/1705d7d36e9a0e7dea39e13459fb5108 to your computer and use it in GitHub Desktop.
Save seansong327/1705d7d36e9a0e7dea39e13459fb5108 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Postgresql -- Print function execution plan
LOAD 'auto_explain';
set auto_explain.log_analyze = true;
set auto_explain.log_nested_statements = true;
set auto_explain.log_min_duration = 0;
set auto_explain.log_verbose = true;
set auto_explain.log_timing = true;
-- execute function
set auto_explain.log_analyze = false;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment