EXPLAIN (SUMMARY OFF) for older PostgreSQL versions

gistfile1.txt

CREATE OR REPLACE FUNCTION explain(query TEXT) RETURNS SETOF RECORD AS $$
DECLARE
    rec RECORD;
BEGIN
    FOR rec IN EXECUTE 'EXPLAIN (COSTS OFF, TIMING OFF, ANALYZE) ' || query
    LOOP
        RETURN NEXT rec;
    END LOOP;
END
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION explain_invariant(query TEXT)
RETURNS SETOF text AS $$
DECLARE
    rec RECORD;
BEGIN
    FOR rec IN SELECT * FROM explain(query) as e(t text)
    LOOP
        IF position('Planning time' in rec.t) > 0 OR
           position('Execution time' in rec.t) > 0
        THEN
            CONTINUE;
        END IF;
        RETURN NEXT rec.t;
    END LOOP;
END
$$ LANGUAGE plpgsql;