On Dec 21, 2009, at 7:40 PM, kris wrote: > Is it possible to turn on explain analyze during query execution.. I > have some slow queries > and it would be very useful if we could simply enable analysis at > runtime.
nothing built in for this - I generally use engine logging or Postgresql logging (the latter is preferred since it embeds bound values inline), cut and paste the queries and add EXPLAIN ANAYLZE to the beginning. For PG I'd recommend using their "slow query log" feature to simplify the whole job. > > > Thanks, > Kris > > -- > > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
