Capture wait stats, runtime stats, and query text across primary, regular and cascading read replicas — and export it all to Log Analytics (LAWS) using dedicated tables.
Updated May 08, 2026
Version 4.0Usage of LAW persisted query texts is interesting approach because 2022 query texts were removed from query performance insights:
How to get the Query Text of Azure database for PostgreSQL | Microsoft Community Hub
If I need to guess that at that point pg_qs.emit_query_text was added with default setting being FALSE.
Mind retention: Query store retention and Log Analytics retention are separate knobs. Tune them to balance troubleshooting value and cost.
Also using resource-specific LAW tables allows write different retention for real audit logs and perfomance related logs