[{"Plan": {"Plans": [{"Plans": [{"Plans": [{"Plans": [{"Alias": "customer", "Filter": "((customer.c_region)::text = 'AMERICA'::text)", "Output": ["customer.c_custkey", "customer.c_name", "customer.c_address", "customer.c_city", "customer.c_nation", "customer.c_region", "customer.c_phone", "customer.c_mktsegment"], "Schema": "public", "Workers": [{"Actual Rows": 81640, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 55.93, "Local Read Blocks": 0, "Shared Hit Blocks": 6224, "Shared Read Blocks": 0, "Actual Startup Time": 0.009, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 77562, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 56.428, "Local Read Blocks": 0, "Shared Hit Blocks": 5923, "Shared Read Blocks": 0, "Actual Startup Time": 0.01, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 75113, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 56.461, "Local Read Blocks": 0, "Shared Hit Blocks": 5712, "Shared Read Blocks": 0, "Actual Startup Time": 0.011, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 76325, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 56.483, "Local Read Blocks": 0, "Shared Hit Blocks": 5821, "Shared Read Blocks": 0, "Actual Startup Time": 0.01, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Node Type": "Seq Scan", "Plan Rows": 106524, "Plan Width": 4, "Total Cost": 38522.59, "Actual Rows": 83930, "Actual Loops": 5, "Startup Cost": 0.0, "Async Capable": false, "Relation Name": "customer", "Parallel Aware": true, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 55.457, "Local Read Blocks": 0, "Shared Hit Blocks": 31960, "Shared Read Blocks": 0, "Actual Startup Time": 0.009, "Parent Relationship": "Outer", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Rows Removed by Filter": 336070}, {"Plans": [{"Plans": [{"Plans": [{"Plans": [{"Alias": "lineorder", "Output": ["lineorder.lo_orderkey", "lineorder.lo_linenumber", "lineorder.lo_custkey", "lineorder.lo_partkey", "lineorder.lo_suppkey", "lineorder.lo_orderdate", "lineorder.lo_orderpriority", "lineorder.lo_shippriority", "lineorder.lo_quantity", "lineorder.lo_extendedprice", "lineorder.lo_ordertotalprice", "lineorder.lo_discount", "lineorder.lo_revenue", "lineorder.lo_supplycost", "lineorder.lo_tax", "lineorder.lo_commitdate", "lineorder.lo_shipmode"], "Schema": "public", "Workers": [{"Actual Rows": 77192760, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 5763.306, "Local Read Blocks": 0, "Shared Hit Blocks": 998118, "Shared Read Blocks": 0, "Actual Startup Time": 0.01, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 80401349, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 5680.338, "Local Read Blocks": 0, "Shared Hit Blocks": 1039582, "Shared Read Blocks": 0, "Actual Startup Time": 0.009, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 81627402, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 5687.63, "Local Read Blocks": 0, "Shared Hit Blocks": 1055451, "Shared Read Blocks": 0, "Actual Startup Time": 0.013, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 79055250, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 5720.045, "Local Read Blocks": 0, "Shared Hit Blocks": 1022197, "Shared Read Blocks": 0, "Actual Startup Time": 0.021, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Node Type": "Seq Scan", "Plan Rows": 59999584, "Plan Width": 24, "Total Cost": 6030842.84, "Actual Rows": 84003496, "Actual Loops": 5, "Startup Cost": 0.0, "Async Capable": false, "Relation Name": "lineorder", "Parallel Aware": true, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 5560.357, "Local Read Blocks": 0, "Shared Hit Blocks": 5430847, "Shared Read Blocks": 0, "Actual Startup Time": 0.011, "Parent Relationship": "Outer", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Plans": [{"Alias": "part", "Filter": "((part.p_category)::text = 'MFGR#14'::text)", "Output": ["part.p_brand1", "part.p_partkey"], "Schema": "public", "Workers": [{"Actual Rows": 9275, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 36.202, "Local Read Blocks": 0, "Shared Hit Blocks": 3307, "Shared Read Blocks": 0, "Actual Startup Time": 0.013, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 11102, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 37.944, "Local Read Blocks": 0, "Shared Hit Blocks": 4009, "Shared Read Blocks": 0, "Actual Startup Time": 0.009, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 9517, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 37.121, "Local Read Blocks": 0, "Shared Hit Blocks": 3413, "Shared Read Blocks": 0, "Actual Startup Time": 0.014, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 10023, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 37.732, "Local Read Blocks": 0, "Shared Hit Blocks": 3559, "Shared Read Blocks": 0, "Actual Startup Time": 0.024, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Node Type": "Seq Scan", "Plan Rows": 17176, "Plan Width": 13, "Total Cost": 25697.16, "Actual Rows": 11171, "Actual Loops": 5, "Startup Cost": 0.0, "Async Capable": false, "Relation Name": "part", "Parallel Aware": true, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 36.945, "Local Read Blocks": 0, "Shared Hit Blocks": 20052, "Shared Read Blocks": 0, "Actual Startup Time": 0.014, "Parent Relationship": "Outer", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Rows Removed by Filter": 268829}], "Output": ["part.p_brand1", "part.p_partkey"], "Workers": [{"Actual Rows": 9275, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 40.035, "Local Read Blocks": 0, "Shared Hit Blocks": 3307, "Shared Read Blocks": 0, "Actual Startup Time": 40.035, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 11102, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 40.045, "Local Read Blocks": 0, "Shared Hit Blocks": 4009, "Shared Read Blocks": 0, "Actual Startup Time": 40.045, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 9517, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 40.041, "Local Read Blocks": 0, "Shared Hit Blocks": 3413, "Shared Read Blocks": 0, "Actual Startup Time": 40.04, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 10023, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 40.042, "Local Read Blocks": 0, "Shared Hit Blocks": 3559, "Shared Read Blocks": 0, "Actual Startup Time": 40.041, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Node Type": "Hash", "Plan Rows": 17176, "Plan Width": 13, "Total Cost": 25697.16, "Actual Rows": 11171, "Actual Loops": 5, "Hash Batches": 1, "Hash Buckets": 65536, "Startup Cost": 25697.16, "Async Capable": false, "Parallel Aware": true, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 40.006, "Local Read Blocks": 0, "Peak Memory Usage": 3200, "Shared Hit Blocks": 20052, "Shared Read Blocks": 0, "Actual Startup Time": 40.005, "Parent Relationship": "Inner", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Original Hash Batches": 1, "Original Hash Buckets": 65536, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Output": ["part.p_brand1", "lineorder.lo_revenue", "lineorder.lo_supplycost", "lineorder.lo_custkey", "lineorder.lo_suppkey", "lineorder.lo_orderdate"], "Workers": [{"Actual Rows": 3086525, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 16932.771, "Local Read Blocks": 0, "Shared Hit Blocks": 1001425, "Shared Read Blocks": 0, "Actual Startup Time": 40.117, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 3214367, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 16935.452, "Local Read Blocks": 0, "Shared Hit Blocks": 1043591, "Shared Read Blocks": 0, "Actual Startup Time": 40.111, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 3262380, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 16947.73, "Local Read Blocks": 0, "Shared Hit Blocks": 1058864, "Shared Read Blocks": 0, "Actual Startup Time": 40.189, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 3156436, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 16940.303, "Local Read Blocks": 0, "Shared Hit Blocks": 1025756, "Shared Read Blocks": 0, "Actual Startup Time": 40.111, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Hash Cond": "(lineorder.lo_partkey = part.p_partkey)", "Join Type": "Inner", "Node Type": "Hash Join", "Plan Rows": 2281998, "Plan Width": 29, "Total Cost": 6289114.23, "Actual Rows": 3358313, "Actual Loops": 5, "Inner Unique": false, "Startup Cost": 25911.86, "Async Capable": false, "Parallel Aware": true, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 16917.421, "Local Read Blocks": 0, "Shared Hit Blocks": 5450899, "Shared Read Blocks": 0, "Actual Startup Time": 40.126, "Parent Relationship": "Outer", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Plans": [{"Alias": "supplier", "Filter": "((supplier.s_nation)::text = 'UNITED STATES'::text)", "Output": ["supplier.s_city", "supplier.s_suppkey"], "Schema": "public", "Workers": [{"Actual Rows": 4384, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 19.177, "Local Read Blocks": 0, "Shared Hit Blocks": 1555, "Shared Read Blocks": 0, "Actual Startup Time": 0.022, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 5279, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 20.208, "Local Read Blocks": 0, "Shared Hit Blocks": 1851, "Shared Read Blocks": 0, "Actual Startup Time": 0.024, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 2636, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17.397, "Local Read Blocks": 0, "Shared Hit Blocks": 889, "Shared Read Blocks": 0, "Actual Startup Time": 0.049, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 4487, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 19.139, "Local Read Blocks": 0, "Shared Hit Blocks": 1557, "Shared Read Blocks": 0, "Actual Startup Time": 0.022, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Node Type": "Seq Scan", "Plan Rows": 9243, "Plan Width": 15, "Total Cost": 12596.58, "Actual Rows": 5595, "Actual Loops": 5, "Startup Cost": 0.0, "Async Capable": false, "Relation Name": "supplier", "Parallel Aware": true, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 19.316, "Local Read Blocks": 0, "Shared Hit Blocks": 9774, "Shared Read Blocks": 0, "Actual Startup Time": 0.024, "Parent Relationship": "Outer", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Rows Removed by Filter": 134405}], "Output": ["supplier.s_city", "supplier.s_suppkey"], "Workers": [{"Actual Rows": 4384, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 20.764, "Local Read Blocks": 0, "Shared Hit Blocks": 1555, "Shared Read Blocks": 0, "Actual Startup Time": 20.763, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 5279, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 21.173, "Local Read Blocks": 0, "Shared Hit Blocks": 1851, "Shared Read Blocks": 0, "Actual Startup Time": 21.173, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 2636, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 18.237, "Local Read Blocks": 0, "Shared Hit Blocks": 889, "Shared Read Blocks": 0, "Actual Startup Time": 18.237, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 4487, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 21.132, "Local Read Blocks": 0, "Shared Hit Blocks": 1557, "Shared Read Blocks": 0, "Actual Startup Time": 21.132, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Node Type": "Hash", "Plan Rows": 9243, "Plan Width": 15, "Total Cost": 12596.58, "Actual Rows": 5595, "Actual Loops": 5, "Hash Batches": 1, "Hash Buckets": 32768, "Startup Cost": 12596.58, "Async Capable": false, "Parallel Aware": true, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 20.878, "Local Read Blocks": 0, "Peak Memory Usage": 1632, "Shared Hit Blocks": 9774, "Shared Read Blocks": 0, "Actual Startup Time": 20.878, "Parent Relationship": "Inner", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Original Hash Batches": 1, "Original Hash Buckets": 32768, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Output": ["supplier.s_city", "lineorder.lo_revenue", "lineorder.lo_supplycost", "lineorder.lo_custkey", "lineorder.lo_orderdate", "part.p_brand1"], "Workers": [{"Actual Rows": 123393, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17541.382, "Local Read Blocks": 0, "Shared Hit Blocks": 1002980, "Shared Read Blocks": 0, "Actual Startup Time": 61.041, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 128439, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17546.399, "Local Read Blocks": 0, "Shared Hit Blocks": 1045442, "Shared Read Blocks": 0, "Actual Startup Time": 61.534, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 130284, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17546.584, "Local Read Blocks": 0, "Shared Hit Blocks": 1059753, "Shared Read Blocks": 0, "Actual Startup Time": 58.649, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 126015, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17546.481, "Local Read Blocks": 0, "Shared Hit Blocks": 1027313, "Shared Read Blocks": 0, "Actual Startup Time": 61.55, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Hash Cond": "(lineorder.lo_suppkey = supplier.s_suppkey)", "Join Type": "Inner", "Node Type": "Hash Join", "Plan Rows": 93409, "Plan Width": 36, "Total Cost": 6310685.16, "Actual Rows": 134152, "Actual Loops": 5, "Inner Unique": false, "Startup Cost": 38623.98, "Async Capable": false, "Parallel Aware": true, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17546.252, "Local Read Blocks": 0, "Shared Hit Blocks": 5460673, "Shared Read Blocks": 0, "Actual Startup Time": 61.257, "Parent Relationship": "Outer", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Plans": [{"Alias": "date", "Filter": "((date.d_year = 1997) OR (date.d_year = 1998))", "Output": ["date.d_year", "date.d_datekey"], "Schema": "public", "Workers": [{"Actual Rows": 729, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 0.514, "Local Read Blocks": 0, "Shared Hit Blocks": 38, "Shared Read Blocks": 0, "Actual Startup Time": 0.345, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 729, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 0.512, "Local Read Blocks": 0, "Shared Hit Blocks": 38, "Shared Read Blocks": 0, "Actual Startup Time": 0.346, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 729, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 1.061, "Local Read Blocks": 0, "Shared Hit Blocks": 38, "Shared Read Blocks": 0, "Actual Startup Time": 0.714, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 729, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 0.575, "Local Read Blocks": 0, "Shared Hit Blocks": 38, "Shared Read Blocks": 0, "Actual Startup Time": 0.388, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Node Type": "Seq Scan", "Plan Rows": 677, "Plan Width": 8, "Total Cost": 76.34, "Actual Rows": 729, "Actual Loops": 5, "Startup Cost": 0.0, "Async Capable": false, "Relation Name": "date", "Parallel Aware": false, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 0.578, "Local Read Blocks": 0, "Shared Hit Blocks": 190, "Shared Read Blocks": 0, "Actual Startup Time": 0.387, "Parent Relationship": "Outer", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Rows Removed by Filter": 1827}], "Output": ["date.d_year", "date.d_datekey"], "Workers": [{"Actual Rows": 729, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 0.599, "Local Read Blocks": 0, "Shared Hit Blocks": 38, "Shared Read Blocks": 0, "Actual Startup Time": 0.599, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 729, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 0.59, "Local Read Blocks": 0, "Shared Hit Blocks": 38, "Shared Read Blocks": 0, "Actual Startup Time": 0.589, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 729, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 1.23, "Local Read Blocks": 0, "Shared Hit Blocks": 38, "Shared Read Blocks": 0, "Actual Startup Time": 1.23, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 729, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 0.661, "Local Read Blocks": 0, "Shared Hit Blocks": 38, "Shared Read Blocks": 0, "Actual Startup Time": 0.661, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Node Type": "Hash", "Plan Rows": 677, "Plan Width": 8, "Total Cost": 76.34, "Actual Rows": 729, "Actual Loops": 5, "Hash Batches": 1, "Hash Buckets": 1024, "Startup Cost": 76.34, "Async Capable": false, "Parallel Aware": false, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 0.673, "Local Read Blocks": 0, "Peak Memory Usage": 37, "Shared Hit Blocks": 190, "Shared Read Blocks": 0, "Actual Startup Time": 0.673, "Parent Relationship": "Inner", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Original Hash Batches": 1, "Original Hash Buckets": 1024, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Output": ["date.d_year", "lineorder.lo_revenue", "lineorder.lo_supplycost", "lineorder.lo_custkey", "supplier.s_city", "part.p_brand1"], "Workers": [{"Actual Rows": 29627, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17574.234, "Local Read Blocks": 0, "Shared Hit Blocks": 1003018, "Shared Read Blocks": 0, "Actual Startup Time": 62.451, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 30930, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17578.552, "Local Read Blocks": 0, "Shared Hit Blocks": 1045480, "Shared Read Blocks": 0, "Actual Startup Time": 62.137, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 31341, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17575.675, "Local Read Blocks": 0, "Shared Hit Blocks": 1059791, "Shared Read Blocks": 0, "Actual Startup Time": 60.352, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 30248, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17578.76, "Local Read Blocks": 0, "Shared Hit Blocks": 1027351, "Shared Read Blocks": 0, "Actual Startup Time": 62.226, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Hash Cond": "(lineorder.lo_orderdate = date.d_datekey)", "Join Type": "Inner", "Node Type": "Hash Join", "Plan Rows": 24741, "Plan Width": 36, "Total Cost": 6311367.66, "Actual Rows": 32318, "Actual Loops": 5, "Inner Unique": false, "Startup Cost": 38708.78, "Async Capable": false, "Parallel Aware": false, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17577.233, "Local Read Blocks": 0, "Shared Hit Blocks": 5460863, "Shared Read Blocks": 0, "Actual Startup Time": 62.284, "Parent Relationship": "Outer", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Output": ["date.d_year", "lineorder.lo_revenue", "lineorder.lo_supplycost", "lineorder.lo_custkey", "supplier.s_city", "part.p_brand1"], "Workers": [{"Actual Rows": 29627, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17593.604, "Local Read Blocks": 0, "Shared Hit Blocks": 1003018, "Shared Read Blocks": 0, "Actual Startup Time": 17593.6, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 30930, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17593.986, "Local Read Blocks": 0, "Shared Hit Blocks": 1045480, "Shared Read Blocks": 0, "Actual Startup Time": 17593.981, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 31341, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17591.745, "Local Read Blocks": 0, "Shared Hit Blocks": 1059791, "Shared Read Blocks": 0, "Actual Startup Time": 17591.741, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 30248, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17594.028, "Local Read Blocks": 0, "Shared Hit Blocks": 1027351, "Shared Read Blocks": 0, "Actual Startup Time": 17594.024, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Node Type": "Hash", "Plan Rows": 24741, "Plan Width": 36, "Total Cost": 6311367.66, "Actual Rows": 32318, "Actual Loops": 5, "Hash Batches": 1, "Hash Buckets": 262144, "Startup Cost": 6311367.66, "Async Capable": false, "Parallel Aware": true, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17593.905, "Local Read Blocks": 0, "Peak Memory Usage": 13536, "Shared Hit Blocks": 5460863, "Shared Read Blocks": 0, "Actual Startup Time": 17593.805, "Parent Relationship": "Inner", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Original Hash Batches": 1, "Original Hash Buckets": 262144, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Output": ["date.d_year", "supplier.s_city", "part.p_brand1", "lineorder.lo_revenue", "lineorder.lo_supplycost"], "Workers": [{"Actual Rows": 6342, "Actual Loops": 1, "Worker Number": 0, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17663.952, "Local Read Blocks": 0, "Shared Hit Blocks": 1009290, "Shared Read Blocks": 0, "Actual Startup Time": 17593.794, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 5828, "Actual Loops": 1, "Worker Number": 1, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17664.526, "Local Read Blocks": 0, "Shared Hit Blocks": 1051451, "Shared Read Blocks": 0, "Actual Startup Time": 17594.168, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 5684, "Actual Loops": 1, "Worker Number": 2, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17662.148, "Local Read Blocks": 0, "Shared Hit Blocks": 1065551, "Shared Read Blocks": 0, "Actual Startup Time": 17592.126, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 5668, "Actual Loops": 1, "Worker Number": 3, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17664.405, "Local Read Blocks": 0, "Shared Hit Blocks": 1033220, "Shared Read Blocks": 0, "Actual Startup Time": 17594.278, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Hash Cond": "(customer.c_custkey = lineorder.lo_custkey)", "Join Type": "Inner", "Node Type": "Hash Join", "Plan Rows": 8785, "Plan Width": 32, "Total Cost": 6350611.52, "Actual Rows": 6380, "Actual Loops": 5, "Inner Unique": false, "Startup Cost": 6311676.92, "Async Capable": false, "Parallel Aware": true, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17664.733, "Local Read Blocks": 0, "Shared Hit Blocks": 5493015, "Shared Read Blocks": 0, "Actual Startup Time": 17594.406, "Parent Relationship": "Outer", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Output": ["date.d_year", "supplier.s_city", "part.p_brand1", "lineorder.lo_revenue", "lineorder.lo_supplycost"], "Workers": [{"Actual Rows": 6342, "Sort Method": "quicksort", "Actual Loops": 1, "Worker Number": 0, "Sort Space Type": "Memory", "Sort Space Used": 528, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17668.369, "Local Read Blocks": 0, "Shared Hit Blocks": 1009354, "Shared Read Blocks": 0, "Actual Startup Time": 17667.851, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 5828, "Sort Method": "quicksort", "Actual Loops": 1, "Worker Number": 1, "Sort Space Type": "Memory", "Sort Space Used": 501, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17668.992, "Local Read Blocks": 0, "Shared Hit Blocks": 1051515, "Shared Read Blocks": 0, "Actual Startup Time": 17668.487, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 5684, "Sort Method": "quicksort", "Actual Loops": 1, "Worker Number": 2, "Sort Space Type": "Memory", "Sort Space Used": 493, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17666.485, "Local Read Blocks": 0, "Shared Hit Blocks": 1065615, "Shared Read Blocks": 0, "Actual Startup Time": 17666.206, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, {"Actual Rows": 5668, "Sort Method": "quicksort", "Actual Loops": 1, "Worker Number": 3, "Sort Space Type": "Memory", "Sort Space Used": 492, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17668.846, "Local Read Blocks": 0, "Shared Hit Blocks": 1033284, "Shared Read Blocks": 0, "Actual Startup Time": 17668.307, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Sort Key": ["date.d_year", "supplier.s_city", "part.p_brand1"], "Node Type": "Sort", "Plan Rows": 8785, "Plan Width": 32, "Total Cost": 6351208.94, "Actual Rows": 6380, "Sort Method": "quicksort", "Actual Loops": 5, "Startup Cost": 6351186.98, "Async Capable": false, "Parallel Aware": false, "Sort Space Type": "Memory", "Sort Space Used": 828, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17669.171, "Local Read Blocks": 0, "Shared Hit Blocks": 5493271, "Shared Read Blocks": 0, "Actual Startup Time": 17668.646, "Parent Relationship": "Outer", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Output": ["date.d_year", "supplier.s_city", "part.p_brand1", "lineorder.lo_revenue", "lineorder.lo_supplycost"], "Node Type": "Gather Merge", "Plan Rows": 35140, "Plan Width": 32, "Total Cost": 6356394.51, "Actual Rows": 31898, "Actual Loops": 1, "Startup Cost": 6352187.04, "Async Capable": false, "Parallel Aware": false, "Workers Planned": 4, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Workers Launched": 4, "Actual Total Time": 17897.093, "Local Read Blocks": 0, "Shared Hit Blocks": 5493271, "Shared Read Blocks": 0, "Actual Startup Time": 17672.728, "Parent Relationship": "Outer", "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}], "Output": ["date.d_year", "supplier.s_city", "part.p_brand1", "sum((lineorder.lo_revenue - lineorder.lo_supplycost))"], "Strategy": "Sorted", "Group Key": ["date.d_year", "supplier.s_city", "part.p_brand1"], "Node Type": "Aggregate", "Plan Rows": 35140, "Plan Width": 32, "Total Cost": 6357185.16, "Actual Rows": 800, "Actual Loops": 1, "Partial Mode": "Simple", "Startup Cost": 6352187.04, "Async Capable": false, "Parallel Aware": false, "Local Hit Blocks": 0, "Temp Read Blocks": 0, "Actual Total Time": 17901.472, "Local Read Blocks": 0, "Shared Hit Blocks": 5493271, "Shared Read Blocks": 0, "Actual Startup Time": 17672.751, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, "Planning": {"Local Hit Blocks": 0, "Temp Read Blocks": 0, "Local Read Blocks": 0, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Temp Written Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0}, "Triggers": [], "Planning Time": 0.233, "Execution Time": 17901.532}]