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();