I am getting below error while running postgres exporter.
Error running query on database "localhost:5432 ": pg_stat_stateme nts pq: stack depth limit exceeded source="postgre s_exporter.go:1 286"
This is what i did in database
CREATE EXTENSION pg_stat_stateme nts;
CREATE OR REPLACE FUNCTION get_pg_stat_sta tements() RETURNS SETOF pg_stat_stateme nts AS
$$ SELECT * FROM pg_stat_stateme nts; $$
LANGUAGE sql
VOLATILE
SECURITY DEFINER;
CREATE OR REPLACE VIEW postgres_export er.pg_stat_stat ements
AS
SELECT * from get_pg_stat_sta tements();
GRANT SELECT ON postgres_export er.pg_stat_stat ements TO postgres_export er;
Error running query on database "localhost:5432 ": pg_stat_stateme nts pq: stack depth limit exceeded source="postgre s_exporter.go:1 286"
This is what i did in database
CREATE EXTENSION pg_stat_stateme nts;
CREATE OR REPLACE FUNCTION get_pg_stat_sta tements() RETURNS SETOF pg_stat_stateme nts AS
$$ SELECT * FROM pg_stat_stateme nts; $$
LANGUAGE sql
VOLATILE
SECURITY DEFINER;
CREATE OR REPLACE VIEW postgres_export er.pg_stat_stat ements
AS
SELECT * from get_pg_stat_sta tements();
GRANT SELECT ON postgres_export er.pg_stat_stat ements TO postgres_export er;