GraphiQL / Explain Improvements

[benjie]

• Add option to enable analyze on queries only
• Add option to export as JSON rather than text (for import into https://tatiyants.com/pev/#/plans/new)
• Add button (or similar) to easily copy the SQL query or explain results

[hyusetiawan]

maybe im just not used to it, but is it possible to improve the readability?

select to_json(dob) as "__dob"
from users as __local_0__
where (
  __local_0__.id = $1
) and (TRUE) and (TRUE)

is hard to parse what is going on, or perhaps there is a guide on how to understand it?

[benjie]

Related:

• Fix EXPLAIN crystal-pre-merge#388
• Ruru full explain configuration via headers crystal-pre-merge#413
• Add support for EXPLAIN options to GraphiQL #1618

[benjie]

@hyusetiawan FYI the SQL in V5 is significantly easier to understand:

V4

V5