Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
explain deleting from metrics (actual execution. in json this time)
This file has been truncated, but you can view the full file.
[
{
"Plan": {
"Node Type": "ModifyTable",
"Operation": "Delete",
"Relation Name": "metrics",
"Schema": "public",
"Alias": "metrics",
"Startup Cost": 26.03,
"Total Cost": 37347.65,
"Plan Rows": 2207,
"Plan Width": 38,
"Actual Startup Time": 90491.361,
"Actual Total Time": 90491.361,
"Actual Rows": 0,
"Actual Loops": 1,
"Target Tables": [
{
"Relation Name": "metrics",
"Schema": "public",
"Alias": "metrics"
},
{
"Relation Name": "metrics_00",
"Schema": "public",
"Alias": "metrics_00"
},
{
"Relation Name": "metrics_01",
"Schema": "public",
"Alias": "metrics_01"
},
{
"Relation Name": "metrics_02",
"Schema": "public",
"Alias": "metrics_02"
},
{
"Relation Name": "metrics_03",
"Schema": "public",
"Alias": "metrics_03"
},
{
"Relation Name": "metrics_04",
"Schema": "public",
"Alias": "metrics_04"
},
{
"Relation Name": "metrics_05",
"Schema": "public",
"Alias": "metrics_05"
},
{
"Relation Name": "metrics_06",
"Schema": "public",
"Alias": "metrics_06"
},
{
"Relation Name": "metrics_07",
"Schema": "public",
"Alias": "metrics_07"
},
{
"Relation Name": "metrics_08",
"Schema": "public",
"Alias": "metrics_08"
},
{
"Relation Name": "metrics_09",
"Schema": "public",
"Alias": "metrics_09"
},
{
"Relation Name": "metrics_10",
"Schema": "public",
"Alias": "metrics_10"
},
{
"Relation Name": "metrics_11",
"Schema": "public",
"Alias": "metrics_11"
},
{
"Relation Name": "metrics_12",
"Schema": "public",
"Alias": "metrics_12"
},
{
"Relation Name": "metrics_13",
"Schema": "public",
"Alias": "metrics_13"
},
{
"Relation Name": "metrics_14",
"Schema": "public",
"Alias": "metrics_14"
},
{
"Relation Name": "metrics_15",
"Schema": "public",
"Alias": "metrics_15"
},
{
"Relation Name": "metrics_16",
"Schema": "public",
"Alias": "metrics_16"
},
{
"Relation Name": "metrics_17",
"Schema": "public",
"Alias": "metrics_17"
},
{
"Relation Name": "metrics_18",
"Schema": "public",
"Alias": "metrics_18"
},
{
"Relation Name": "metrics_19",
"Schema": "public",
"Alias": "metrics_19"
},
{
"Relation Name": "metrics_20",
"Schema": "public",
"Alias": "metrics_20"
},
{
"Relation Name": "metrics_21",
"Schema": "public",
"Alias": "metrics_21"
},
{
"Relation Name": "metrics_22",
"Schema": "public",
"Alias": "metrics_22"
},
{
"Relation Name": "metrics_23",
"Schema": "public",
"Alias": "metrics_23"
}
],
"Shared Hit Blocks": 42399,
"Shared Read Blocks": 21848991,
"Shared Dirtied Blocks": 8,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Member",
"Join Type": "Semi",
"Startup Cost": 26.03,
"Total Cost": 26.03,
"Plan Rows": 1,
"Plan Width": 38,
"Actual Startup Time": 0.005,
"Actual Total Time": 0.005,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["metrics.ctid", "\"ANY_subquery\".*"],
"Hash Cond": "(metrics.id = \"ANY_subquery\".id)",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Relation Name": "metrics",
"Schema": "public",
"Alias": "metrics",
"Startup Cost": 0.00,
"Total Cost": 0.00,
"Plan Rows": 1,
"Plan Width": 14,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.002,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["metrics.ctid", "metrics.id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Startup Cost": 24.78,
"Total Cost": 24.78,
"Plan Rows": 100,
"Plan Width": 40,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["\"ANY_subquery\".*", "\"ANY_subquery\".id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Subquery Scan",
"Parent Relationship": "Outer",
"Alias": "ANY_subquery",
"Startup Cost": 0.00,
"Total Cost": 24.78,
"Plan Rows": 100,
"Plan Width": 40,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["\"ANY_subquery\".*", "\"ANY_subquery\".id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Limit",
"Parent Relationship": "Subquery",
"Startup Cost": 0.00,
"Total Cost": 23.78,
"Plan Rows": 100,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_1.id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Append",
"Parent Relationship": "Outer",
"Startup Cost": 0.00,
"Total Cost": 4410192.47,
"Plan Rows": 18544692,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics",
"Schema": "public",
"Alias": "metrics_1",
"Startup Cost": 0.00,
"Total Cost": 0.00,
"Plan Rows": 1,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_1.id"],
"Filter": "(metrics_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_00",
"Schema": "public",
"Alias": "metrics_00_1",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_00_1.id"],
"Filter": "(metrics_00_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_01",
"Schema": "public",
"Alias": "metrics_01_1",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_01_1.id"],
"Filter": "(metrics_01_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_02",
"Schema": "public",
"Alias": "metrics_02_1",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_02_1.id"],
"Filter": "(metrics_02_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_03",
"Schema": "public",
"Alias": "metrics_03_1",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_03_1.id"],
"Filter": "(metrics_03_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_04",
"Schema": "public",
"Alias": "metrics_04_1",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_04_1.id"],
"Filter": "(metrics_04_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_05",
"Schema": "public",
"Alias": "metrics_05_1",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_05_1.id"],
"Filter": "(metrics_05_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "index_metrics_06_on_ts_and_capture_interval_name",
"Relation Name": "metrics_06",
"Schema": "public",
"Alias": "metrics_06_1",
"Startup Cost": 0.39,
"Total Cost": 281.02,
"Plan Rows": 1,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_06_1.id"],
"Index Cond": "(metrics_06_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "index_metrics_07_on_ts_and_capture_interval_name",
"Relation Name": "metrics_07",
"Schema": "public",
"Alias": "metrics_07_1",
"Startup Cost": 0.39,
"Total Cost": 2286.23,
"Plan Rows": 1,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_07_1.id"],
"Index Cond": "(metrics_07_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "index_metrics_08_on_ts_and_capture_interval_name",
"Relation Name": "metrics_08",
"Schema": "public",
"Alias": "metrics_08_1",
"Startup Cost": 0.12,
"Total Cost": 8.14,
"Plan Rows": 1,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_08_1.id"],
"Index Cond": "(metrics_08_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "index_metrics_09_on_ts_and_capture_interval_name",
"Relation Name": "metrics_09",
"Schema": "public",
"Alias": "metrics_09_1",
"Startup Cost": 0.40,
"Total Cost": 222.58,
"Plan Rows": 1,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_09_1.id"],
"Index Cond": "(metrics_09_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Bitmap Heap Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_10",
"Schema": "public",
"Alias": "metrics_10_1",
"Startup Cost": 1808.68,
"Total Cost": 6977.71,
"Plan Rows": 1566,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_10_1.id"],
"Recheck Cond": "(metrics_10_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)", +
"Rows Removed by Index Recheck": 0,
"Exact Heap Blocks": 0,
"Lossy Heap Blocks": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Bitmap Index Scan",
"Parent Relationship": "Outer",
"Index Name": "index_metrics_10_on_ts_and_capture_interval_name",
"Startup Cost": 0.00,
"Total Cost": 1808.29,
"Plan Rows": 1566,
"Plan Width": 0,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Index Cond": "(metrics_10_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)", +
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_11",
"Schema": "public",
"Alias": "metrics_11_1",
"Startup Cost": 0.00,
"Total Cost": 245446.61,
"Plan Rows": 487284,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_11_1.id"],
"Filter": "(metrics_11_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "index_metrics_12_on_ts_and_capture_interval_name",
"Relation Name": "metrics_12",
"Schema": "public",
"Alias": "metrics_12_1",
"Startup Cost": 0.55,
"Total Cost": 284.03,
"Plan Rows": 66,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_12_1.id"],
"Index Cond": "(metrics_12_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_13",
"Schema": "public",
"Alias": "metrics_13_1",
"Startup Cost": 0.00,
"Total Cost": 486237.14,
"Plan Rows": 1823609,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_13_1.id"],
"Filter": "(metrics_13_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_14",
"Schema": "public",
"Alias": "metrics_14_1",
"Startup Cost": 0.00,
"Total Cost": 103778.50,
"Plan Rows": 271425,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_14_1.id"],
"Filter": "(metrics_14_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_15",
"Schema": "public",
"Alias": "metrics_15_1",
"Startup Cost": 0.00,
"Total Cost": 435378.46,
"Plan Rows": 1451402,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_15_1.id"],
"Filter": "(metrics_15_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_16",
"Schema": "public",
"Alias": "metrics_16_1",
"Startup Cost": 0.00,
"Total Cost": 25891.25,
"Plan Rows": 1411022,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_16_1.id"],
"Filter": "(metrics_16_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Bitmap Heap Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_17",
"Schema": "public",
"Alias": "metrics_17_1",
"Startup Cost": 15380.68,
"Total Cost": 205479.54,
"Plan Rows": 87291,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_17_1.id"],
"Recheck Cond": "(metrics_17_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)", +
"Rows Removed by Index Recheck": 0,
"Exact Heap Blocks": 0,
"Lossy Heap Blocks": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Bitmap Index Scan",
"Parent Relationship": "Outer",
"Index Name": "index_metrics_17_on_ts_and_capture_interval_name",
"Startup Cost": 0.00,
"Total Cost": 15358.86,
"Plan Rows": 87291,
"Plan Width": 0,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Index Cond": "(metrics_17_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)", +
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_18",
"Schema": "public",
"Alias": "metrics_18_1",
"Startup Cost": 0.00,
"Total Cost": 422627.19,
"Plan Rows": 1667596,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_18_1.id"],
"Filter": "(metrics_18_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_19",
"Schema": "public",
"Alias": "metrics_19_1",
"Startup Cost": 0.00,
"Total Cost": 493598.59,
"Plan Rows": 2990170,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_19_1.id"],
"Filter": "(metrics_19_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_20",
"Schema": "public",
"Alias": "metrics_20_1",
"Startup Cost": 0.00,
"Total Cost": 492859.35,
"Plan Rows": 2080476,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_20_1.id"],
"Filter": "(metrics_20_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_21",
"Schema": "public",
"Alias": "metrics_21_1",
"Startup Cost": 0.00,
"Total Cost": 496204.62,
"Plan Rows": 2088911,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_21_1.id"],
"Filter": "(metrics_21_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_22",
"Schema": "public",
"Alias": "metrics_22_1",
"Startup Cost": 0.00,
"Total Cost": 496263.41,
"Plan Rows": 2103562,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_22_1.id"],
"Filter": "(metrics_22_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_23",
"Schema": "public",
"Alias": "metrics_23_1",
"Startup Cost": 0.00,
"Total Cost": 496299.85,
"Plan Rows": 2080085,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_23_1.id"],
"Filter": "(metrics_23_1.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
}
]
},
{
"Node Type": "Hash Join",
"Parent Relationship": "Member",
"Join Type": "Semi",
"Startup Cost": 26.03,
"Total Cost": 38.53,
"Plan Rows": 100,
"Plan Width": 38,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.001,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["metrics_00.ctid", "\"ANY_subquery_1\".*"],
"Hash Cond": "(metrics_00.id = \"ANY_subquery_1\".id)",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Relation Name": "metrics_00",
"Schema": "public",
"Alias": "metrics_00",
"Startup Cost": 0.00,
"Total Cost": 11.10,
"Plan Rows": 110,
"Plan Width": 14,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.001,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["metrics_00.ctid", "metrics_00.id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Startup Cost": 24.78,
"Total Cost": 24.78,
"Plan Rows": 100,
"Plan Width": 40,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["\"ANY_subquery_1\".*", "\"ANY_subquery_1\".id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Subquery Scan",
"Parent Relationship": "Outer",
"Alias": "ANY_subquery_1",
"Startup Cost": 0.00,
"Total Cost": 24.78,
"Plan Rows": 100,
"Plan Width": 40,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["\"ANY_subquery_1\".*", "\"ANY_subquery_1\".id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Limit",
"Parent Relationship": "Subquery",
"Startup Cost": 0.00,
"Total Cost": 23.78,
"Plan Rows": 100,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_2.id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Append",
"Parent Relationship": "Outer",
"Startup Cost": 0.00,
"Total Cost": 4410192.47,
"Plan Rows": 18544692,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics",
"Schema": "public",
"Alias": "metrics_2",
"Startup Cost": 0.00,
"Total Cost": 0.00,
"Plan Rows": 1,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_2.id"],
"Filter": "(metrics_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_00",
"Schema": "public",
"Alias": "metrics_00_2",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_00_2.id"],
"Filter": "(metrics_00_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_01",
"Schema": "public",
"Alias": "metrics_01_2",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_01_2.id"],
"Filter": "(metrics_01_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_02",
"Schema": "public",
"Alias": "metrics_02_2",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_02_2.id"],
"Filter": "(metrics_02_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_03",
"Schema": "public",
"Alias": "metrics_03_2",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_03_2.id"],
"Filter": "(metrics_03_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_04",
"Schema": "public",
"Alias": "metrics_04_2",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_04_2.id"],
"Filter": "(metrics_04_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_05",
"Schema": "public",
"Alias": "metrics_05_2",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_05_2.id"],
"Filter": "(metrics_05_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "index_metrics_06_on_ts_and_capture_interval_name",
"Relation Name": "metrics_06",
"Schema": "public",
"Alias": "metrics_06_2",
"Startup Cost": 0.39,
"Total Cost": 281.02,
"Plan Rows": 1,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_06_2.id"],
"Index Cond": "(metrics_06_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "index_metrics_07_on_ts_and_capture_interval_name",
"Relation Name": "metrics_07",
"Schema": "public",
"Alias": "metrics_07_2",
"Startup Cost": 0.39,
"Total Cost": 2286.23,
"Plan Rows": 1,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_07_2.id"],
"Index Cond": "(metrics_07_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "index_metrics_08_on_ts_and_capture_interval_name",
"Relation Name": "metrics_08",
"Schema": "public",
"Alias": "metrics_08_2",
"Startup Cost": 0.12,
"Total Cost": 8.14,
"Plan Rows": 1,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_08_2.id"],
"Index Cond": "(metrics_08_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "index_metrics_09_on_ts_and_capture_interval_name",
"Relation Name": "metrics_09",
"Schema": "public",
"Alias": "metrics_09_2",
"Startup Cost": 0.40,
"Total Cost": 222.58,
"Plan Rows": 1,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_09_2.id"],
"Index Cond": "(metrics_09_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Bitmap Heap Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_10",
"Schema": "public",
"Alias": "metrics_10_2",
"Startup Cost": 1808.68,
"Total Cost": 6977.71,
"Plan Rows": 1566,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_10_2.id"],
"Recheck Cond": "(metrics_10_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)", +
"Rows Removed by Index Recheck": 0,
"Exact Heap Blocks": 0,
"Lossy Heap Blocks": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Bitmap Index Scan",
"Parent Relationship": "Outer",
"Index Name": "index_metrics_10_on_ts_and_capture_interval_name",
"Startup Cost": 0.00,
"Total Cost": 1808.29,
"Plan Rows": 1566,
"Plan Width": 0,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Index Cond": "(metrics_10_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)", +
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_11",
"Schema": "public",
"Alias": "metrics_11_2",
"Startup Cost": 0.00,
"Total Cost": 245446.61,
"Plan Rows": 487284,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_11_2.id"],
"Filter": "(metrics_11_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Scan Direction": "Forward",
"Index Name": "index_metrics_12_on_ts_and_capture_interval_name",
"Relation Name": "metrics_12",
"Schema": "public",
"Alias": "metrics_12_2",
"Startup Cost": 0.55,
"Total Cost": 284.03,
"Plan Rows": 66,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_12_2.id"],
"Index Cond": "(metrics_12_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_13",
"Schema": "public",
"Alias": "metrics_13_2",
"Startup Cost": 0.00,
"Total Cost": 486237.14,
"Plan Rows": 1823609,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_13_2.id"],
"Filter": "(metrics_13_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_14",
"Schema": "public",
"Alias": "metrics_14_2",
"Startup Cost": 0.00,
"Total Cost": 103778.50,
"Plan Rows": 271425,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_14_2.id"],
"Filter": "(metrics_14_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_15",
"Schema": "public",
"Alias": "metrics_15_2",
"Startup Cost": 0.00,
"Total Cost": 435378.46,
"Plan Rows": 1451402,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_15_2.id"],
"Filter": "(metrics_15_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_16",
"Schema": "public",
"Alias": "metrics_16_2",
"Startup Cost": 0.00,
"Total Cost": 25891.25,
"Plan Rows": 1411022,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_16_2.id"],
"Filter": "(metrics_16_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Bitmap Heap Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_17",
"Schema": "public",
"Alias": "metrics_17_2",
"Startup Cost": 15380.68,
"Total Cost": 205479.54,
"Plan Rows": 87291,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_17_2.id"],
"Recheck Cond": "(metrics_17_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)", +
"Rows Removed by Index Recheck": 0,
"Exact Heap Blocks": 0,
"Lossy Heap Blocks": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Bitmap Index Scan",
"Parent Relationship": "Outer",
"Index Name": "index_metrics_17_on_ts_and_capture_interval_name",
"Startup Cost": 0.00,
"Total Cost": 15358.86,
"Plan Rows": 87291,
"Plan Width": 0,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Index Cond": "(metrics_17_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)", +
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_18",
"Schema": "public",
"Alias": "metrics_18_2",
"Startup Cost": 0.00,
"Total Cost": 422627.19,
"Plan Rows": 1667596,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_18_2.id"],
"Filter": "(metrics_18_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_19",
"Schema": "public",
"Alias": "metrics_19_2",
"Startup Cost": 0.00,
"Total Cost": 493598.59,
"Plan Rows": 2990170,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_19_2.id"],
"Filter": "(metrics_19_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_20",
"Schema": "public",
"Alias": "metrics_20_2",
"Startup Cost": 0.00,
"Total Cost": 492859.35,
"Plan Rows": 2080476,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_20_2.id"],
"Filter": "(metrics_20_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_21",
"Schema": "public",
"Alias": "metrics_21_2",
"Startup Cost": 0.00,
"Total Cost": 496204.62,
"Plan Rows": 2088911,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_21_2.id"],
"Filter": "(metrics_21_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_22",
"Schema": "public",
"Alias": "metrics_22_2",
"Startup Cost": 0.00,
"Total Cost": 496263.41,
"Plan Rows": 2103562,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_22_2.id"],
"Filter": "(metrics_22_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_23",
"Schema": "public",
"Alias": "metrics_23_2",
"Startup Cost": 0.00,
"Total Cost": 496299.85,
"Plan Rows": 2080085,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_23_2.id"],
"Filter": "(metrics_23_2.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
}
]
}
]
}
]
}
]
}
]
},
{
"Node Type": "Hash Join",
"Parent Relationship": "Member",
"Join Type": "Semi",
"Startup Cost": 26.03,
"Total Cost": 38.53,
"Plan Rows": 100,
"Plan Width": 38,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.001,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["metrics_01.ctid", "\"ANY_subquery_2\".*"],
"Hash Cond": "(metrics_01.id = \"ANY_subquery_2\".id)",
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Relation Name": "metrics_01",
"Schema": "public",
"Alias": "metrics_01",
"Startup Cost": 0.00,
"Total Cost": 11.10,
"Plan Rows": 110,
"Plan Width": 14,
"Actual Startup Time": 0.001,
"Actual Total Time": 0.001,
"Actual Rows": 0,
"Actual Loops": 1,
"Output": ["metrics_01.ctid", "metrics_01.id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Startup Cost": 24.78,
"Total Cost": 24.78,
"Plan Rows": 100,
"Plan Width": 40,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["\"ANY_subquery_2\".*", "\"ANY_subquery_2\".id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Subquery Scan",
"Parent Relationship": "Outer",
"Alias": "ANY_subquery_2",
"Startup Cost": 0.00,
"Total Cost": 24.78,
"Plan Rows": 100,
"Plan Width": 40,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["\"ANY_subquery_2\".*", "\"ANY_subquery_2\".id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Limit",
"Parent Relationship": "Subquery",
"Startup Cost": 0.00,
"Total Cost": 23.78,
"Plan Rows": 100,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_3.id"],
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Append",
"Parent Relationship": "Outer",
"Startup Cost": 0.00,
"Total Cost": 4410192.47,
"Plan Rows": 18544692,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics",
"Schema": "public",
"Alias": "metrics_3",
"Startup Cost": 0.00,
"Total Cost": 0.00,
"Plan Rows": 1,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_3.id"],
"Filter": "(metrics_3.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_00",
"Schema": "public",
"Alias": "metrics_00_3",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_00_3.id"],
"Filter": "(metrics_00_3.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_01",
"Schema": "public",
"Alias": "metrics_01_3",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_01_3.id"],
"Filter": "(metrics_01_3.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_02",
"Schema": "public",
"Alias": "metrics_02_3",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_02_3.id"],
"Filter": "(metrics_02_3.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_03",
"Schema": "public",
"Alias": "metrics_03_3",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_03_3.id"],
"Filter": "(metrics_03_3.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_04",
"Schema": "public",
"Alias": "metrics_04_3",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_04_3.id"],
"Filter": "(metrics_04_3.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},
{
"Node Type": "Seq Scan",
"Parent Relationship": "Member",
"Relation Name": "metrics_05",
"Schema": "public",
"Alias": "metrics_05_3",
"Startup Cost": 0.00,
"Total Cost": 11.38,
"Plan Rows": 37,
"Plan Width": 8,
"Actual Startup Time": 0.000,
"Actual Total Time": 0.000,
"Actual Rows": 0,
"Actual Loops": 0,
"Output": ["metrics_05_3.id"],
"Filter": "(metrics_05_3.\"timestamp\" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)",
"Rows Removed by Filter": 0,
"Shared Hit Blocks": 0,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0
},