Maciek Sakrejda <maciek@pganalyze.com> writes:
> I ran into an odd behavior with some EXPLAIN results in Postgres 11.5. I
> noticed this with JSON format first, but similar issues exist with the
> other formats as well for this query. I think I can follow up with the
> query and full plan if needed, but essentially, the issue is that the Sort
> node has two different entries for the "Workers" key (something that
> technically JSON does allow, but such JSON structures are very difficult to
> work with, and JSON library support for them is poor).
Yeah, this was already complained of here:
https://www.postgresql.org/message-id/flat/41ee53a5-a36e-cc8f-1bee-63f6565bb1ee%40dalibo.com
I think the text-mode output is intentional, but the other formats
need more work. We also need to think about whether we can change
this without big backwards-compatibility problems.
regards, tom lane