Postgraphile: Output executed Postgres queries?
Forgive me if there's an answer for this somewhere, but it might be nice to have an option to show the SQL that gets sent to Postgres from PostGraphQL. Any idea how this might be done?
mgallagher
All 6 comments
We use the debug module, so you can run export DEBUG="postgraphql:*" (assuming bash shell) before running postgraphql to see various output. For postgres queries specifically you want DEBUG=postgraphql:postgres; but DEBUG=postgraphql:postgres:explain is also handy.
benjie
on 12 Jan 2017
Excellent. Thank you @benjie! This works perfectly :)
mgallagher
on 12 Jan 2017
@benjie this should be mentioned in document
lcjnil
on 13 Jan 2017
@lcjnil I totally agree. Pull requests are welcome 馃憤
benjie
on 13 Jan 2017
FYI: It should now be export DEBUG="postgraphile:*" in case anyone is looking at this issue in 2018.
deslee
on 14 Mar 2018
This is now documented here: https://www.graphile.org/postgraphile/debugging/#step-4-viewing-the-generated-sql
benjie
on 15 Aug 2018
Related issues
srghma
路
3Comments
CarlFMateus
路
4Comments
outsidenote
路
4Comments
ssomnoremac
路
5Comments
jwdotjs
路
5Comments
Most helpful comment
We use the
debugmodule, so you can runexport DEBUG="postgraphql:*"(assuming bash shell) before running postgraphql to see various output. For postgres queries specifically you wantDEBUG=postgraphql:postgres; butDEBUG=postgraphql:postgres:explainis also handy.