Collection Engine

pghf.execute_check_run(p_run_key text DEFAULT NULL, p_check_run_id uuid DEFAULT NULL, INOUT p_run_id uuid DEFAULT NULL, p_target_version int DEFAULT NULL, p_amcheck_tables text[] DEFAULT NULL, p_pg_visibility_tables text[] DEFAULT NULL)

The generic dispatch engine. Runs every member of a named suite, in order, committing after each one. It has zero built-in knowledge of any particular check or suite — it's driven entirely by suite membership and each check's registered backing function. Deliberately not SECURITY DEFINER (see The Access Model): checks run as whoever actually calls this procedure. Must be invoked as a standalone CALL statement.

Parameter	Type	Mandatory	Default	Description
p_run_key	text	One of p_run_key/p_check_run_id required	empty	Suite to run, by name.
p_check_run_id	uuid	One of p_run_key/p_check_run_id required	empty	Suite to run, by internal identifier.
p_run_id	uuid (input/output)	No	empty = a new one is generated	Pass an existing value to reuse a specific run ID; otherwise a fresh one is generated and handed back to you.
p_target_version	int	No	empty	Recorded as run configuration; read by the pg_upgrade-readiness checks.
p_amcheck_tables	text[]	No	empty	Recorded as run configuration, for checks that verify specific tables with the amcheck extension.
p_pg_visibility_tables	text[]	No	empty	Recorded as run configuration, for checks that inspect specific tables with the pg_visibility extension.

Returns: the run ID, via the input/output parameter. This is a procedure. Inserts one run record and one raw-result record per suite member, and stamps a finish time on completion.

Continue to Thresholds.