Any performance impact after enable Query Store feature in Azure PostgreSQL DB Server

[Shaban Khan]

Hi Team,

We want to enable Query store in Azure PostgreSQL DB server for Intelligent Performance (Query Performance Insight and Performance Recommendations) feature.

Before enable the feature, want to understand any performance impact on the PostgreSQL DB server if enable the feature.

Can you please share if you have any insight on the performance impact.

Thanks in advance.

Thanks

Shaban Khan

[#2]

In the testing I've done, the impact is extremely minimal. However, don't trust me. Test it on your own system. The degree of impact is tied pretty tightly with the volume of queries on your system.