output-sql-alchemy-orm-query.mo

Owner: Xavier Lefevre​
Steps
If your performance issues seem to come from your SQL queries, you should take a look at the output of SQL Alchemy:
Log/print the SQL Alchemy query:
  logging.info(self.session.query(
      Revision.portfolio_id,
      func.max(Revision.valuation_date).label('max_date')
  ))
Retrieve what's printed in your logs and format it: https://sqlformat.org/​
Test the query against the database to see how to optimize it

how-to-investigate-performance.mo

front

Last modified 5yr ago

output-sql-alchemy-orm-query.mo

Owner: Xavier Lefevre​

Steps

Owner: Xavier Lefevre