qaisjp

JACR: is_op, direct filter analysed

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