edgedb-cli icon indicating copy to clipboard operation
edgedb-cli copied to clipboard

Maybe display both "plan rows" and "actual rows" in analyze output

Open msullivan opened this issue 1 year ago • 0 comments

Postgres/edgedb reports both "plan_rows" (the number of estimated rows returned by a node in the plan tree) and "actual_rows" (the actual number of rows returned)

It looks like the CLI only displays actual_rows if present, otherwise plan_rows, even in \expandd mode. The distinction is not always useful, but it's sometimes important to make sense of confusing behaviors like reported in https://github.com/edgedb/edgedb/issues/5879

It might also be useful to have a displayed hint that \expand can be run for more detailed output. (I don't know if I have ever been satisfied by the non-expanded output.)

msullivan avatar Oct 12 '23 23:10 msullivan