If I do something like this:
explain (analyze) select * from pgbench_accounts \watch 1
It behaves as expected. But once I break out of the loop with ctrl-C, then if I execute the same thing again it executes the command once, but shows no output and doesn't loop. It seems like some flag is getting set with ctrl-C, but then never gets reset.
It was broken in this commit:
commit a4fd3aa719e8f97299dfcf1a8f79b3017e2b8d8b
Author: Michael Paquier <
michael@paquier.xyz>
Date: Mon Dec 2 11:18:56 2019 +0900
Refactor query cancellation code into src/fe_utils/
I've not dug into code itself, I just bisected it.
Cheers,
Jeff