| From: | MAILBOX-DBS <dba-mailbox(at)pictet(dot)com> |
|---|---|
| To: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | pg_stat_statement not collecting information about queries inside functions. |
| Date: | 2026-07-30 13:41:03 |
| Message-ID: | fbc3a158e137493fbe9909ad7a5b737f@pictet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hello all
pg_stat_statements does not seem to collect metrics for queries inside functions, in my understanding this should be possible.
Is there a documentation about restrictions or has someone a clue why this is not working for me?
Values of parameters that may influence the behaviour:
shared_preload_libraries = 'pgaudit,pg_stat_statements'
pg_stat_statements.track = 'all'
pg_stat_statements.max = 20000
track_functions = 'all'
the function header:
CREATE OR REPLACE FUNCTION core.sf_generic_daily_merge_landing_to_target(
p_sys_daily_load_run_key bigint)
RETURNS integer
LANGUAGE 'plpgsql'
COST 100
VOLATILE PARALLEL UNSAFE
AS $BODY$
Declare
Best Regards
Rolf
This message is not intended for persons who are citizens of, domiciled or resident in, or entities registered in a country or jurisdiction in which its distribution, publication, provision or use would violate current laws and regulations.
The content of this message is confidential and may be read and/or used only by the recipient of this message. For information about personal data protection, please refer to the Pictet Group's Privacy Notice available at https://www.group.pictet/privacynotice. If you have received this e-mail message in error, please destroy it and delete it from your computer.
The Pictet Group may not be held liable for the use, transmission or treatment of the content of this message. The recipient of this message remains solely liable for any form of reproduction, copying, disclosure, modification and/or publication of the content. No liability whatsoever will be incurred by the Pictet Group. The recipient of this message agrees to comply with the applicable laws and regulations in the jurisdictions where they use the information contained herein..
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2026-07-30 14:10:43 | Re: pg_stat_statement not collecting information about queries inside functions. |
| Previous Message | Nguyễn Thành | 2026-07-14 02:52:56 | Question: ALTER COLUMN TYPE rebuilds child indexes when a parent partitioned index references the altered column |