Alexander Lakhin <exclus...@gmail.com> writes: > When playing with JSON_TABLE, I tried to replace tenk1 in regression tests > with a view based on JSON_TABLE, with the same content, and discovered > that for one sub-optimal query it's execution duration increased many-fold. > With the preparation script attached, I see the following durations > (for a build compiled by clang 18.1.3 with -O3): > explain (verbose, analyze) > select > (select max((select i.unique2 from tenk1 i where i.unique1 = o.unique1))) > from tenk1 o; > -- original tenk1 > Execution Time: 4769.481 ms
Hm, I get about 13 ms for that example. Do you have some really expensive debugging infrastructure enabled, perhaps? regards, tom lane