PGDMP/- }postgres18.018.0g00ENCODINGENCODINGSET client_encoding = 'UTF8'; falseh00 STDSTRINGS STDSTRINGS(SET standard_conforming_strings = 'on'; falsei00 SEARCHPATH SEARCHPATH8SELECT pg_catalog.set_config('search_path', '', false); falsej12625postgresDATABASEjCREATE DATABASE postgres WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'C'; DROP DATABASE postgres;  geeplomasterfalsek00DATABASE postgresCOMMENTNCOMMENT ON DATABASE postgres IS 'default administrative connection database';  geeplomasterfalse3946l00 SCHEMA publicACL)GRANT ALL ON SCHEMA public TO authentik; pg_database_ownerfalse10307916520 btree_gin EXTENSION=CREATE EXTENSION IF NOT EXISTS btree_gin WITH SCHEMA public; DROP EXTENSION btree_gin; falsem00EXTENSION btree_ginCOMMENTRCOMMENT ON EXTENSION btree_gin IS 'support for indexing common datatypes in GIN'; false5307916956 btree_gist EXTENSION>CREATE EXTENSION IF NOT EXISTS btree_gist WITH SCHEMA public; DROP EXTENSION btree_gist; falsen00EXTENSION btree_gistCOMMENTTCOMMENT ON EXTENSION btree_gist IS 'support for indexing common datatypes in GiST'; false6307916395pg_stat_statements EXTENSIONFCREATE EXTENSION IF NOT EXISTS pg_stat_statements WITH SCHEMA public; #DROP EXTENSION pg_stat_statements; falseo00EXTENSION pg_stat_statementsCOMMENTuCOMMENT ON EXTENSION pg_stat_statements IS 'track planning and execution statistics of all SQL statements executed'; false3307916439pg_trgm EXTENSION;CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public; DROP EXTENSION pg_trgm; falsep00EXTENSION pg_trgmCOMMENTeCOMMENT ON EXTENSION pg_trgm IS 'text similarity measurement and index searching based on trigrams'; false4307916384 uuid-ossp EXTENSION?CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public; DROP EXTENSION "uuid-ossp"; falseq00EXTENSION "uuid-ossp"COMMENTWCOMMENT ON EXTENSION "uuid-ossp" IS 'generate universally unique identifiers (UUIDs)'; false2G125517685get_database_stats()FUNCTIONCREATE FUNCTION public.get_database_stats() RETURNS TABLE(database_name text, size text, connections integer, active_connections integer) LANGUAGE plpgsql AS $$ BEGIN RETURN QUERY SELECT current_database() as database_name, pg_size_pretty(pg_database_size(current_database())) as size, count(*) as connections, count(*) FILTER (WHERE state = 'active') as active_connections FROM pg_stat_activity WHERE datname = current_database(); END; $$; +DROP FUNCTION public.get_database_stats(); public geeplomasterfalseF125517684get_slow_queries(integer)FUNCTION6CREATE FUNCTION public.get_slow_queries(min_duration_ms integer DEFAULT 1000) RETURNS TABLE(query text, calls bigint, total_time double precision, mean_time double precision, rows bigint) LANGUAGE plpgsql AS $$ BEGIN RETURN QUERY SELECT query, calls, total_exec_time AS total_time, mean_exec_time AS mean_time, rows FROM pg_stat_statements WHERE mean_exec_time > (min_duration_ms / 1000.0) ORDER BY mean_exec_time DESC LIMIT 20; END; $$; @DROP FUNCTION public.get_slow_queries(min_duration_ms integer); public geeplomasterfalseE125517683refresh_materialized_view(text)FUNCTIONWCREATE FUNCTION public.refresh_materialized_view(view_name text) RETURNS void LANGUAGE plpgsql AS $$ DECLARE view_exists BOOLEAN; BEGIN SELECT EXISTS ( SELECT 1 FROM pg_matviews WHERE matviewname = view_name ) INTO view_exists; IF view_exists THEN EXECUTE 'REFRESH MATERIALIZED VIEW CONCURRENTLY ' || view_name; RAISE NOTICE 'Materialized view % refreshed successfully', view_name; ELSE RAISE NOTICE 'Materialized view % does not exist', view_name; END IF; END; $$; @DROP FUNCTION public.refresh_materialized_view(view_name text); public geeplomasterfalseD125517682update_updated_at_column()FUNCTION°CREATE FUNCTION public.update_updated_at_column() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW; END; $$; 1DROP FUNCTION public.update_updated_at_column(); public geeplomasterfalseü 82617687 DEFAULT PRIVILEGES FOR SEQUENCES DEFAULT ACLhALTER DEFAULT PRIVILEGES FOR ROLE geeplomaster IN SCHEMA public GRANT ALL ON SEQUENCES TO geeplomaster; public geeplomasterfalseý 82617688 DEFAULT PRIVILEGES FOR FUNCTIONS DEFAULT ACLhALTER DEFAULT PRIVILEGES FOR ROLE geeplomaster IN SCHEMA public GRANT ALL ON FUNCTIONS TO geeplomaster; public geeplomasterfalseû 82617686DEFAULT PRIVILEGES FOR TABLES DEFAULT ACLeALTER DEFAULT PRIVILEGES FOR ROLE geeplomaster IN SCHEMA public GRANT ALL ON TABLES TO geeplomaster; public geeplomasterfalse