[ { "Plan": { "Node Type": "Aggregate", "Strategy": "Plain", "Partial Mode": "Simple", "Parallel Aware": false, "Startup Cost": 9229411.49, "Total Cost": 9229411.5, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 92004.539, "Actual Total Time": 92004.539, "Actual Rows": 1, "Actual Loops": 1, "Output": [ "count(locInfo_.id)" ], "Shared Hit Blocks": 6693585, "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": 934, "Temp Written Blocks": 350015, "I/O Read Time": 0, "I/O Write Time": 0, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 8516507.06, "Total Cost": 9229212.1, "Plan Rows": 79755, "Plan Width": 8, "Actual Startup Time": 91611.601, "Actual Total Time": 92003.494, "Actual Rows": 14730, "Actual Loops": 1, "Output": [ "locInfo_.id" ], "Hash Cond": "(locInfo_.asset_info_id = assetInfo1_.id)", "Shared Hit Blocks": 6693585, "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": 934, "Temp Written Blocks": 350015, "I/O Read Time": 0, "I/O Write Time": 0, "Plans": [ { "Node Type": "Append", "Parent Relationship": "Outer", "Parallel Aware": false, "Startup Cost": 0, "Total Cost": 307357.03, "Plan Rows": 79755, "Plan Width": 16, "Actual Startup Time": 0.143, "Actual Total Time": 8.089, "Actual Rows": 14730, "Actual Loops": 1, "Shared Hit Blocks": 968, "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, "I/O Read Time": 0, "I/O Write Time": 0, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "location_info", "Schema": "public", "Alias": "locInfo_", "Startup Cost": 0, "Total Cost": 0, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo_.id", "locInfo_.asset_info_id" ], "Filter": "((locInfo_.event_ts >= '1541376000000'::bigint) AND (locInfo_.event_ts <= '1549843199999'::bigint) AND (locInfo_.org_id = 761024) AND (locInfo_.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])))", "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "event_ts_10_part4", "Relation Name": "location_info_2018_10_part4", "Schema": "public", "Alias": "locInfo__1", "Startup Cost": 0.57, "Total Cost": 8.6, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.005, "Actual Total Time": 0.005, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__1.id", "locInfo__1.asset_info_id" ], "Index Cond": "((locInfo__1.event_ts >= '1541376000000'::bigint) AND (locInfo__1.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Filter": "((locInfo__1.org_id = 761024) AND (locInfo__1.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 4, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "event_ts_10_part5", "Relation Name": "location_info_2018_10_part5", "Schema": "public", "Alias": "locInfo__2", "Startup Cost": 0.57, "Total Cost": 8.6, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__2.id", "locInfo__2.asset_info_id" ], "Index Cond": "((locInfo__2.event_ts >= '1541376000000'::bigint) AND (locInfo__2.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Filter": "((locInfo__2.org_id = 761024) AND (locInfo__2.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 4, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_11_part1", "Relation Name": "location_info_2018_11_part1", "Schema": "public", "Alias": "locInfo__3", "Startup Cost": 0.57, "Total Cost": 4836.92, "Plan Rows": 1205, "Plan Width": 16, "Actual Startup Time": 0.03, "Actual Total Time": 0.03, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__3.id", "locInfo__3.asset_info_id" ], "Index Cond": "((locInfo__3.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__3.org_id = 761024) AND (locInfo__3.event_ts >= '1541376000000'::bigint) AND (locInfo__3.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_11_part2", "Relation Name": "location_info_2018_11_part2", "Schema": "public", "Alias": "locInfo__4", "Startup Cost": 0.57, "Total Cost": 13126.18, "Plan Rows": 3264, "Plan Width": 16, "Actual Startup Time": 0.03, "Actual Total Time": 0.03, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__4.id", "locInfo__4.asset_info_id" ], "Index Cond": "((locInfo__4.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__4.org_id = 761024) AND (locInfo__4.event_ts >= '1541376000000'::bigint) AND (locInfo__4.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_11_part3", "Relation Name": "location_info_2018_11_part3", "Schema": "public", "Alias": "locInfo__5", "Startup Cost": 0.57, "Total Cost": 13069.49, "Plan Rows": 3248, "Plan Width": 16, "Actual Startup Time": 0.03, "Actual Total Time": 0.03, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__5.id", "locInfo__5.asset_info_id" ], "Index Cond": "((locInfo__5.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__5.org_id = 761024) AND (locInfo__5.event_ts >= '1541376000000'::bigint) AND (locInfo__5.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_11_part4", "Relation Name": "location_info_2018_11_part4", "Schema": "public", "Alias": "locInfo__6", "Startup Cost": 0.57, "Total Cost": 13078.59, "Plan Rows": 3260, "Plan Width": 16, "Actual Startup Time": 0.028, "Actual Total Time": 0.028, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__6.id", "locInfo__6.asset_info_id" ], "Index Cond": "((locInfo__6.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__6.org_id = 761024) AND (locInfo__6.event_ts >= '1541376000000'::bigint) AND (locInfo__6.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_11_part5", "Relation Name": "location_info_2018_11_part5", "Schema": "public", "Alias": "locInfo__7", "Startup Cost": 0.57, "Total Cost": 13432.02, "Plan Rows": 3341, "Plan Width": 16, "Actual Startup Time": 0.015, "Actual Total Time": 1.754, "Actual Rows": 4116, "Actual Loops": 1, "Output": [ "locInfo__7.id", "locInfo__7.asset_info_id" ], "Index Cond": "((locInfo__7.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__7.org_id = 761024) AND (locInfo__7.event_ts >= '1541376000000'::bigint) AND (locInfo__7.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 189, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_12_part1", "Relation Name": "location_info_2018_12_part1", "Schema": "public", "Alias": "locInfo__8", "Startup Cost": 0.57, "Total Cost": 17289.23, "Plan Rows": 4342, "Plan Width": 16, "Actual Startup Time": 0.035, "Actual Total Time": 0.035, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__8.id", "locInfo__8.asset_info_id" ], "Index Cond": "((locInfo__8.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__8.org_id = 761024) AND (locInfo__8.event_ts >= '1541376000000'::bigint) AND (locInfo__8.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_12_part2", "Relation Name": "location_info_2018_12_part2", "Schema": "public", "Alias": "locInfo__9", "Startup Cost": 0.57, "Total Cost": 16987.53, "Plan Rows": 4280, "Plan Width": 16, "Actual Startup Time": 0.034, "Actual Total Time": 0.034, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__9.id", "locInfo__9.asset_info_id" ], "Index Cond": "((locInfo__9.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__9.org_id = 761024) AND (locInfo__9.event_ts >= '1541376000000'::bigint) AND (locInfo__9.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_12_part3", "Relation Name": "location_info_2018_12_part3", "Schema": "public", "Alias": "locInfo__10", "Startup Cost": 0.57, "Total Cost": 15447.67, "Plan Rows": 3899, "Plan Width": 16, "Actual Startup Time": 0.033, "Actual Total Time": 0.033, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__10.id", "locInfo__10.asset_info_id" ], "Index Cond": "((locInfo__10.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__10.org_id = 761024) AND (locInfo__10.event_ts >= '1541376000000'::bigint) AND (locInfo__10.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_12_part4", "Relation Name": "location_info_2018_12_part4", "Schema": "public", "Alias": "locInfo__11", "Startup Cost": 0.57, "Total Cost": 15589.75, "Plan Rows": 3992, "Plan Width": 16, "Actual Startup Time": 0.035, "Actual Total Time": 0.035, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__11.id", "locInfo__11.asset_info_id" ], "Index Cond": "((locInfo__11.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__11.org_id = 761024) AND (locInfo__11.event_ts >= '1541376000000'::bigint) AND (locInfo__11.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_12_part5", "Relation Name": "location_info_2018_12_part5", "Schema": "public", "Alias": "locInfo__12", "Startup Cost": 0.57, "Total Cost": 23584.88, "Plan Rows": 6286, "Plan Width": 16, "Actual Startup Time": 0.031, "Actual Total Time": 2.259, "Actual Rows": 5123, "Actual Loops": 1, "Output": [ "locInfo__12.id", "locInfo__12.asset_info_id" ], "Index Cond": "((locInfo__12.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__12.org_id = 761024) AND (locInfo__12.event_ts >= '1541376000000'::bigint) AND (locInfo__12.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 231, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_1_part1", "Relation Name": "location_info_2019_1_part1", "Schema": "public", "Alias": "locInfo__13", "Startup Cost": 0.57, "Total Cost": 19357.7, "Plan Rows": 5045, "Plan Width": 16, "Actual Startup Time": 0.035, "Actual Total Time": 0.035, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__13.id", "locInfo__13.asset_info_id" ], "Index Cond": "((locInfo__13.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__13.org_id = 761024) AND (locInfo__13.event_ts >= '1541376000000'::bigint) AND (locInfo__13.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_1_part2", "Relation Name": "location_info_2019_1_part2", "Schema": "public", "Alias": "locInfo__14", "Startup Cost": 0.57, "Total Cost": 17954.35, "Plan Rows": 4504, "Plan Width": 16, "Actual Startup Time": 0.035, "Actual Total Time": 0.035, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__14.id", "locInfo__14.asset_info_id" ], "Index Cond": "((locInfo__14.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__14.org_id = 761024) AND (locInfo__14.event_ts >= '1541376000000'::bigint) AND (locInfo__14.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_1_part3", "Relation Name": "location_info_2019_1_part3", "Schema": "public", "Alias": "locInfo__15", "Startup Cost": 0.57, "Total Cost": 17819.87, "Plan Rows": 4483, "Plan Width": 16, "Actual Startup Time": 0.037, "Actual Total Time": 0.037, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__15.id", "locInfo__15.asset_info_id" ], "Index Cond": "((locInfo__15.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__15.org_id = 761024) AND (locInfo__15.event_ts >= '1541376000000'::bigint) AND (locInfo__15.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_1_part4", "Relation Name": "location_info_2019_1_part4", "Schema": "public", "Alias": "locInfo__16", "Startup Cost": 0.57, "Total Cost": 16017.63, "Plan Rows": 4011, "Plan Width": 16, "Actual Startup Time": 0.033, "Actual Total Time": 0.033, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__16.id", "locInfo__16.asset_info_id" ], "Index Cond": "((locInfo__16.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__16.org_id = 761024) AND (locInfo__16.event_ts >= '1541376000000'::bigint) AND (locInfo__16.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_1_part5", "Relation Name": "location_info_2019_1_part5", "Schema": "public", "Alias": "locInfo__17", "Startup Cost": 0.57, "Total Cost": 20911.5, "Plan Rows": 5263, "Plan Width": 16, "Actual Startup Time": 0.035, "Actual Total Time": 0.035, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__17.id", "locInfo__17.asset_info_id" ], "Index Cond": "((locInfo__17.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__17.org_id = 761024) AND (locInfo__17.event_ts >= '1541376000000'::bigint) AND (locInfo__17.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_2_part1", "Relation Name": "location_info_2019_2_part1", "Schema": "public", "Alias": "locInfo__18", "Startup Cost": 0.57, "Total Cost": 16942.71, "Plan Rows": 4474, "Plan Width": 16, "Actual Startup Time": 0.032, "Actual Total Time": 0.032, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__18.id", "locInfo__18.asset_info_id" ], "Index Cond": "((locInfo__18.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__18.org_id = 761024) AND (locInfo__18.event_ts >= '1541376000000'::bigint) AND (locInfo__18.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "location_info_2019_2_part2", "Schema": "public", "Alias": "locInfo__19", "Startup Cost": 789.26, "Total Cost": 51867.35, "Plan Rows": 14852, "Plan Width": 16, "Actual Startup Time": 0.587, "Actual Total Time": 2.532, "Actual Rows": 5491, "Actual Loops": 1, "Output": [ "locInfo__19.id", "locInfo__19.asset_info_id" ], "Recheck Cond": "((locInfo__19.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__19.org_id = 761024) AND (locInfo__19.event_ts >= '1541376000000'::bigint) AND (locInfo__19.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Exact Heap Blocks": 173, "Lossy Heap Blocks": 0, "Shared Hit Blocks": 245, "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, "I/O Read Time": 0, "I/O Write Time": 0, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Index Name": "asset_org_event_2_part2", "Startup Cost": 0, "Total Cost": 785.55, "Plan Rows": 14852, "Plan Width": 0, "Actual Startup Time": 0.559, "Actual Total Time": 0.559, "Actual Rows": 5491, "Actual Loops": 1, "Index Cond": "((locInfo__19.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__19.org_id = 761024) AND (locInfo__19.event_ts >= '1541376000000'::bigint) AND (locInfo__19.event_ts <= '1549843199999'::bigint))", "Shared Hit Blocks": 72, "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, "I/O Read Time": 0, "I/O Write Time": 0 } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_2_part3", "Relation Name": "location_info_2019_2_part3", "Schema": "public", "Alias": "locInfo__20", "Startup Cost": 0.15, "Total Cost": 8.82, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__20.id", "locInfo__20.asset_info_id" ], "Index Cond": "((locInfo__20.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__20.org_id = 761024) AND (locInfo__20.event_ts >= '1541376000000'::bigint) AND (locInfo__20.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 5, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_2_part4", "Relation Name": "location_info_2019_2_part4", "Schema": "public", "Alias": "locInfo__21", "Startup Cost": 0.15, "Total Cost": 8.82, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.005, "Actual Total Time": 0.005, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__21.id", "locInfo__21.asset_info_id" ], "Index Cond": "((locInfo__21.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__21.org_id = 761024) AND (locInfo__21.event_ts >= '1541376000000'::bigint) AND (locInfo__21.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 5, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Scan Direction": "Forward", "Index Name": "asset_org_event_2_part5", "Relation Name": "location_info_2019_2_part5", "Schema": "public", "Alias": "locInfo__22", "Startup Cost": 0.15, "Total Cost": 8.82, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.006, "Actual Total Time": 0.006, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locInfo__22.id", "locInfo__22.asset_info_id" ], "Index Cond": "((locInfo__22.asset_id = ANY ('{28600310,49149326,28508667,28345648,7619520}'::bigint[])) AND (locInfo__22.org_id = 761024) AND (locInfo__22.event_ts >= '1541376000000'::bigint) AND (locInfo__22.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 5, "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, "I/O Read Time": 0, "I/O Write Time": 0 } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": false, "Startup Cost": 6863799.16, "Total Cost": 6863799.16, "Plan Rows": 100736472, "Plan Width": 8, "Actual Startup Time": 91297.269, "Actual Total Time": 91297.269, "Actual Rows": 102137856, "Actual Loops": 1, "Output": [ "assetInfo1_.id" ], "Hash Buckets": 131072, "Original Hash Buckets": 131072, "Hash Batches": 2048, "Original Hash Batches": 2048, "Peak Memory Usage": 2987, "Shared Hit Blocks": 6692617, "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": 347901, "I/O Read Time": 0, "I/O Write Time": 0, "Plans": [ { "Node Type": "Append", "Parent Relationship": "Outer", "Parallel Aware": false, "Startup Cost": 0, "Total Cost": 6863799.16, "Plan Rows": 100736472, "Plan Width": 8, "Actual Startup Time": 0.172, "Actual Total Time": 64234.934, "Actual Rows": 102137856, "Actual Loops": 1, "Shared Hit Blocks": 6692617, "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, "I/O Read Time": 0, "I/O Write Time": 0, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info", "Schema": "public", "Alias": "assetInfo1_", "Startup Cost": 0, "Total Cost": 0, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "assetInfo1_.id" ], "Filter": "(assetInfo1_.source = ANY ('{17,525}'::text[]))", "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_10_part4", "Schema": "public", "Alias": "assetInfo1__1", "Startup Cost": 0, "Total Cost": 660005.9, "Plan Rows": 12929093, "Plan Width": 8, "Actual Startup Time": 0.17, "Actual Total Time": 5389.284, "Actual Rows": 13174906, "Actual Loops": 1, "Output": [ "assetInfo1__1.id" ], "Filter": "(assetInfo1__1.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 15505616, "Shared Hit Blocks": 609425, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_10_part5", "Schema": "public", "Alias": "assetInfo1__2", "Startup Cost": 0, "Total Cost": 683329.65, "Plan Rows": 12464649, "Plan Width": 8, "Actual Startup Time": 0.163, "Actual Total Time": 5270.354, "Actual Rows": 12661134, "Actual Loops": 1, "Output": [ "assetInfo1__2.id" ], "Filter": "(assetInfo1__2.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 16842716, "Shared Hit Blocks": 645334, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_11_part1", "Schema": "public", "Alias": "assetInfo1__3", "Startup Cost": 0, "Total Cost": 485312.8, "Plan Rows": 7539394, "Plan Width": 8, "Actual Startup Time": 0.172, "Actual Total Time": 3585.848, "Actual Rows": 7623744, "Actual Loops": 1, "Output": [ "assetInfo1__3.id" ], "Filter": "(assetInfo1__3.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 13166907, "Shared Hit Blocks": 453718, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_11_part2", "Schema": "public", "Alias": "assetInfo1__4", "Startup Cost": 0, "Total Cost": 428920.45, "Plan Rows": 6680494, "Plan Width": 8, "Actual Startup Time": 0.196, "Actual Total Time": 3247.226, "Actual Rows": 6849545, "Actual Loops": 1, "Output": [ "assetInfo1__4.id" ], "Filter": "(assetInfo1__4.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 11440929, "Shared Hit Blocks": 410655, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_11_part3", "Schema": "public", "Alias": "assetInfo1__5", "Startup Cost": 0, "Total Cost": 433014.28, "Plan Rows": 6700578, "Plan Width": 8, "Actual Startup Time": 0.178, "Actual Total Time": 3561.953, "Actual Rows": 6879382, "Actual Loops": 1, "Output": [ "assetInfo1__5.id" ], "Filter": "(assetInfo1__5.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 11704633, "Shared Hit Blocks": 413215, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_11_part4", "Schema": "public", "Alias": "assetInfo1__6", "Startup Cost": 0, "Total Cost": 402753.93, "Plan Rows": 6133178, "Plan Width": 8, "Actual Startup Time": 0.211, "Actual Total Time": 2955.94, "Actual Rows": 6184694, "Actual Loops": 1, "Output": [ "assetInfo1__6.id" ], "Filter": "(assetInfo1__6.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 10959276, "Shared Hit Blocks": 379906, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_11_part5", "Schema": "public", "Alias": "assetInfo1__7", "Startup Cost": 0, "Total Cost": 390954.44, "Plan Rows": 5759811, "Plan Width": 8, "Actual Startup Time": 0.17, "Actual Total Time": 2945.315, "Actual Rows": 5826285, "Actual Loops": 1, "Output": [ "assetInfo1__7.id" ], "Filter": "(assetInfo1__7.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 10933880, "Shared Hit Blocks": 366269, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_12_part1", "Schema": "public", "Alias": "assetInfo1__8", "Startup Cost": 0, "Total Cost": 358437.56, "Plan Rows": 4691813, "Plan Width": 8, "Actual Startup Time": 0.192, "Actual Total Time": 2631.384, "Actual Rows": 4829808, "Actual Loops": 1, "Output": [ "assetInfo1__8.id" ], "Filter": "(assetInfo1__8.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 10082061, "Shared Hit Blocks": 349897, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_12_part2", "Schema": "public", "Alias": "assetInfo1__9", "Startup Cost": 0, "Total Cost": 338873.81, "Plan Rows": 4614963, "Plan Width": 8, "Actual Startup Time": 0.204, "Actual Total Time": 2506.263, "Actual Rows": 4727787, "Actual Loops": 1, "Output": [ "assetInfo1__9.id" ], "Filter": "(assetInfo1__9.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 9482307, "Shared Hit Blocks": 328337, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_12_part3", "Schema": "public", "Alias": "assetInfo1__10", "Startup Cost": 0, "Total Cost": 308748.5, "Plan Rows": 3983394, "Plan Width": 8, "Actual Startup Time": 0.218, "Actual Total Time": 2281.128, "Actual Rows": 4037564, "Actual Loops": 1, "Output": [ "assetInfo1__10.id" ], "Filter": "(assetInfo1__10.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 9067139, "Shared Hit Blocks": 293545, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_12_part4", "Schema": "public", "Alias": "assetInfo1__11", "Startup Cost": 0, "Total Cost": 246173.55, "Plan Rows": 2943598, "Plan Width": 8, "Actual Startup Time": 0.204, "Actual Total Time": 1784.318, "Actual Rows": 2960007, "Actual Loops": 1, "Output": [ "assetInfo1__11.id" ], "Filter": "(assetInfo1__11.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 7411043, "Shared Hit Blocks": 236552, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2018_12_part5", "Schema": "public", "Alias": "assetInfo1__12", "Startup Cost": 0, "Total Cost": 231807.89, "Plan Rows": 2360564, "Plan Width": 8, "Actual Startup Time": 0.171, "Actual Total Time": 1673.177, "Actual Rows": 2385934, "Actual Loops": 1, "Output": [ "assetInfo1__12.id" ], "Filter": "(assetInfo1__12.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 6963628, "Shared Hit Blocks": 233041, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2019_1_part1", "Schema": "public", "Alias": "assetInfo1__13", "Startup Cost": 0, "Total Cost": 246547.9, "Plan Rows": 2901647, "Plan Width": 8, "Actual Startup Time": 0.21, "Actual Total Time": 1685.254, "Actual Rows": 2948564, "Actual Loops": 1, "Output": [ "assetInfo1__13.id" ], "Filter": "(assetInfo1__13.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 6387372, "Shared Hit Blocks": 260257, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2019_1_part2", "Schema": "public", "Alias": "assetInfo1__14", "Startup Cost": 0, "Total Cost": 343601.75, "Plan Rows": 4228264, "Plan Width": 8, "Actual Startup Time": 0.199, "Actual Total Time": 2385.551, "Actual Rows": 4253701, "Actual Loops": 1, "Output": [ "assetInfo1__14.id" ], "Filter": "(assetInfo1__14.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 9071308, "Shared Hit Blocks": 354374, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2019_1_part3", "Schema": "public", "Alias": "assetInfo1__15", "Startup Cost": 0, "Total Cost": 340016.75, "Plan Rows": 4096141, "Plan Width": 8, "Actual Startup Time": 0.177, "Actual Total Time": 2335.096, "Actual Rows": 4102257, "Actual Loops": 1, "Output": [ "assetInfo1__15.id" ], "Filter": "(assetInfo1__15.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 8960889, "Shared Hit Blocks": 353919, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2019_1_part4", "Schema": "public", "Alias": "assetInfo1__16", "Startup Cost": 0, "Total Cost": 344526.71, "Plan Rows": 4411357, "Plan Width": 8, "Actual Startup Time": 0.173, "Actual Total Time": 2377.144, "Actual Rows": 4409313, "Actual Loops": 1, "Output": [ "assetInfo1__16.id" ], "Filter": "(assetInfo1__16.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 8742806, "Shared Hit Blocks": 360654, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2019_1_part5", "Schema": "public", "Alias": "assetInfo1__17", "Startup Cost": 0, "Total Cost": 417399.19, "Plan Rows": 5711574, "Plan Width": 8, "Actual Startup Time": 0.182, "Actual Total Time": 2883.983, "Actual Rows": 5692780, "Actual Loops": 1, "Output": [ "assetInfo1__17.id" ], "Filter": "(assetInfo1__17.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 10456466, "Shared Hit Blocks": 431736, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2019_2_part1", "Schema": "public", "Alias": "assetInfo1__18", "Startup Cost": 0, "Total Cost": 202386.42, "Plan Rows": 2576843, "Plan Width": 8, "Actual Startup Time": 0.188, "Actual Total Time": 1397.708, "Actual Rows": 2581374, "Actual Loops": 1, "Output": [ "assetInfo1__18.id" ], "Filter": "(assetInfo1__18.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 5207753, "Shared Hit Blocks": 210534, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2019_2_part2", "Schema": "public", "Alias": "assetInfo1__19", "Startup Cost": 0, "Total Cost": 937.06, "Plan Rows": 9098, "Plan Width": 8, "Actual Startup Time": 0.17, "Actual Total Time": 4.463, "Actual Rows": 9077, "Actual Loops": 1, "Output": [ "assetInfo1__19.id" ], "Filter": "(assetInfo1__19.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 6645, "Shared Hit Blocks": 1249, "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2019_2_part3", "Schema": "public", "Alias": "assetInfo1__20", "Startup Cost": 0, "Total Cost": 16.88, "Plan Rows": 6, "Plan Width": 8, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "assetInfo1__20.id" ], "Filter": "(assetInfo1__20.source = ANY ('{17,525}'::text[]))", "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2019_2_part4", "Schema": "public", "Alias": "assetInfo1__21", "Startup Cost": 0, "Total Cost": 16.88, "Plan Rows": 6, "Plan Width": 8, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "assetInfo1__21.id" ], "Filter": "(assetInfo1__21.source = ANY ('{17,525}'::text[]))", "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, "I/O Read Time": 0, "I/O Write Time": 0 }, { "Node Type": "Seq Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Relation Name": "asset_info_2019_2_part5", "Schema": "public", "Alias": "assetInfo1__22", "Startup Cost": 0, "Total Cost": 16.88, "Plan Rows": 6, "Plan Width": 8, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "assetInfo1__22.id" ], "Filter": "(assetInfo1__22.source = ANY ('{17,525}'::text[]))", "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, "I/O Read Time": 0, "I/O Write Time": 0 } ] } ] } ] } ] }, "Planning Time": 5.087, "Triggers": [], "Execution Time": 92005.482 } ]