pg_stat_statement not collecting information about queries inside functions.

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..

Responses

Browse pgsql-performance by date

  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