Exception: No profiling data found

[dbcapps]

Hello,

I am encountering the error "Exception: No profiling data found" while executing the command:

plprofiler run --command "select inventory_in_stock(1)" --output ./inventory_in_stock.html -h hostname.com -d dc01 -U $USERNAME
in plprofiler.py
connect
get_profiler_namespace
select inventory_in_stock(1)
-- row1:
inventory_in_stock: False

(1 rows)
SELECT 1 (0.338 seconds)

Traceback (most recent call last):
File "/home/ec2-user/.local/bin/plprofiler", line 8, in
sys.exit(main())
File "/home/ec2-user/.local/lib/python3.9/site-packages/plprofiler/plprofiler_tool.py", line 75, in main
return run_command(sys.argv[2:])
File "/home/ec2-user/.local/lib/python3.9/site-packages/plprofiler/plprofiler_tool.py", line 844, in run_command
report_data = plp.get_local_report_data(opt_name, opt_top, args)
File "/home/ec2-user/.local/lib/python3.9/site-packages/plprofiler/plprofiler.py", line 407, in get_local_report_data
raise Exception("No profiling data found")
Exception: No profiling data found

The code opens the below file for me to edit:
[current]
title = PL Profiler Report for current
tabstop = 8
svg_width = 1200
table_width = 80%
desc =

PL Profiler Report for current

The table structures and function definition are available at
https://aws.amazon.com/blogs/database/profile-amazon-rds-for-postgresql-or-amazon-aurora-postgresql-pl-pgsql-code-using-plprofiler/

The error is reproducible.

Thanks in advance.

[luss]

this is usually a result of you not explicitly activating profiling in your session.

…

On Tue, Jan 21, 2025 at 11:09 PM Dean Capps ***@***.***> wrote: Hello, I am encountering the error "Exception: No profiling data found" while executing the command: plprofiler run --command "select inventory_in_stock(1)" --output ./inventory_in_stock.html -h iam-authentication-db-instance-us-east-1b.cr05k3xfab9k.us-east-1.rds.amazonaws.com -d dc01 -U $USERNAME in plprofiler.py connect get_profiler_namespace select inventory_in_stock(1) -- row1: inventory_in_stock: False (1 rows) SELECT 1 (0.338 seconds) Traceback (most recent call last): File "/home/ec2-user/.local/bin/plprofiler", line 8, in sys.exit(main()) File "/home/ec2-user/.local/lib/python3.9/site-packages/plprofiler/plprofiler_tool.py", line 75, in main return run_command(sys.argv[2:]) File "/home/ec2-user/.local/lib/python3.9/site-packages/plprofiler/plprofiler_tool.py", line 844, in run_command report_data = plp.get_local_report_data(opt_name, opt_top, args) File "/home/ec2-user/.local/lib/python3.9/site-packages/plprofiler/plprofiler.py", line 407, in get_local_report_data raise Exception("No profiling data found") Exception: No profiling data found The code opens the below file for me to edit: [current] title = PL Profiler Report for current tabstop = 8 svg_width = 1200 table_width = 80% desc = PL Profiler Report for current The table structures and function definition are available at https://aws.amazon.com/blogs/database/profile-amazon-rds-for-postgresql-or-amazon-aurora-postgresql-pl-pgsql-code-using-plprofiler/ The error is reproducible. Thanks in advance. — Reply to this email directly, view it on GitHub <#25>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAMWOHUMCLJXUMY4NQYEQA32L4KX3AVCNFSM6AAAAABVT7QY52VHI2DSMVQWIX3LMV43ASLTON2WKOZSHAYDGMZSGA4DKOI> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[dbcapps]

Thanks. Could you please provide some guidance on "activating".

Thanks in advance.

[NIng-WN]

hello,
I am also encountering the error "Exception: No profiling data found" while executing the command
plprofiler run --command "SELECT tpcb(1, 2, 3, -42)" --output tpcb-test1.html

the error msg is as follow.

SELECT tpcb(1, 2, 3, -42)
-- row1:
tpcb: -42

(1 rows)
SELECT 1 (0.091 seconds)

Traceback (most recent call last):
File "/home/postgres/pl-env/bin/plprofiler", line 33, in
sys.exit(load_entry_point('plprofiler-client==4.2', 'console_scripts', 'plprofiler')())
File "/home/postgres/pl-env/lib64/python3.11/site-packages/plprofiler_client-4.2-py3.11.egg/plprofiler/plprofiler_tool.py", line 75, in main
return run_command(sys.argv[2:])
File "/home/postgres/pl-env/lib64/python3.11/site-packages/plprofiler_client-4.2-py3.11.egg/plprofiler/plprofiler_tool.py", line 844, in run_command
report_data = plp.get_local_report_data(opt_name, opt_top, args)
File "/home/postgres/pl-env/lib64/python3.11/site-packages/plprofiler_client-4.2-py3.11.egg/plprofiler/plprofiler.py", line 420, in get_local_report_data
raise Exception("No profiling data found")
Exception: No profiling data found
(pl-env)

What might be causing this issue, and how can it be resolved?
Thanks in advance.

[dbcapps]

Check the shared preload library entries. If pg_hint_plan is present, remove it and try.