Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Need a view definition which produces pg_stat_statements compatible view #431

Open
jobinau opened this issue Nov 22, 2023 · 1 comment
Open

Comments

@jobinau
Copy link
Contributor

jobinau commented Nov 22, 2023

A large number of PostgreSQL users / DBAs have tools and scripts prepared for pg_stat_statements.
The lack of pg_stat_statement compatible view definition stands as the biggest obstacle for replacing the pg_stat_statements with pg_stat_monitor
A standard view definition is documentation that could enable users to make the easy switches and thereby accelerate the adoption of pg_stat_monitor

@hqakhtar
Copy link
Contributor

We should add a GUC, perhaps named "enable_pgss_compability". When enabled, it should create a "pg_stat_statements" compatible view with "CREATE EXTENSION". By default, this GUC should be set. There should be a separate SQL function that can create this compatible view later on.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants