-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Em 16-05-2013 07:52, Pavel Stehule escreveu: > 2013/5/16 Thom Brown <t...@linux.com>: >> On 16 May 2013 11:09, Pavel Stehule <pavel.steh...@gmail.com> >> wrote: >>> Hello >>> >>> I proposed a some months log plans of cancelled queries >>> http://www.postgresql.org/message-id/cafj8pra-duzkmdtu52ciugb0p7tvri_b8ltjmjfwcnr1lpt...@mail.gmail.com >>> >> >> >>> What a neat idea. So the original plan of EXPLAINing cancelled >> queries... does this cater for that? Can cancelled queries >> automatically invoke the EXPLAIN functionality as part of this >> feature? >> > > I would to get EXPLAIN of long queries without waiting on end. > > So it is possible for manual cancelation (not for timeout) > > SELECT pg_explain_backend(xx); SELECT pg_cancel_backend(xx);
BTOH, we could provide a pg_cancel_backend(pid, boolean) so when that boolean is true it will do that job. Particularly I'm not a fan of this kind of boolean flag and appreciate the two function above, so +1. BTW, if somebody wants an explain-and-cancel behavior he could creates a function and call both function pg_(explain|cancel)_backend(..) consecutively. []s - -- Dickson S. Guedes mail/xmpp: gue...@guedesoft.net - skype: guediz http://guedesoft.net - http://www.postgresql.org.br http://github.net/guedes - twitter: @guediz -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJRl3thAAoJEBa5zL7BI5C74voIAJ0PhUlnRz/MEyS3ckeQPNEp 6ZT1f4zddkP+oC626+uv9Gb34lokg6Y+5JrMYFcKm3Pq+3mIiKaq2yY08GW3pkBk 7zbvTSKCQdNO7PprhR9EUjyJ5IZrwkG8nNZJm+98ohkv5dZiHqLl0ovGJGg2yeLd kkRTmQOOmPalBado1i8SARaEq6apelpmPETl7fkutXAMhq4MSfsB0x0ZofT9/RDA H18/kssql7BVtm7Rw9uJJe37vnpJJgrsjf8qHzJFZcyhxDjMDHAyzViacfKtd8Mv WPbZcVTQ5jHHmyReIPECAPseQ/m9eV8gM66X2elO4MDyCZ0hB9xaqZCixnx1844= =AL0R -----END PGP SIGNATURE----- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
