您可以将 EXPLAIN ANALYZE 的输出作为XML / JSON和解析它：

You could return output from EXPLAIN ANALYZE as XML/JSON and parse it:

CREATE OR REPLACE FUNCTION test19() RETURNS TEXT
AS $$
DECLARE total TEXT;
BEGIN
    EXPLAIN (ANALYZE, TIMING, FORMAT JSON) into total SELECT 1 AS c;
    RETURN ((total::jsonb)-> 0 -> 'Execution Time');
END;
$$  LANGUAGE plpgsql;

db< fiddle演示

db<>fiddle demo