On Wed, Apr 19, 2023 at 11:17:04AM -0400, Melanie Plageman wrote:
> Ultimately this is probably fine. If we wanted to modify one of the
> existing tests to cover the multi-batch case, changing the select
> count(*) to a select * would do the trick. I imagine we wouldn't want to
> do this because of the excessive output this would produce. I wondered
> if there was a pattern in the tests for getting around this.
You could use explain (ANALYZE). But the output is machine-dependant in
various ways (which is why the tests use "explain analyze so rarely).
So you'd have to filter its output with a function (like the functions
that exist in a few places for similar purpose).
--
Justin