[receiver/postgresql] Add opt-in pgvector metrics (#49576)

[receiver/postgresql] Add opt-in pgvector metrics (#49576) #115825