Analyze Schema Statistics

Did you grant the EXECUTE privilege?

Example:

dbadmin=> CREATE USER joe;
CREATE USER

dbadmin=> GRANT EXECUTE ON PROCEDURE analyze_schema_statistics(schema_name VARCHAR) TO joe;
GRANT PRIVILEGE

dbadmin=> \c - joe
You are now connected as user "joe".

dbadmin=> SELECT analyze_schema_statistics('test_stats');
 analyze_schema_statistics
---------------------------
                         0
(1 row)