On Thu, Jul 2, 2020 at 8:47 AM James Coleman <jtc...@gmail.com> wrote: > It seems like the consensus over at another discussion on this topic > [1] is that we ought to go ahead and print the zeros [for machine > readable output formats], even though that creates some interesting > scenarios like the fact that disk sorts will print 0 for memory even > though that's not true.
What about having it print -1 for memory in this case instead? That's still not ideal, but machine readable EXPLAIN output ought to consistently show the same information per node, even when the answer is in some sense indeterminate. That seems to be the standard that we've settled on. It might be worth teaching the JSON format to show a JSON null or something instead. Not sure about that, though. -- Peter Geoghegan
