Skip to content

Instantly share code, notes, and snippets.

@jeancx
Created January 9, 2019 15:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jeancx/7688c3a982fcb0e7e26c8e595c33c721 to your computer and use it in GitHub Desktop.
Save jeancx/7688c3a982fcb0e7e26c8e595c33c721 to your computer and use it in GitHub Desktop.

Exemplo:

EXPLAIN (FORMAT JSON) SELECT * FROM foo;
           QUERY PLAN
--------------------------------
 [                             +
   {                           +
     "Plan": {                 +
       "Node Type": "Seq Scan",+
       "Relation Name": "foo", +
       "Alias": "foo",         +
       "Startup Cost": 0.00,   +
       "Total Cost": 155.00,   +
       "Plan Rows": 10000,     +
       "Plan Width": 4         +
     }                         +
   }                           +
 ]
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment