Missing Latest DB Queries and Heaviest DB Queries from Event Viewer

FunkyChicken645

Hello Decisions

While exploring the system tools in Decisions, I looked in the event viewer (System > Administration > System Tools > Event Viewer) and when clicking 'All' in the top right, I noticed that I don't have the 'Latest DB Queries' and 'Heaviest DB Queries' options on my PostGres Install, but I DO have those options in my MSSQL install.

Is this expected behavior?

Levi_Decisions

Hey there,

Thanks for using our Decisions Community Forum!

This is expected behavior for a PostGres install due to the schema differences between PostGres and MSSQL.

PostGres requires extensions to get these advanced statistics whereas MSSQL has many of the performance views built into the core system catalog.

I hope this helps!

Regards,

Levi | Decisions Support