[Postgresql] Association of metrics across Postgresql Datasets using OID

[ishleenk17]

There are 3 datasets in Postgresql and all three have OID fields under different field names.

postgresql.activity.database.oid postgresql.database.oid postgresql.statement.database.oid

User should be able to associate data across these 3 datasets using these OID's. Opening this ticket for this enhancement in Postgresql. Probable Solution: Create an Alias for the OID's

Additionally, we can also check if similar changes are required in other databases as well.

[niraj-elastic]

Currently there are total four OID fields

• postgresql.activity.database.oid
• postgresql.database.oid
• postgresql.statement.database.oid
• postgresql.statement.user.oid

Here we can make alias field database.oid for all the database OID fields so that user can make meaningful visualization related to database OID in general. i will raise a PR for this change soon, @ishleenk17 Let me know if there is anything else needed to be done here.

[ishleenk17]

@niraj-elastic : Yes aliasing should work. Before that can we please confirm if the values are same for all of them? Expectation is the values should be similar.

[niraj-elastic]

@ishleenk17 I checked in metricbeat Postgresql module, And it is same as integration. all the data type for this three field is same and all of them gives oid of database,

[ishleenk17]

Yes, lets go ahead with aliasing.

[niraj-elastic]

Closing this issue since the the PR with fix is merged.