Skip to content

Instantly share code, notes, and snippets.

@felixge

felixge/plan.json

Created Feb 1, 2020
Embed
What would you like to do?
[
{
"Plan": {
"Node Type": "Nested Loop",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 0.01,
"Total Cost": 12522520.01,
"Plan Rows": 1000000000,
"Plan Width": 12,
"Actual Startup Time": 0.027,
"Actual Total Time": 0.642,
"Actual Rows": 1000,
"Actual Loops": 1,
"Inner Unique": false,
"Plans": [
{
"Node Type": "Function Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Function Name": "generate_series",
"Alias": "c",
"Startup Cost": 0.00,
"Total Cost": 10.00,
"Plan Rows": 1000,
"Plan Width": 4,
"Actual Startup Time": 0.009,
"Actual Total Time": 0.012,
"Actual Rows": 10,
"Actual Loops": 1
},
{
"Node Type": "Materialize",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 0.01,
"Total Cost": 25010.01,
"Plan Rows": 1000000,
"Plan Width": 8,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.026,
"Actual Rows": 100,
"Actual Loops": 10,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 0.01,
"Total Cost": 20010.01,
"Plan Rows": 1000000,
"Plan Width": 8,
"Actual Startup Time": 0.010,
"Actual Total Time": 0.107,
"Actual Rows": 100,
"Actual Loops": 1,
"Inner Unique": false,
"Plans": [
{
"Node Type": "Function Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Function Name": "generate_series",
"Alias": "a",
"Startup Cost": 0.00,
"Total Cost": 10.00,
"Plan Rows": 1000,
"Plan Width": 4,
"Actual Startup Time": 0.004,
"Actual Total Time": 0.005,
"Actual Rows": 10,
"Actual Loops": 1
},
{
"Node Type": "Function Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Function Name": "generate_series",
"Alias": "b",
"Startup Cost": 0.00,
"Total Cost": 10.00,
"Plan Rows": 1000,
"Plan Width": 4,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.007,
"Actual Rows": 10,
"Actual Loops": 10
}
]
}
]
}
]
},
"Planning Time": 40.502,
"Triggers": [
],
"Execution Time": 81.254
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment