Skip to content

query_id usage in bundle of AQO and pg_stat_statements (PGSS) extensions #71

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.

Sign up for GitHub

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

Jump to bottom
Closed
danolivo opened this issue Jun 16, 2022 · 0 comments
Closed

query_id usage in bundle of AQO and pg_stat_statements (PGSS) extensions #71

danolivo opened this issue Jun 16, 2022 · 0 comments

Comments

@danolivo
Copy link
Collaborator

In stable 14 and beyond we pretend to use the same query_id in both extensions.
Adding AQO TAP-tests on this feature we found out next issues:

  1. AQO stores not-parameterized query texts.
  2. In the case of EXPLAIN ANALYZE, query_id in the extensions are different
  3. Also, we should check the case with queries in stored procedures
danolivo added a commit that referenced this issue Jun 16, 2022
@danolivo
Add more TAP tests on joint usage of query_id machinery by AQO and PGSS
f455a0d 
extensions. Some minor inconsistencies were detected (see issue #71).

Authors: A.Kazarinov, A.Lepikhov
danolivo added a commit that referenced this issue Oct 13, 2022
@danolivo
Add more TAP tests on joint usage of query_id machinery by AQO and PGSS
42e41a4 
extensions. Some minor inconsistencies were detected (see issue #71).

Authors: A.Kazarinov, A.Lepikhov
danolivo added a commit that referenced this issue Oct 14, 2022
@danolivo
Add more TAP tests on joint usage of query_id machinery by AQO and PGSS
15e433a 
extensions. Some minor inconsistencies were detected (see issue #71).

Authors: A.Kazarinov, A.Lepikhov
danolivo added a commit that referenced this issue Oct 14, 2022
@danolivo
Add more TAP tests on joint usage of query_id machinery by AQO and PGSS
6d364a8 
extensions. Some minor inconsistencies were detected (see issue #71).

Authors: A.Kazarinov, A.Lepikhov
danolivo added a commit that referenced this issue Oct 21, 2022
@danolivo
Add more TAP tests on joint usage of query_id machinery by AQO and PGSS
ff07d90 
extensions. Some minor inconsistencies were detected (see issue #71).

Authors: A.Kazarinov, A.Lepikhov
danolivo added a commit that referenced this issue Dec 21, 2022
@danolivo
Add more TAP tests on joint usage of query_id machinery by AQO and PGSS
cd87af5 
extensions. Some minor inconsistencies were detected (see issue #71).

Authors: A.Kazarinov, A.Lepikhov
danolivo added a commit that referenced this issue Dec 21, 2022
@danolivo
Add more TAP tests on joint usage of query_id machinery by AQO and PGSS
32dff21 
extensions. Some minor inconsistencies were detected (see issue #71).

Authors: A.Kazarinov, A.Lepikhov
danolivo added a commit that referenced this issue Dec 22, 2022
@danolivo
Add more TAP tests on joint usage of query_id machinery by AQO and PGSS
ed3e227 
extensions. Some minor inconsistencies were detected (see issue #71).

Authors: A.Kazarinov, A.Lepikhov
@danolivo danolivo closed this as completed Apr 8, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@danolivo