Skip to content

Instantly share code, notes, and snippets.

@felixge
Created August 13, 2020 08:30
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/d95c6de7296070383aaacbd67c3c3a52 to your computer and use it in GitHub Desktop.
Save felixge/d95c6de7296070383aaacbd67c3c3a52 to your computer and use it in GitHub Desktop.
{
"flameExplain": "Go to flame-explain.com and paste this JSON in the Input tab.",
"input": {
"plan": "[\n {\n \"Plan\": {\n \"Node Type\": \"Function Scan\",\n \"Parallel Aware\": false,\n \"Function Name\": \"generate_series\",\n \"Schema\": \"pg_catalog\",\n \"Alias\": \"generate_series\",\n \"Startup Cost\": 0.00,\n \"Total Cost\": 10.00,\n \"Plan Rows\": 1000,\n \"Plan Width\": 4,\n \"Actual Startup Time\": 194.503,\n \"Actual Total Time\": 331.185,\n \"Actual Rows\": 1500000,\n \"Actual Loops\": 1,\n \"Output\": [\"generate_series\"],\n \"Function Call\": \"generate_series(1, 1500000)\",\n \"Shared Hit Blocks\": 0,\n \"Shared Read Blocks\": 0,\n \"Shared Dirtied Blocks\": 0,\n \"Shared Written Blocks\": 0,\n \"Local Hit Blocks\": 0,\n \"Local Read Blocks\": 0,\n \"Local Dirtied Blocks\": 0,\n \"Local Written Blocks\": 0,\n \"Temp Read Blocks\": 0,\n \"Temp Written Blocks\": 0\n },\n \"Planning Time\": 0.046,\n \"Triggers\": [\n ],\n \"Execution Time\": 468.095\n }\n]",
"sql": "EXPLAIN (ANALYZE, FORMAT JSON, VERBOSE, BUFFERS)\nSELECT * FROM generate_series(1, 1500000)"
},
"favorites": [
"ID",
"Label",
"Actual Rows"
],
"collapsed": {}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment