[receiver/postgresql] Memory leak when using top queries

[sv-splunk]

Component(s)

receiver/postgresql

Describe the issue you're reporting

There has been a memory leak issue found and fixed in SQL Server receiver code while using the ObfuscateSQLStringWithOptions function from the obfuscate library. Same fix needs to be implemented in postgresqlreceiver also.

Reference for related issue in sqlserverreceiver: #42302

Tip

_{React with 👍 to help prioritize this issue. Please use comments to provide useful context, avoiding +1 or me too, to help us triage it. Learn more here.}

[github-actions]

Pinging code owners:

• receiver/postgresql: @antonblock @ishleenk17

See Adding Labels via Comments if you do not have permissions to add labels yourself.