Where Did That Sqlalchemy SQL Originate?
ORMs such as SQLAlchemy are very useful, but can easily generate very inefficient unrecognisable code. Here’s an easy way to log where the query originates in your code.
PostgreSQL
Profiling PostGIS with PLProfiler
PLProfiler is a great tool for profiling PL/PGSQL functions, but you need an extra trick for PostGIS native functions.