qaisjp

JACR: is_op, slow function analysed

Jul 2nd, 2017
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 1.86 KB | None | 0 0
  1. [
  2.   {
  3.     "Plan": {
  4.       "Node Type": "Aggregate",
  5.       "Strategy": "Plain",
  6.       "Partial Mode": "Simple",
  7.       "Parallel Aware": false,
  8.       "Startup Cost": 20373.66,
  9.       "Total Cost": 20373.67,
  10.       "Plan Rows": 1,
  11.       "Plan Width": 8,
  12.       "Actual Startup Time": 307.750,
  13.       "Actual Total Time": 307.750,
  14.       "Actual Rows": 1,
  15.       "Actual Loops": 1,
  16.       "Output": ["count(total_plays)"],
  17.       "Shared Hit Blocks": 1361,
  18.       "Shared Read Blocks": 0,
  19.       "Shared Dirtied Blocks": 0,
  20.       "Shared Written Blocks": 0,
  21.       "Local Hit Blocks": 0,
  22.       "Local Read Blocks": 0,
  23.       "Local Dirtied Blocks": 0,
  24.       "Local Written Blocks": 0,
  25.       "Temp Read Blocks": 0,
  26.       "Temp Written Blocks": 0,
  27.       "Plans": [
  28.         {
  29.           "Node Type": "Seq Scan",
  30.           "Parent Relationship": "Outer",
  31.           "Parallel Aware": false,
  32.           "Relation Name": "songs",
  33.           "Schema": "public",
  34.           "Alias": "songs",
  35.           "Startup Cost": 0.00,
  36.           "Total Cost": 20312.92,
  37.           "Plan Rows": 24297,
  38.           "Plan Width": 4,
  39.           "Actual Startup Time": 3.398,
  40.           "Actual Total Time": 307.684,
  41.           "Actual Rows": 81,
  42.           "Actual Loops": 1,
  43.           "Output": ["total_plays"],
  44.           "Filter": "is_op(songs.last_play, songs.recent_plays)",
  45.           "Rows Removed by Filter": 72984,
  46.           "Shared Hit Blocks": 1361,
  47.           "Shared Read Blocks": 0,
  48.           "Shared Dirtied Blocks": 0,
  49.           "Shared Written Blocks": 0,
  50.           "Local Hit Blocks": 0,
  51.           "Local Read Blocks": 0,
  52.           "Local Dirtied Blocks": 0,
  53.           "Local Written Blocks": 0,
  54.           "Temp Read Blocks": 0,
  55.           "Temp Written Blocks": 0
  56.         }
  57.       ]
  58.     },
  59.     "Planning Time": 0.144,
  60.     "Triggers": [
  61.     ],
  62.     "Execution Time": 307.789
  63.   }
  64. ]
Advertisement
Add Comment
Please, Sign In to add comment