Azure Postgres & Query Performance Insight: Query text not showing

user_2393559 0
Viewed 367

I have enabled Query Performance Insights, however, the Query Text fields are left empty, as you can see from the screenshot below.

enter image description here

I have enabled the Query Store as described in the documentation, everything else has been left to its default values.

  • pg_qs.query_capture_mode is set to TOP
  • pgms_wait_sampling.query_capture_mode is set to ALL

If I query the query_store.qs_view or pgms_wait_sampling_view data is returned.

SELECT * FROM query_store.qs_view;
SELECT * FROM query_store.pgms_wait_sampling_view;

Also the column qs_view.query_sql_text contains SQL statements, as well as the query_texts_view. Any idea why its not showing up in the UI?

azure postgresql
1 Answers
user_67101830
Related