Skip to content

Instantly share code, notes, and snippets.

@felixge
Last active January 28, 2020 09:43
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 felixge/44a1ddd4830737853588f417c365d3c9 to your computer and use it in GitHub Desktop.
Save felixge/44a1ddd4830737853588f417c365d3c9 to your computer and use it in GitHub Desktop.
[
{
"Plan": {
"Node Type": "Nested Loop",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 0.01,
"Total Cost": 20010.01,
"Plan Rows": 1000000,
"Plan Width": 8,
"Actual Startup Time": 0.017,
"Actual Total Time": 0.151,
"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.008,
"Actual Total Time": 0.009,
"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.046,
"Triggers": [
],
"Execution Time": 0.089
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment