Hello. I have Signoz self-hosted in AWS EC2, the free version. It is possible to follow this doc https://signoz.io/docs/integrations/postgresql/ to get the Postgresql metrics and send them to Signoz or is it necessary to have the paid version?

No not necessary to have paid version.