plprofiler

pig repo add pgdg -u # add pgdg repo and update cache

pig install plprofiler;# install via package name, for the active PG version  pig install plprofiler -v 18; # install for PG 18 pig install plprofiler -v 17; # install for PG 17 pig install plprofiler -v 16; # install for PG 16 pig install plprofiler -v 15; # install for PG 15 pig install plprofiler -v 14; # install for PG 14

shared_preload_libraries = 'plprofiler';

CREATE EXTENSION plprofiler;

CREATE EXTENSION plprofiler;

# Profile a specific SQL command plprofiler run -d mydb --command "SELECT my_function()" --output report.html  # Monitor profiling in real-time plprofiler monitor -d mydb  # Save profiling data for later analysis plprofiler save -d mydb --name "my_profile"  # Generate HTML report with flame graphs plprofiler report -d mydb --from-data "my_profile" --output report.html  # List saved profiling datasets plprofiler list -d mydb  # Reset profiling data plprofiler reset-data -d mydb  # Export/import profiling data plprofiler export -d mydb --from-data "my_profile" > profile.json plprofiler import -d mydb --into-data "imported" < profile.json

-- Enable profiling for the current session SELECT pl_profiler_set_enabled_local(true);  -- Execute functions to be profiled SELECT my_function();  -- Collect profiling data into shared hash tables SELECT pl_profiler_collect_data();  -- Disable profiling SELECT pl_profiler_set_enabled_local(false);  -- Enable profiling globally (for all sessions) SELECT pl_profiler_set_enabled_global(true);  -- Reset local/shared profiling data SELECT pl_profiler_reset_local(); SELECT pl_profiler_reset_shared();