gpcontrib/gp_internal_tools/uninstall_gp_session_state.sql

SET search_path = session_state;

BEGIN;

DROP VIEW session_level_memory_consumption;
DROP FUNCTION session_state_memory_entries_f_on_master();
DROP FUNCTION session_state_memory_entries_f_on_segments();
DROP SCHEMA session_state;

COMMIT;

SET search_path TO DEFAULT;