crystal icon indicating copy to clipboard operation
crystal copied to clipboard

GraphiQL / Explain Improvements

Open benjie opened this issue 5 years ago • 3 comments

  • [ ] 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

benjie avatar Feb 21 '20 07:02 benjie

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?

hyusetiawan avatar May 18 '20 06:05 hyusetiawan

Related:

  • https://github.com/graphile/crystal-pre-merge/issues/388
  • https://github.com/graphile/crystal-pre-merge/issues/413
  • https://github.com/graphile/crystal/pull/1618

benjie avatar Oct 04 '23 18:10 benjie

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

V4

image

V5

image

benjie avatar Oct 05 '23 07:10 benjie