2013/1/13 Dimitri Fontaine <dimi...@2ndquadrant.fr>: > Pavel Stehule <pavel.steh...@gmail.com> writes: >> My propose is proposed for different dimensions and purpose - for >> example - we have a limit 20 minutes for almost all queries, and after >> this limit we killing queries. But we have to know little bit more >> about these bad queries - and we hope, so execution plan can give this >> additional info. We have same motivation like people who use >> auto_explain for slow query - but we can't to wait to query complete. > > Set auto_explain.log_min_duration to 19 mins or maybe 17 and be done?
We have limit 5 sec - but we have to kill queries after 20 minutes - and we have no plan for these queries. Regards Pavel > > Regards, > -- > Dimitri Fontaine > http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
