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