On Tue, Feb 12, 2019 at 12:33 PM Michael Lewis <mlewis@xxxxxxxxxxx> wrote:
Did you update the stats by running ANALYZE on the tables involved, or perhaps the entire database on the 'Non prod Aurora RDS instance'? Can you share the two execution plans?
Here is the plan for both of the DB instances.
On Tue, Feb 12, 2019 at 11:27 AM github kran <githubkran@xxxxxxxxx> wrote:On Tue, Feb 12, 2019 at 7:07 AM github kran <githubkran@xxxxxxxxx> wrote:On Mon, Feb 11, 2019 at 6:00 PM github kran <githubkran@xxxxxxxxx> wrote:On Mon, Feb 11, 2019 at 3:29 PM Michael Lewis <mlewis@xxxxxxxxxxx> wrote:Are default statistics target the same on both prod and AWS? Have you analyzed all tables being used in this query to ensure stats are up proper? If the optimizer is choosing a different plan, then the stats must be different IMO.Michael Lewis | Software EngineerEntrataThanks for your reply I have verified few of the tables and their default statistics target and they seem to be same but is there anything in particular you want me to look at it to differentiate Prod and Non prod databases ?. ( Also the DB instance size is same but there is littlemore data in the Non prod Aurora RDS instance compared to Prod instance).Query used.select * from pg_stats where tablename = 'tableName'On Mon, Feb 11, 2019 at 2:15 PM github kran <githubkran@xxxxxxxxx> wrote:Hi Postgres Team,We are using AWS Aurora RDS Postgres DB 9.6.8 Engine. We recently deleted few million rows from the database and ran into a issue in one of our dev account where theDB was not normal after this deletion. We did re index, vacuuming entire database but we couldnt bring it to the same state as earlier. So next steps we deleted the database andrecreated the database by copying the snapshot from a production instance. Further did vacumming, re-index on the database.After this now the dev database seems to be in a better state than earlier but we are seeing few of our DB calls are taking more than 1 minute when we are fetching data and we observedthis is because the query plan was executing a hash join as part of the query whereas a similar query on prod instance is not doing any hash join and is returning faster.Also we did not want to experiment by modifing the DB settings by doing enable_hash_join to off or random_page_count to 1 as we dont have these settings in Prod instance.Note:The partition table sizes we have here is between 40 GB to 75 GB and this is our normal size range, we have a new partition table for every 7 days.Appreciate your ideas on what we could be missing and what we can correct here to reduce the query latency.ThanksgithubKran
[
{
"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
}
][
{
"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
}
]
