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

query_logger plugin duplication output the SQL #895

Open
mingjunyang opened this issue Dec 27, 2024 · 0 comments
Open

query_logger plugin duplication output the SQL #895

mingjunyang opened this issue Dec 27, 2024 · 0 comments

Comments

@mingjunyang
Copy link

Describe the bug

I run select 1; query from client, and the pgcat output tow:

2024-12-27T07:37:19.360566Z  INFO ThreadId(07) pgcat::plugins::query_logger: [pool: db_name][user: db_user] SELECT 1    
2024-12-27T07:37:19.369002Z  INFO ThreadId(07) pgcat::plugins::query_logger: [pool: db_name][user: db_user] SELECT 1    

To Reproduce

The code at the client.rs:
the first output

let plugin_result = query_router.execute_plugins(&ast).await;

the second output
let plugin_result = query_router.execute_plugins(&ast).await;

Expected behavior
I think run the one query and out put one SQL log.
I try to audit the query with the output, the duplication logs impact on the collection and use of log systems.

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

1 participant