Skip to content

Instantly share code, notes, and snippets.

@felixge

felixge/plan.json

Created February 2, 2020 16:59
Show Gist options
  • Save felixge/a452337c84a226fc7d1c0730b55abd20 to your computer and use it in GitHub Desktop.
Save felixge/a452337c84a226fc7d1c0730b55abd20 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
plan.json
[
{
"Plan": {
"Node Type": "Nested Loop",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 0.01,
"Total Cost": 17402710335540.01,
"Plan Rows": 1000000000000000,
"Plan Width": 20,
"Actual Startup Time": 0.038,
"Actual Total Time": 42.040,
"Actual Rows": 100000,
"Actual Loops": 1,
"Inner Unique": false,
"Plans": [
{
"Node Type": "Function Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Function Name": "generate_series",
"Alias": "e",
"Startup Cost": 0.00,
"Total Cost": 10.00,
"Plan Rows": 1000,
"Plan Width": 4,
"Actual Startup Time": 0.008,
"Actual Total Time": 0.015,
"Actual Rows": 10,
"Actual Loops": 1
},
{
"Node Type": "Materialize",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 0.01,
"Total Cost": 27280648030.01,
"Plan Rows": 1000000000000,
"Plan Width": 16,
"Actual Startup Time": 0.003,
"Actual Total Time": 1.736,
"Actual Rows": 10000,
"Actual Loops": 10,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 0.01,
"Total Cost": 17397835530.01,
"Plan Rows": 1000000000000,
"Plan Width": 16,
"Actual Startup Time": 0.027,
"Actual Total Time": 4.571,
"Actual Rows": 10000,
"Actual Loops": 1,
"Inner Unique": false,
"Plans": [
{
"Node Type": "Function Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Function Name": "generate_series",
"Alias": "d",
"Startup Cost": 0.00,
"Total Cost": 10.00,
"Plan Rows": 1000,
"Plan Width": 4,
"Actual Startup Time": 0.003,
"Actual Total Time": 0.006,
"Actual Rows": 10,
"Actual Loops": 1
},
{
"Node Type": "Materialize",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 0.01,
"Total Cost": 22405333.01,
"Plan Rows": 1000000000,
"Plan Width": 12,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.188,
"Actual Rows": 1000,
"Actual Loops": 10,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 0.01,
"Total Cost": 12522520.01,
"Plan Rows": 1000000000,
"Plan Width": 12,
"Actual Startup Time": 0.022,
"Actual Total Time": 0.477,
"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.003,
"Actual Total Time": 0.005,
"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.002,
"Actual Total Time": 0.022,
"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.016,
"Actual Total Time": 0.059,
"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.009,
"Actual Total Time": 0.010,
"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.001,
"Actual Total Time": 0.002,
"Actual Rows": 10,
"Actual Loops": 10
}
]
}
]
}
]
}
]
}
]
}
]
}
]
},
"Planning Time": 0.201,
"Triggers": [
],
"Execution Time": 48.652
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment