Knowledge check

Choose the best response for each of the following questions.

Check your knowledge

What do you have to do to enable pg_stat_statements queries?

Nothing. Pg_stat_statements are already enabled.

Turn on the pg_stat_statements.track setting.

In Server parameters, enable pg_qs.query_capture_mode.

In the Query Store, how do you view the SQL syntax of queries?

Query the query_store.runtime_stats_view view.

Query the query_store.qs_view view.

Query the query_store.pgms_wait_sampling_view view.

You must answer all questions before checking your work.