search

zubkov-andrei / pg_profile

Postgres historic workload reports
Other
236 stars 33 forks source link

Getting error for Rare relation sizes collection step [set_server_size_sampling()]. #54

Closed Chitrasree24 closed 1 year ago

Chitrasree24 commented 1 year ago

Hi,

I have installed PG_Profile and for configuring followed the steps provided in pg_profile.md file.

In Rare relation sizes collection step, while executing the below query - 'SELECT set_server_size_sampling('local','23:00+03',interval '2 hour',interval '8 hour'); ' getting an error as 'No function matches the given name and argument type.You might need to add explicit casts.' And found that function, set_server_size_sampling() in server.sql script. So, I have tried to execute that .sql script and facing an error as below- ERROR: syntac error at or near "=@" LINE 3: ...ption text = NULL) RETURNS integer SET search path=@extschema... Screenshot_20221124_035539

Kindly provide the solution to the above error and sequence of steps to be followed for successful configuration and generation of report.

zubkov-andrei commented 1 year ago

Hello!

It seems like a _searchpath issue. I'm guessing you've installed _pgprofile extension to dedicated schema, as it noted in the docs, but when you are calling its function there is no schema specified. PostgreSQL just can't find that function. Try something like this:

SELECT profile.set_server_size_sampling('local','23:00+03',interval '2 hour',interval '8 hour');

Or specify _pgprofile extension schema in your search_path setting. The \dx command of psql utility will inform you about the schema where extensions installed.