PostgreSQL run analyze all table (using pl/pgsql script)

pg_run_analyze_all_table.sql

DO $$
DECLARE
  tab RECORD;
  schemaName VARCHAR := 'public';
BEGIN
  for tab in (SELECT t.relname::varchar AS table_name
                FROM pg_class t
                JOIN pg_namespace n ON n.oid = t.relnamespace
                WHERE t.relkind = 'r' and n.nspname::varchar = schemaName
                ORDER BY 1)
  LOOP
    RAISE NOTICE 'ANALYZE %.%', schemaName, tab.table_name;
    EXECUTE format('ANALYZE %I.%I', schemaName, tab.table_name);
  end loop;
end
$$;