Skip to content

Instantly share code, notes, and snippets.

@chyikwei
Last active March 23, 2020 01:30
Show Gist options
  • Save chyikwei/9b1de9e9be31494e2448cc8626058a0e to your computer and use it in GitHub Desktop.
Save chyikwei/9b1de9e9be31494e2448cc8626058a0e to your computer and use it in GitHub Desktop.
presto> explain (type distributed, format json) select * from example.example.numbers;
Query Plan
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[ {
"id" : "5",
"name" : "Output",
"identifier" : "[text, value]",
"details" : "",
"children" : [ {
"id" : "63",
"name" : "RemoteSource",
"identifier" : "[1]",
"details" : "",
"children" : [ ],
"remoteSources" : [ "1" ]
} ],
"remoteSources" : [ ]
}, {
"id" : "0",
"name" : "TableScan",
"identifier" : "[TableHandle {connectorId='example', connectorHandle='example:example:numbers', layout='Optional[example:example:numbers]'}]",
"details" : "text := ExampleColumnHandle{connectorId=example, columnName=text, columnType=varchar, ordinalPosition=0}\nvalue := ExampleColumnHandle{connectorId=example, columnName=value, columnType=bigint, ord
"children" : [ ],
"remoteSources" : [ ]
} ]
(1 row)
presto> explain (type logical, format json) select * from example.example.numbers;
Query Plan
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{
"id" : "5",
"name" : "Output",
"identifier" : "[text, value]",
"details" : "",
"children" : [ {
"id" : "63",
"name" : "RemoteStreamingExchange",
"identifier" : "[GATHER]",
"details" : "",
"children" : [ {
"id" : "0",
"name" : "TableScan",
"identifier" : "[TableHandle {connectorId='example', connectorHandle='example:example:numbers', layout='Optional[example:example:numbers]'}]",
"details" : "text := ExampleColumnHandle{connectorId=example, columnName=text, columnType=varchar, ordinalPosition=0}\nvalue := ExampleColumnHandle{connectorId=example, columnName=value, columnType=bigint,
"children" : [ ],
"remoteSources" : [ ]
} ],
"remoteSources" : [ ]
} ],
"remoteSources" : [ ]
}
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment