[ { "Plan": { "Node Type": "Aggregate", "Strategy": "Plain", "Partial Mode": "Simple", "Parallel Aware": false, "Startup Cost": 10288.38, "Total Cost": 10288.39, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 1957.805, "Actual Total Time": 1957.805, "Actual Rows": 1, "Actual Loops": 1, "Output": [ "count(locationinfo0_.id)" ], "Shared Hit Blocks": 3258774, "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": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Join Type": "Inner", "Startup Cost": 0, "Total Cost": 10288.24, "Plan Rows": 58, "Plan Width": 8, "Actual Startup Time": 0.914, "Actual Total Time": 1947.522, "Actual Rows": 50757, "Actual Loops": 1, "Output": [ "locationinfo0_.id" ], "Shared Hit Blocks": 3258774, "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": "Append", "Parent Relationship": "Outer", "Parallel Aware": false, "Startup Cost": 0, "Total Cost": 559.88, "Plan Rows": 58, "Plan Width": 16, "Actual Startup Time": 0.026, "Actual Total Time": 45.402, "Actual Rows": 54141, "Actual Loops": 1, "Shared Hit Blocks": 9253, "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": "locationinfo0_", "Startup Cost": 0, "Total Cost": 0, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locationinfo0_.id", "locationinfo0_.asset_info_id" ], "Filter": "((locationinfo0_.event_ts >= '1541376000000'::bigint) AND (locationinfo0_.event_ts <= '1549843199999'::bigint) AND (locationinfo0_.org_id = 1136) AND (locationinfo0_.asset_id = ANY ('{289522,226613,79608,485009}'::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": "locationinfo0__1", "Startup Cost": 0.57, "Total Cost": 8.6, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locationinfo0__1.id", "locationinfo0__1.asset_info_id" ], "Index Cond": "((locationinfo0__1.event_ts >= '1541376000000'::bigint) AND (locationinfo0__1.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Filter": "((locationinfo0__1.org_id = 1136) AND (locationinfo0__1.asset_id = ANY ('{289522,226613,79608,485009}'::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": "locationinfo0__2", "Startup Cost": 0.57, "Total Cost": 8.6, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.003, "Actual Total Time": 0.003, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locationinfo0__2.id", "locationinfo0__2.asset_info_id" ], "Index Cond": "((locationinfo0__2.event_ts >= '1541376000000'::bigint) AND (locationinfo0__2.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Filter": "((locationinfo0__2.org_id = 1136) AND (locationinfo0__2.asset_id = ANY ('{289522,226613,79608,485009}'::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": "locationinfo0__3", "Startup Cost": 0.57, "Total Cost": 22.36, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.014, "Actual Total Time": 3.301, "Actual Rows": 4174, "Actual Loops": 1, "Output": [ "locationinfo0__3.id", "locationinfo0__3.asset_info_id" ], "Index Cond": "((locationinfo0__3.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__3.org_id = 1136) AND (locationinfo0__3.event_ts >= '1541376000000'::bigint) AND (locationinfo0__3.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1164, "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": "locationinfo0__4", "Startup Cost": 0.57, "Total Cost": 30.3, "Plan Rows": 3, "Plan Width": 16, "Actual Startup Time": 0.013, "Actual Total Time": 2.111, "Actual Rows": 2952, "Actual Loops": 1, "Output": [ "locationinfo0__4.id", "locationinfo0__4.asset_info_id" ], "Index Cond": "((locationinfo0__4.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__4.org_id = 1136) AND (locationinfo0__4.event_ts >= '1541376000000'::bigint) AND (locationinfo0__4.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 475, "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": "locationinfo0__5", "Startup Cost": 0.57, "Total Cost": 30.3, "Plan Rows": 3, "Plan Width": 16, "Actual Startup Time": 0.012, "Actual Total Time": 3.139, "Actual Rows": 4947, "Actual Loops": 1, "Output": [ "locationinfo0__5.id", "locationinfo0__5.asset_info_id" ], "Index Cond": "((locationinfo0__5.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__5.org_id = 1136) AND (locationinfo0__5.event_ts >= '1541376000000'::bigint) AND (locationinfo0__5.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 763, "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": "locationinfo0__6", "Startup Cost": 0.57, "Total Cost": 30.28, "Plan Rows": 3, "Plan Width": 16, "Actual Startup Time": 0.015, "Actual Total Time": 7.851, "Actual Rows": 10189, "Actual Loops": 1, "Output": [ "locationinfo0__6.id", "locationinfo0__6.asset_info_id" ], "Index Cond": "((locationinfo0__6.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__6.org_id = 1136) AND (locationinfo0__6.event_ts >= '1541376000000'::bigint) AND (locationinfo0__6.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1546, "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": "locationinfo0__7", "Startup Cost": 0.57, "Total Cost": 34.26, "Plan Rows": 4, "Plan Width": 16, "Actual Startup Time": 0.013, "Actual Total Time": 2.25, "Actual Rows": 2475, "Actual Loops": 1, "Output": [ "locationinfo0__7.id", "locationinfo0__7.asset_info_id" ], "Index Cond": "((locationinfo0__7.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__7.org_id = 1136) AND (locationinfo0__7.event_ts >= '1541376000000'::bigint) AND (locationinfo0__7.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 677, "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": "locationinfo0__8", "Startup Cost": 0.57, "Total Cost": 34.15, "Plan Rows": 4, "Plan Width": 16, "Actual Startup Time": 0.013, "Actual Total Time": 2.276, "Actual Rows": 3036, "Actual Loops": 1, "Output": [ "locationinfo0__8.id", "locationinfo0__8.asset_info_id" ], "Index Cond": "((locationinfo0__8.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__8.org_id = 1136) AND (locationinfo0__8.event_ts >= '1541376000000'::bigint) AND (locationinfo0__8.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 477, "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": "locationinfo0__9", "Startup Cost": 0.57, "Total Cost": 30.19, "Plan Rows": 3, "Plan Width": 16, "Actual Startup Time": 0.014, "Actual Total Time": 1.653, "Actual Rows": 2627, "Actual Loops": 1, "Output": [ "locationinfo0__9.id", "locationinfo0__9.asset_info_id" ], "Index Cond": "((locationinfo0__9.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__9.org_id = 1136) AND (locationinfo0__9.event_ts >= '1541376000000'::bigint) AND (locationinfo0__9.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 428, "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": "locationinfo0__10", "Startup Cost": 0.57, "Total Cost": 30.17, "Plan Rows": 3, "Plan Width": 16, "Actual Startup Time": 0.013, "Actual Total Time": 2.855, "Actual Rows": 4404, "Actual Loops": 1, "Output": [ "locationinfo0__10.id", "locationinfo0__10.asset_info_id" ], "Index Cond": "((locationinfo0__10.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__10.org_id = 1136) AND (locationinfo0__10.event_ts >= '1541376000000'::bigint) AND (locationinfo0__10.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 600, "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": "locationinfo0__11", "Startup Cost": 0.57, "Total Cost": 30.06, "Plan Rows": 3, "Plan Width": 16, "Actual Startup Time": 0.012, "Actual Total Time": 0.682, "Actual Rows": 1040, "Actual Loops": 1, "Output": [ "locationinfo0__11.id", "locationinfo0__11.asset_info_id" ], "Index Cond": "((locationinfo0__11.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__11.org_id = 1136) AND (locationinfo0__11.event_ts >= '1541376000000'::bigint) AND (locationinfo0__11.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 173, "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": "locationinfo0__12", "Startup Cost": 0.57, "Total Cost": 29.75, "Plan Rows": 3, "Plan Width": 16, "Actual Startup Time": 0.009, "Actual Total Time": 0.964, "Actual Rows": 1527, "Actual Loops": 1, "Output": [ "locationinfo0__12.id", "locationinfo0__12.asset_info_id" ], "Index Cond": "((locationinfo0__12.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__12.org_id = 1136) AND (locationinfo0__12.event_ts >= '1541376000000'::bigint) AND (locationinfo0__12.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 152, "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": "locationinfo0__13", "Startup Cost": 0.57, "Total Cost": 29.92, "Plan Rows": 3, "Plan Width": 16, "Actual Startup Time": 0.01, "Actual Total Time": 1.6, "Actual Rows": 1903, "Actual Loops": 1, "Output": [ "locationinfo0__13.id", "locationinfo0__13.asset_info_id" ], "Index Cond": "((locationinfo0__13.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__13.org_id = 1136) AND (locationinfo0__13.event_ts >= '1541376000000'::bigint) AND (locationinfo0__13.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 265, "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": "locationinfo0__14", "Startup Cost": 0.57, "Total Cost": 34.15, "Plan Rows": 4, "Plan Width": 16, "Actual Startup Time": 0.012, "Actual Total Time": 1.683, "Actual Rows": 2396, "Actual Loops": 1, "Output": [ "locationinfo0__14.id", "locationinfo0__14.asset_info_id" ], "Index Cond": "((locationinfo0__14.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__14.org_id = 1136) AND (locationinfo0__14.event_ts >= '1541376000000'::bigint) AND (locationinfo0__14.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 445, "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": "locationinfo0__15", "Startup Cost": 0.57, "Total Cost": 34.13, "Plan Rows": 4, "Plan Width": 16, "Actual Startup Time": 0.009, "Actual Total Time": 2.06, "Actual Rows": 3184, "Actual Loops": 1, "Output": [ "locationinfo0__15.id", "locationinfo0__15.asset_info_id" ], "Index Cond": "((locationinfo0__15.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__15.org_id = 1136) AND (locationinfo0__15.event_ts >= '1541376000000'::bigint) AND (locationinfo0__15.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 493, "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": "locationinfo0__16", "Startup Cost": 0.57, "Total Cost": 34.16, "Plan Rows": 4, "Plan Width": 16, "Actual Startup Time": 0.01, "Actual Total Time": 2.523, "Actual Rows": 3706, "Actual Loops": 1, "Output": [ "locationinfo0__16.id", "locationinfo0__16.asset_info_id" ], "Index Cond": "((locationinfo0__16.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__16.org_id = 1136) AND (locationinfo0__16.event_ts >= '1541376000000'::bigint) AND (locationinfo0__16.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 613, "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": "locationinfo0__17", "Startup Cost": 0.57, "Total Cost": 34.12, "Plan Rows": 4, "Plan Width": 16, "Actual Startup Time": 0.01, "Actual Total Time": 3.196, "Actual Rows": 4472, "Actual Loops": 1, "Output": [ "locationinfo0__17.id", "locationinfo0__17.asset_info_id" ], "Index Cond": "((locationinfo0__17.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__17.org_id = 1136) AND (locationinfo0__17.event_ts >= '1541376000000'::bigint) AND (locationinfo0__17.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 755, "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": "locationinfo0__18", "Startup Cost": 0.57, "Total Cost": 26.09, "Plan Rows": 2, "Plan Width": 16, "Actual Startup Time": 0.017, "Actual Total Time": 0.855, "Actual Rows": 1109, "Actual Loops": 1, "Output": [ "locationinfo0__18.id", "locationinfo0__18.asset_info_id" ], "Index Cond": "((locationinfo0__18.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__18.org_id = 1136) AND (locationinfo0__18.event_ts >= '1541376000000'::bigint) AND (locationinfo0__18.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 191, "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_part2", "Relation Name": "location_info_2019_2_part2", "Schema": "public", "Alias": "locationinfo0__19", "Startup Cost": 0.56, "Total Cost": 22.31, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.016, "Actual Total Time": 0.016, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locationinfo0__19.id", "locationinfo0__19.asset_info_id" ], "Index Cond": "((locationinfo0__19.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__19.org_id = 1136) AND (locationinfo0__19.event_ts >= '1541376000000'::bigint) AND (locationinfo0__19.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 16, "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": "locationinfo0__20", "Startup Cost": 0.15, "Total Cost": 8.66, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.004, "Actual Total Time": 0.004, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locationinfo0__20.id", "locationinfo0__20.asset_info_id" ], "Index Cond": "((locationinfo0__20.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__20.org_id = 1136) AND (locationinfo0__20.event_ts >= '1541376000000'::bigint) AND (locationinfo0__20.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 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_2_part4", "Relation Name": "location_info_2019_2_part4", "Schema": "public", "Alias": "locationinfo0__21", "Startup Cost": 0.15, "Total Cost": 8.66, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.004, "Actual Total Time": 0.004, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locationinfo0__21.id", "locationinfo0__21.asset_info_id" ], "Index Cond": "((locationinfo0__21.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__21.org_id = 1136) AND (locationinfo0__21.event_ts >= '1541376000000'::bigint) AND (locationinfo0__21.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 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_2_part5", "Relation Name": "location_info_2019_2_part5", "Schema": "public", "Alias": "locationinfo0__22", "Startup Cost": 0.15, "Total Cost": 8.66, "Plan Rows": 1, "Plan Width": 16, "Actual Startup Time": 0.004, "Actual Total Time": 0.004, "Actual Rows": 0, "Actual Loops": 1, "Output": [ "locationinfo0__22.id", "locationinfo0__22.asset_info_id" ], "Index Cond": "((locationinfo0__22.asset_id = ANY ('{289522,226613,79608,485009}'::bigint[])) AND (locationinfo0__22.org_id = 1136) AND (locationinfo0__22.event_ts >= '1541376000000'::bigint) AND (locationinfo0__22.event_ts <= '1549843199999'::bigint))", "Rows Removed by Index Recheck": 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": "Append", "Parent Relationship": "Inner", "Parallel Aware": false, "Startup Cost": 0, "Total Cost": 167.5, "Plan Rows": 23, "Plan Width": 8, "Actual Startup Time": 0.018, "Actual Total Time": 0.034, "Actual Rows": 1, "Actual Loops": 54141, "Shared Hit Blocks": 3249521, "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, "Actual Total Time": 0, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1_.id" ], "Filter": "((assetinfo1_.source = ANY ('{17,525}'::text[])) AND (locationinfo0_.asset_info_id = assetinfo1_.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, "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_info_pkey_10_part4", "Relation Name": "asset_info_2018_10_part4", "Schema": "public", "Alias": "assetinfo1__1", "Startup Cost": 0.44, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__1.id" ], "Index Cond": "(assetinfo1__1.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__1.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 162425, "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_info_pkey_10_part5", "Relation Name": "asset_info_2018_10_part5", "Schema": "public", "Alias": "assetinfo1__2", "Startup Cost": 0.44, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__2.id" ], "Index Cond": "(assetinfo1__2.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__2.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 162524, "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_info_pkey_11_part1", "Relation Name": "asset_info_2018_11_part1", "Schema": "public", "Alias": "assetinfo1__3", "Startup Cost": 0.44, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__3.id" ], "Index Cond": "(assetinfo1__3.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__3.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 166669, "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_info_pkey_11_part2", "Relation Name": "asset_info_2018_11_part2", "Schema": "public", "Alias": "assetinfo1__4", "Startup Cost": 0.44, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__4.id" ], "Index Cond": "(assetinfo1__4.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__4.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 165517, "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_info_pkey_11_part3", "Relation Name": "asset_info_2018_11_part3", "Schema": "public", "Alias": "assetinfo1__5", "Startup Cost": 0.44, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__5.id" ], "Index Cond": "(assetinfo1__5.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__5.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 167522, "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_info_pkey_11_part4", "Relation Name": "asset_info_2018_11_part4", "Schema": "public", "Alias": "assetinfo1__6", "Startup Cost": 0.44, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__6.id" ], "Index Cond": "(assetinfo1__6.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__6.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 172705, "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_info_pkey_11_part5", "Relation Name": "asset_info_2018_11_part5", "Schema": "public", "Alias": "assetinfo1__7", "Startup Cost": 0.43, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__7.id" ], "Index Cond": "(assetinfo1__7.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__7.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 164923, "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_info_pkey_12_part1", "Relation Name": "asset_info_2018_12_part1", "Schema": "public", "Alias": "assetinfo1__8", "Startup Cost": 0.43, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__8.id" ], "Index Cond": "(assetinfo1__8.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__8.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 165549, "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_info_pkey_12_part2", "Relation Name": "asset_info_2018_12_part2", "Schema": "public", "Alias": "assetinfo1__9", "Startup Cost": 0.43, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__9.id" ], "Index Cond": "(assetinfo1__9.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__9.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 165093, "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_info_pkey_12_part3", "Relation Name": "asset_info_2018_12_part3", "Schema": "public", "Alias": "assetinfo1__10", "Startup Cost": 0.43, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__10.id" ], "Index Cond": "(assetinfo1__10.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__10.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 166828, "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_info_pkey_12_part4", "Relation Name": "asset_info_2018_12_part4", "Schema": "public", "Alias": "assetinfo1__11", "Startup Cost": 0.43, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__11.id" ], "Index Cond": "(assetinfo1__11.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__11.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 163470, "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_info_pkey_12_part5", "Relation Name": "asset_info_2018_12_part5", "Schema": "public", "Alias": "assetinfo1__12", "Startup Cost": 0.43, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.001, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__12.id" ], "Index Cond": "(assetinfo1__12.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__12.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 164193, "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_info_pkey_1_part1", "Relation Name": "asset_info_2019_1_part1", "Schema": "public", "Alias": "assetinfo1__13", "Startup Cost": 0.43, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__13.id" ], "Index Cond": "(assetinfo1__13.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__13.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 164362, "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_info_pkey_1_part2", "Relation Name": "asset_info_2019_1_part2", "Schema": "public", "Alias": "assetinfo1__14", "Startup Cost": 0.43, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__14.id" ], "Index Cond": "(assetinfo1__14.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__14.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 164847, "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_info_pkey_1_part3", "Relation Name": "asset_info_2019_1_part3", "Schema": "public", "Alias": "assetinfo1__15", "Startup Cost": 0.43, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__15.id" ], "Index Cond": "(assetinfo1__15.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__15.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 165618, "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_info_pkey_1_part4", "Relation Name": "asset_info_2019_1_part4", "Schema": "public", "Alias": "assetinfo1__16", "Startup Cost": 0.43, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__16.id" ], "Index Cond": "(assetinfo1__16.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__16.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 166142, "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_info_pkey_1_part5", "Relation Name": "asset_info_2019_1_part5", "Schema": "public", "Alias": "assetinfo1__17", "Startup Cost": 0.43, "Total Cost": 8.46, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__17.id" ], "Index Cond": "(assetinfo1__17.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__17.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 166897, "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_info_pkey_2_part1", "Relation Name": "asset_info_2019_2_part1", "Schema": "public", "Alias": "assetinfo1__18", "Startup Cost": 0.43, "Total Cost": 8.45, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__18.id" ], "Index Cond": "(assetinfo1__18.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__18.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 163532, "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_info_pkey_2_part2", "Relation Name": "asset_info_2019_2_part2", "Schema": "public", "Alias": "assetinfo1__19", "Startup Cost": 0.29, "Total Cost": 7.13, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.001, "Actual Total Time": 0.001, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__19.id" ], "Index Cond": "(assetinfo1__19.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__19.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 108282, "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_info_pkey_2_part3", "Relation Name": "asset_info_2019_2_part3", "Schema": "public", "Alias": "assetinfo1__20", "Startup Cost": 0.15, "Total Cost": 2.72, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0, "Actual Total Time": 0, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__20.id" ], "Index Cond": "(assetinfo1__20.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__20.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 54141, "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_info_pkey_2_part4", "Relation Name": "asset_info_2019_2_part4", "Schema": "public", "Alias": "assetinfo1__21", "Startup Cost": 0.15, "Total Cost": 2.72, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0, "Actual Total Time": 0, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__21.id" ], "Index Cond": "(assetinfo1__21.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__21.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 54141, "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_info_pkey_2_part5", "Relation Name": "asset_info_2019_2_part5", "Schema": "public", "Alias": "assetinfo1__22", "Startup Cost": 0.15, "Total Cost": 2.72, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0, "Actual Total Time": 0, "Actual Rows": 0, "Actual Loops": 54141, "Output": [ "assetinfo1__22.id" ], "Index Cond": "(assetinfo1__22.id = locationinfo0_.asset_info_id)", "Rows Removed by Index Recheck": 0, "Filter": "(assetinfo1__22.source = ANY ('{17,525}'::text[]))", "Rows Removed by Filter": 0, "Shared Hit Blocks": 54141, "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.658, "Triggers": [], "Execution Time": 1958.435 } ]