Skip to content

query_logger plugin duplication output the SQL  #895

@mingjunyang

Description

@mingjunyang

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions