Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [
- {
- "Plan": {
- "Node Type": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Finalize",
- "Parallel Aware": false,
- "Startup Cost": 114908152.31,
- "Total Cost": 114908152.32,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 42970.475,
- "Actual Total Time": 42970.475,
- "Actual Rows": 1,
- "Actual Loops": 1,
- "Output": ["count(*)"],
- "Shared Hit Blocks": 152217258,
- "Shared Read Blocks": 157466,
- "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": "Gather",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 114908151.89,
- "Total Cost": 114908152.30,
- "Plan Rows": 4,
- "Plan Width": 8,
- "Actual Startup Time": 42968.613,
- "Actual Total Time": 43036.496,
- "Actual Rows": 5,
- "Actual Loops": 1,
- "Output": ["(PARTIAL count(*))"],
- "Workers Planned": 4,
- "Workers Launched": 4,
- "Single Copy": false,
- "Shared Hit Blocks": 152217258,
- "Shared Read Blocks": 157466,
- "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": "Aggregate",
- "Strategy": "Plain",
- "Partial Mode": "Partial",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Startup Cost": 114907151.89,
- "Total Cost": 114907151.90,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 42893.080,
- "Actual Total Time": 42893.080,
- "Actual Rows": 1,
- "Actual Loops": 5,
- "Output": ["PARTIAL count(*)"],
- "Shared Hit Blocks": 152217258,
- "Shared Read Blocks": 157466,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 42873.957,
- "Actual Total Time": 42873.958,
- "Actual Rows": 1,
- "Actual Loops": 1,
- "Shared Hit Blocks": 30607149,
- "Shared Read Blocks": 28918,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 42884.927,
- "Actual Total Time": 42884.927,
- "Actual Rows": 1,
- "Actual Loops": 1,
- "Shared Hit Blocks": 30026745,
- "Shared Read Blocks": 35419,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 42870.255,
- "Actual Total Time": 42870.255,
- "Actual Rows": 1,
- "Actual Loops": 1,
- "Shared Hit Blocks": 30905107,
- "Shared Read Blocks": 20117,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 42869.991,
- "Actual Total Time": 42869.992,
- "Actual Rows": 1,
- "Actual Loops": 1,
- "Shared Hit Blocks": 30286968,
- "Shared Read Blocks": 30589,
- "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": "Nested Loop",
- "Parent Relationship": "Outer",
- "Parallel Aware": false,
- "Join Type": "Left",
- "Startup Cost": 0.00,
- "Total Cost": 5767449.71,
- "Plan Rows": 43655880870,
- "Plan Width": 0,
- "Actual Startup Time": 1.336,
- "Actual Total Time": 42636.183,
- "Actual Rows": 1221160,
- "Actual Loops": 5,
- "Inner Unique": false,
- "Shared Hit Blocks": 152217258,
- "Shared Read Blocks": 157466,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 1.350,
- "Actual Total Time": 42624.165,
- "Actual Rows": 1224548,
- "Actual Loops": 1,
- "Shared Hit Blocks": 30607149,
- "Shared Read Blocks": 28918,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 2.482,
- "Actual Total Time": 42621.063,
- "Actual Rows": 1216062,
- "Actual Loops": 1,
- "Shared Hit Blocks": 30026745,
- "Shared Read Blocks": 35419,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.986,
- "Actual Total Time": 42608.544,
- "Actual Rows": 1236266,
- "Actual Loops": 1,
- "Shared Hit Blocks": 30905107,
- "Shared Read Blocks": 20117,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 1.672,
- "Actual Total Time": 42611.285,
- "Actual Rows": 1211947,
- "Actual Loops": 1,
- "Shared Hit Blocks": 30286968,
- "Shared Read Blocks": 30589,
- "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",
- "Parallel Aware": true,
- "Startup Cost": 0.00,
- "Total Cost": 142900.07,
- "Plan Rows": 1526451,
- "Plan Width": 8,
- "Actual Startup Time": 0.271,
- "Actual Total Time": 1926.903,
- "Actual Rows": 1221160,
- "Actual Loops": 5,
- "Shared Hit Blocks": 15342,
- "Shared Read Blocks": 102082,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.468,
- "Actual Total Time": 1856.758,
- "Actual Rows": 1224548,
- "Actual Loops": 1,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 23549,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.226,
- "Actual Total Time": 1855.093,
- "Actual Rows": 1216062,
- "Actual Loops": 1,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 23386,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.045,
- "Actual Total Time": 1968.996,
- "Actual Rows": 1236266,
- "Actual Loops": 1,
- "Shared Hit Blocks": 13262,
- "Shared Read Blocks": 10513,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.598,
- "Actual Total Time": 2034.679,
- "Actual Rows": 1211947,
- "Actual Loops": 1,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 23307,
- "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",
- "Parallel Aware": true,
- "Relation Name": "event_record_2019_12",
- "Schema": "event_rec_pool",
- "Alias": "erc_4",
- "Startup Cost": 0.00,
- "Total Cost": 37041.38,
- "Plan Rows": 426138,
- "Plan Width": 8,
- "Actual Startup Time": 0.186,
- "Actual Total Time": 619.950,
- "Actual Rows": 340910,
- "Actual Loops": 5,
- "Output": ["erc_4.id"],
- "Filter": "((erc_4.deleted IS FALSE) AND (erc_4.active IS TRUE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 32780,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.226,
- "Actual Total Time": 125.280,
- "Actual Rows": 35672,
- "Actual Loops": 1,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 686,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.224,
- "Actual Total Time": 1702.761,
- "Actual Rows": 1216062,
- "Actual Loops": 1,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 23386,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.119,
- "Actual Total Time": 129.985,
- "Actual Rows": 35724,
- "Actual Loops": 1,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 687,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.158,
- "Actual Total Time": 1015.176,
- "Actual Rows": 381108,
- "Actual Loops": 1,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 7329,
- "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",
- "Parallel Aware": true,
- "Relation Name": "event_record_2020_01",
- "Schema": "event_rec_pool",
- "Alias": "erc_5",
- "Startup Cost": 0.00,
- "Total Cost": 32802.67,
- "Plan Rows": 377367,
- "Plan Width": 8,
- "Actual Startup Time": 0.213,
- "Actual Total Time": 863.676,
- "Actual Rows": 503156,
- "Actual Loops": 3,
- "Output": ["erc_5.id"],
- "Filter": "((erc_5.deleted IS FALSE) AND (erc_5.active IS TRUE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 29029,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.465,
- "Actual Total Time": 1584.796,
- "Actual Rows": 1188876,
- "Actual Loops": 1,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 22863,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.153,
- "Actual Total Time": 508.888,
- "Actual Rows": 159224,
- "Actual Loops": 1,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 3062,
- "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",
- "Parallel Aware": true,
- "Relation Name": "event_record_2020_02",
- "Schema": "event_rec_pool",
- "Alias": "erc_6",
- "Startup Cost": 0.00,
- "Total Cost": 18658.13,
- "Plan Rows": 268013,
- "Plan Width": 8,
- "Actual Startup Time": 0.594,
- "Actual Total Time": 855.303,
- "Actual Rows": 830839,
- "Actual Loops": 1,
- "Output": ["erc_6.id"],
- "Filter": "((erc_6.deleted IS FALSE) AND (erc_6.active IS TRUE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 15978,
- "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,
- "Workers": [
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.594,
- "Actual Total Time": 855.303,
- "Actual Rows": 830839,
- "Actual Loops": 1,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 15978,
- "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",
- "Parallel Aware": true,
- "Relation Name": "event_record_2020_03",
- "Schema": "event_rec_pool",
- "Alias": "erc_7",
- "Startup Cost": 0.00,
- "Total Cost": 16324.92,
- "Plan Rows": 234492,
- "Plan Width": 8,
- "Actual Startup Time": 0.042,
- "Actual Total Time": 539.108,
- "Actual Rows": 726926,
- "Actual Loops": 1,
- "Output": ["erc_7.id"],
- "Filter": "((erc_7.deleted IS FALSE) AND (erc_7.active IS TRUE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 13262,
- "Shared Read Blocks": 718,
- "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,
- "Workers": [
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.042,
- "Actual Total Time": 539.108,
- "Actual Rows": 726926,
- "Actual Loops": 1,
- "Shared Hit Blocks": 13262,
- "Shared Read Blocks": 718,
- "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",
- "Parallel Aware": true,
- "Relation Name": "event_record_2019_11",
- "Schema": "event_rec_pool",
- "Alias": "erc_3",
- "Startup Cost": 0.00,
- "Total Cost": 11934.27,
- "Plan Rows": 171427,
- "Plan Width": 8,
- "Actual Startup Time": 0.237,
- "Actual Total Time": 568.980,
- "Actual Rows": 265712,
- "Actual Loops": 2,
- "Output": ["erc_3.id"],
- "Filter": "((erc_3.deleted IS FALSE) AND (erc_3.active IS TRUE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 10220,
- "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,
- "Workers": [
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.461,
- "Actual Total Time": 634.032,
- "Actual Rows": 314392,
- "Actual Loops": 1,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 6046,
- "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",
- "Parallel Aware": true,
- "Relation Name": "event_record_2019_10",
- "Schema": "event_rec_pool",
- "Alias": "erc_2",
- "Startup Cost": 0.00,
- "Total Cost": 10984.80,
- "Plan Rows": 157780,
- "Plan Width": 8,
- "Actual Startup Time": 0.282,
- "Actual Total Time": 411.420,
- "Actual Rows": 489119,
- "Actual Loops": 1,
- "Output": ["erc_2.id"],
- "Filter": "((erc_2.deleted IS FALSE) AND (erc_2.active IS TRUE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 9407,
- "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",
- "Parallel Aware": true,
- "Relation Name": "event_record_2019_09",
- "Schema": "event_rec_pool",
- "Alias": "erc_1",
- "Startup Cost": 0.00,
- "Total Cost": 4805.65,
- "Plan Rows": 85565,
- "Plan Width": 8,
- "Actual Startup Time": 0.259,
- "Actual Total Time": 168.603,
- "Actual Rows": 205356,
- "Actual Loops": 1,
- "Output": ["erc_1.id"],
- "Filter": "((erc_1.deleted IS FALSE) AND (erc_1.active IS TRUE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 0,
- "Shared Read Blocks": 3950,
- "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",
- "Parallel Aware": true,
- "Relation Name": "event_record_2020_04",
- "Schema": "event_rec_pool",
- "Alias": "erc_8",
- "Startup Cost": 0.00,
- "Total Cost": 2715.99,
- "Plan Rows": 63599,
- "Plan Width": 8,
- "Actual Startup Time": 0.015,
- "Actual Total Time": 56.304,
- "Actual Rows": 108119,
- "Actual Loops": 1,
- "Output": ["erc_8.id"],
- "Filter": "((erc_8.deleted IS FALSE) AND (erc_8.active IS TRUE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 2080,
- "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",
- "Parallel Aware": true,
- "Relation Name": "event_record",
- "Schema": "public",
- "Alias": "erc",
- "Startup Cost": 0.00,
- "Total Cost": 0.00,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1,
- "Output": ["erc.id"],
- "Filter": "((erc.deleted IS FALSE) AND (erc.active IS TRUE))",
- "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": "Append",
- "Parent Relationship": "Inner",
- "Parallel Aware": false,
- "Startup Cost": 0.00,
- "Total Cost": 3.59,
- "Plan Rows": 9,
- "Plan Width": 8,
- "Actual Startup Time": 0.024,
- "Actual Total Time": 0.032,
- "Actual Rows": 1,
- "Actual Loops": 6105802,
- "Shared Hit Blocks": 152201916,
- "Shared Read Blocks": 55384,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.024,
- "Actual Total Time": 0.032,
- "Actual Rows": 1,
- "Actual Loops": 1224548,
- "Shared Hit Blocks": 30607149,
- "Shared Read Blocks": 5369,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.026,
- "Actual Total Time": 0.033,
- "Actual Rows": 1,
- "Actual Loops": 1216062,
- "Shared Hit Blocks": 30026745,
- "Shared Read Blocks": 12033,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.026,
- "Actual Total Time": 0.032,
- "Actual Rows": 1,
- "Actual Loops": 1236266,
- "Shared Hit Blocks": 30891845,
- "Shared Read Blocks": 9604,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.026,
- "Actual Total Time": 0.032,
- "Actual Rows": 1,
- "Actual Loops": 1211947,
- "Shared Hit Blocks": 30286968,
- "Shared Read Blocks": 7282,
- "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",
- "Parallel Aware": false,
- "Relation Name": "rlc_data",
- "Schema": "public",
- "Alias": "rld",
- "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": 6105802,
- "Output": ["rld.event_record_id"],
- "Filter": "((rld.active IS TRUE) AND (rld.deleted IS FALSE) AND (erc_4.id = rld.event_record_id))",
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 1224548,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 1216062,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 1236266,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.000,
- "Actual Total Time": 0.000,
- "Actual Rows": 0,
- "Actual Loops": 1211947,
- "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",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "rlc_data_2019_09_event_record_id_idx",
- "Relation Name": "rlc_data_2019_09",
- "Schema": "rlc_data_pool",
- "Alias": "rld_1",
- "Startup Cost": 0.42,
- "Total Cost": 0.44,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 6105802,
- "Output": ["rld_1.event_record_id"],
- "Index Cond": "(rld_1.event_record_id = erc_4.id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((rld_1.active IS TRUE) AND (rld_1.deleted IS FALSE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 18517076,
- "Shared Read Blocks": 3905,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1224548,
- "Shared Hit Blocks": 3673645,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1216062,
- "Shared Hit Blocks": 3648186,
- "Shared Read Blocks": 1,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1236266,
- "Shared Hit Blocks": 3708799,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1211947,
- "Shared Hit Blocks": 3635842,
- "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",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "rlc_data_2019_10_event_record_id_idx",
- "Relation Name": "rlc_data_2019_10",
- "Schema": "rlc_data_pool",
- "Alias": "rld_2",
- "Startup Cost": 0.42,
- "Total Cost": 0.44,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 6105802,
- "Output": ["rld_2.event_record_id"],
- "Index Cond": "(rld_2.event_record_id = erc_4.id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((rld_2.active IS TRUE) AND (rld_2.deleted IS FALSE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 18788246,
- "Shared Read Blocks": 9186,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1224548,
- "Shared Hit Blocks": 3673645,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1216062,
- "Shared Hit Blocks": 3648186,
- "Shared Read Blocks": 1,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1236266,
- "Shared Hit Blocks": 3708799,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1211947,
- "Shared Hit Blocks": 3635842,
- "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",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "rlc_data_2019_11_event_record_id_idx",
- "Relation Name": "rlc_data_2019_11",
- "Schema": "rlc_data_pool",
- "Alias": "rld_3",
- "Startup Cost": 0.42,
- "Total Cost": 0.44,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 6105802,
- "Output": ["rld_3.event_record_id"],
- "Index Cond": "(rld_3.event_record_id = erc_4.id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((rld_3.active IS TRUE) AND (rld_3.deleted IS FALSE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 18830304,
- "Shared Read Blocks": 10033,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1224548,
- "Shared Hit Blocks": 3673645,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1216062,
- "Shared Hit Blocks": 3648186,
- "Shared Read Blocks": 1,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 1236266,
- "Shared Hit Blocks": 4012165,
- "Shared Read Blocks": 5817,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1211947,
- "Shared Hit Blocks": 3635842,
- "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",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "rlc_data_2019_12_event_record_id_idx",
- "Relation Name": "rlc_data_2019_12",
- "Schema": "rlc_data_pool",
- "Alias": "rld_4",
- "Startup Cost": 0.43,
- "Total Cost": 0.45,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 6105802,
- "Output": ["rld_4.event_record_id"],
- "Index Cond": "(rld_4.event_record_id = erc_4.id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((rld_4.active IS TRUE) AND (rld_4.deleted IS FALSE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 19633439,
- "Shared Read Blocks": 21308,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1224548,
- "Shared Hit Blocks": 3708635,
- "Shared Read Blocks": 682,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.005,
- "Actual Total Time": 0.005,
- "Actual Rows": 1,
- "Actual Loops": 1216062,
- "Shared Hit Blocks": 4489443,
- "Shared Read Blocks": 12026,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1236266,
- "Shared Hit Blocks": 3743862,
- "Shared Read Blocks": 661,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 0,
- "Actual Loops": 1211947,
- "Shared Hit Blocks": 4005235,
- "Shared Read Blocks": 7282,
- "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",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "rlc_data_2020_01_event_record_id_idx",
- "Relation Name": "rlc_data_2020_01",
- "Schema": "rlc_data_pool",
- "Alias": "rld_5",
- "Startup Cost": 0.43,
- "Total Cost": 0.45,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 6105802,
- "Output": ["rld_5.event_record_id"],
- "Index Cond": "(rld_5.event_record_id = erc_4.id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((rld_5.active IS TRUE) AND (rld_5.deleted IS FALSE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 19814740,
- "Shared Read Blocks": 10949,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.004,
- "Actual Total Time": 0.004,
- "Actual Rows": 1,
- "Actual Loops": 1224548,
- "Shared Hit Blocks": 4856644,
- "Shared Read Blocks": 4687,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1216062,
- "Shared Hit Blocks": 3648186,
- "Shared Read Blocks": 1,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 0,
- "Actual Loops": 1236266,
- "Shared Hit Blocks": 3864897,
- "Shared Read Blocks": 3126,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1211947,
- "Shared Hit Blocks": 3635842,
- "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",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "rlc_data_2020_02_event_record_id_idx",
- "Relation Name": "rlc_data_2020_02",
- "Schema": "rlc_data_pool",
- "Alias": "rld_6",
- "Startup Cost": 0.42,
- "Total Cost": 0.45,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 6105802,
- "Output": ["rld_6.event_record_id"],
- "Index Cond": "(rld_6.event_record_id = erc_4.id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((rld_6.active IS TRUE) AND (rld_6.deleted IS FALSE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 19148248,
- "Shared Read Blocks": 1,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1224548,
- "Shared Hit Blocks": 3673645,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1216062,
- "Shared Hit Blocks": 3648186,
- "Shared Read Blocks": 1,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1236266,
- "Shared Hit Blocks": 3708799,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 1211947,
- "Shared Hit Blocks": 4466681,
- "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",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "rlc_data_2020_03_event_record_id_idx",
- "Relation Name": "rlc_data_2020_03",
- "Schema": "rlc_data_pool",
- "Alias": "rld_7",
- "Startup Cost": 0.42,
- "Total Cost": 0.45,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 6105802,
- "Output": ["rld_7.event_record_id"],
- "Index Cond": "(rld_7.event_record_id = erc_4.id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((rld_7.active IS TRUE) AND (rld_7.deleted IS FALSE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 19044335,
- "Shared Read Blocks": 1,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1224548,
- "Shared Hit Blocks": 3673645,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1216062,
- "Shared Hit Blocks": 3648186,
- "Shared Read Blocks": 1,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.003,
- "Actual Total Time": 0.003,
- "Actual Rows": 1,
- "Actual Loops": 1236266,
- "Shared Hit Blocks": 4435725,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1211947,
- "Shared Hit Blocks": 3635842,
- "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",
- "Parallel Aware": false,
- "Scan Direction": "Forward",
- "Index Name": "rlc_data_2020_04_event_record_id_idx",
- "Relation Name": "rlc_data_2020_04",
- "Schema": "rlc_data_pool",
- "Alias": "rld_8",
- "Startup Cost": 0.42,
- "Total Cost": 0.44,
- "Plan Rows": 1,
- "Plan Width": 8,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 6105802,
- "Output": ["rld_8.event_record_id"],
- "Index Cond": "(rld_8.event_record_id = erc_4.id)",
- "Rows Removed by Index Recheck": 0,
- "Filter": "((rld_8.active IS TRUE) AND (rld_8.deleted IS FALSE))",
- "Rows Removed by Filter": 0,
- "Shared Hit Blocks": 18425528,
- "Shared Read Blocks": 1,
- "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,
- "Workers": [
- {
- "Worker Number": 0,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1224548,
- "Shared Hit Blocks": 3673645,
- "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
- },
- {
- "Worker Number": 1,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1216062,
- "Shared Hit Blocks": 3648186,
- "Shared Read Blocks": 1,
- "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
- },
- {
- "Worker Number": 2,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1236266,
- "Shared Hit Blocks": 3708799,
- "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
- },
- {
- "Worker Number": 3,
- "Actual Startup Time": 0.002,
- "Actual Total Time": 0.002,
- "Actual Rows": 0,
- "Actual Loops": 1211947,
- "Shared Hit Blocks": 3635842,
- "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
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- }
- ]
- },
- "Planning Time": 2.438,
- "Triggers": [
- ],
- "Execution Time": 43036.810
- }
- ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement