DB queries in django scripts

[Web Architect]

Hi,

We have a Django 1.11 based ecommerce web site. 

We use django management scripts and django extension of runscript heavily for DB operations - running under cron. 

There's a tool - django-debugtoolbar to check the DB queries on the web. But is there a tool to monitor/check the DB queries for scripts? This would be really helpful in our script optimisation.

Looking forward to the info.

Thanks.

[Derek]

If you are using PostggeQL you may want to look at the query analysis produced by:
https://www.postgresql.org/docs/current/pgstatstatements.html

There are various third-party tools to gather output from the pg_stat_statements and make it available e.g.

https://github.com/pganalyze/collector

https://www.mni.de/using-grafana-with-pg_stat_statements/ 

https://grafana.com/docs/features/datasources/postgres/

[Web Architect]

Hi Derek,

Thanks for your response. We are using MySQL. Could you suggest something similar for the same?

Thanks.

[Derek]

Sorry, no, we use Postgresql - perhaps you may want to consider it too (it is the recommended one for Django)?

Failing that, I know there are numerous third-party tools for MySQL/Maria - perhaps have a look and see what can be found. Eg. Google shows me this one:

https://www.idera.com/productssolutions/freetools/monitor-mysql-queries