feature request: query logging #629

Activity

1. elprans commented on Sep 30, 2020

   

   elprans

   on Sep 30, 2020

   Member

   More actions

   Not a bad idea. Patches are welcome.
2. dmig commented on Oct 1, 2020

   

   dmig

   on Oct 1, 2020

   More actions

   Are there any performance tests in the repo?
3. dmig-alarstudios commented on Oct 1, 2020

   

   dmig-alarstudios

   on Oct 1, 2020

   Author

   More actions

   Could you please have a look at changes while I'm fixing and writing new tests?
4. maksimartemevalar commented on May 11, 2022

   

   maksimartemevalar

   on May 11, 2022

   More actions

   @elprans
   any updates guys?
5. bayersglassey-zesty commented on Mar 7, 2023

   

   bayersglassey-zesty

   on Mar 7, 2023

   More actions

   It's possible to implement this oneself!

   import logging
   from asyncpg.connection import Connection
   
   
   class LoggingConnection(Connection):
   
       _query_logger = logging.getLogger(__name__)
   
       async def _execute(self, query, args, *posargs, **kwargs):
           self._query_logger.info(
               f"Executing query:\n" +
               '\n'.join('  ' + line for line in query.splitlines()) +
               f"...with args: {args}")
           return await Connection._execute(self, query, args, *posargs, **kwargs)

   Now just pass ConnectionLogger as the connection_class parameter of asyncpg.create_pool.
6. elprans commented on Oct 9, 2023

   

   elprans

   on Oct 9, 2023

   Member

   More actions

   Implemented in #1043.
7. elprans

   closed this as completedon Oct 9, 2023