[ { "Plan": { "Node Type": "Gather", "Parallel Aware": false, "Startup Cost": 26816.22, "Total Cost": 1779629.31, "Plan Rows": 181925, "Plan Width": 20, "Actual Startup Time": 4182.247, "Actual Total Time": 18239.862, "Actual Rows": 895940, "Actual Loops": 1, "Output": ["t_2.\"ID_JOUR\"", "t_2.\"ID_TRAIN\"", "t_2.\"JX\"", "t_2.\"DSP_CC4\"", "t_2.\"DSP_CC12\""], "Workers Planned": 4, "Workers Launched": 0, "Single Copy": false, "Shared Hit Blocks": 3409, "Shared Read Blocks": 288099, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Parallel Aware": true, "Join Type": "Inner", "Startup Cost": 25816.22, "Total Cost": 1760436.81, "Plan Rows": 45481, "Plan Width": 20, "Actual Startup Time": 4172.911, "Actual Total Time": 18116.765, "Actual Rows": 895940, "Actual Loops": 1, "Output": ["t_2.\"ID_JOUR\"", "t_2.\"ID_TRAIN\"", "t_2.\"JX\"", "t_2.\"DSP_CC4\"", "t_2.\"DSP_CC12\""], "Inner Unique": true, "Hash Cond": "((t_2.\"ID_JOUR\" = dcd.\"ID_JOUR\") AND (t_2.\"JX\" = dcd.\"JX\"))", "Shared Hit Blocks": 3409, "Shared Read Blocks": 288099, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Append", "Parent Relationship": "Outer", "Parallel Aware": true, "Startup Cost": 7670.07, "Total Cost": 1740220.13, "Plan Rows": 394385, "Plan Width": 20, "Actual Startup Time": 93.726, "Actual Total Time": 13755.786, "Actual Rows": 895940, "Actual Loops": 1, "Shared Hit Blocks": 320, "Shared Read Blocks": 287211, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Subplans Removed": 0, "Plans": [ { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Member", "Parallel Aware": true, "Relation Name": "F_TDOJ_HIST_1_OLDP_p4740", "Schema": "partitionschema", "Alias": "t_2", "Startup Cost": 22441.33, "Total Cost": 553961.36, "Plan Rows": 124128, "Plan Width": 20, "Actual Startup Time": 374.001, "Actual Total Time": 2378.868, "Actual Rows": 289708, "Actual Loops": 1, "Output": ["t_2.\"ID_JOUR\"", "t_2.\"ID_TRAIN\"", "t_2.\"JX\"", "t_2.\"DSP_CC4\"", "t_2.\"DSP_CC12\""], "Recheck Cond": "(((t_2.\"ID_TRAIN\" = 10547) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 12049) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 12401) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 11565) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 444) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 586) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 13576) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 13573) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 16288) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 16623) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_JOUR\" >= 4774) AND (t_2.\"ID_JOUR\" <= 4779)) OR ((t_2.\"ID_TRAIN\" = 585) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 10618) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 231) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 815) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 143) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 10610) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 12927) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 10546) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 213) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 214) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 364) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 710) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 13571) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 13575) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 13578) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_JOUR\" >= 4774) AND (t_2.\"ID_JOUR\" <= 4779)) OR ((t_2.\"ID_TRAIN\" = 16289) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 16624) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 474) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 13582) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)) OR ((t_2.\"ID_TRAIN\" = 843) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1)))", "Rows Removed by Index Recheck": 0, "Filter": "((t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1) AND (((t_2.\"ID_TRAIN\" = 10547) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 12049) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 12401) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 11565) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 444) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 586) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 13576) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 13573) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 16288) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 16623) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 17647) AND (t_2.\"ID_JOUR\" >= 4774)) OR ((t_2.\"ID_TRAIN\" = 585) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 10618) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 231) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 815) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 143) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 10610) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 12927) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 10546) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 213) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 214) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 364) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 710) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 13571) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 13575) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 13578) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 14522) AND (t_2.\"ID_JOUR\" >= 4774)) OR ((t_2.\"ID_TRAIN\" = 16289) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 16624) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 474) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 13582) AND (t_2.\"ID_JOUR\" >= 4688)) OR ((t_2.\"ID_TRAIN\" = 843) AND (t_2.\"ID_JOUR\" >= 4688))))", "Rows Removed by Filter": 0, "Exact Heap Blocks": 134822, "Lossy Heap Blocks": 0, "Shared Hit Blocks": 75, "Shared Read Blocks": 137955, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "BitmapOr", "Parent Relationship": "Outer", "Parallel Aware": false, "Startup Cost": 22441.33, "Total Cost": 22441.33, "Plan Rows": 499823, "Plan Width": 0, "Actual Startup Time": 330.220, "Actual Total Time": 330.246, "Actual Rows": 0, "Actual Loops": 1, "Shared Hit Blocks": 75, "Shared Read Blocks": 3133, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 38.432, "Actual Total Time": 38.433, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 10547) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 0, "Shared Read Blocks": 4, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 4.323, "Actual Total Time": 4.323, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 12049) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 1, "Shared Read Blocks": 3, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.043, "Actual Total Time": 0.043, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 12401) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.023, "Actual Total Time": 0.023, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 11565) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 45.022, "Actual Total Time": 45.022, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 444) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 1, "Shared Read Blocks": 282, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 6.810, "Actual Total Time": 6.810, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 586) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 287, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 35.318, "Actual Total Time": 35.318, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 13576) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.011, "Actual Total Time": 0.011, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 13573) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 2.228, "Actual Total Time": 2.228, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 16288) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 1, "Shared Read Blocks": 3, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.044, "Actual Total Time": 0.044, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 16623) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_ID_JOUR_idx", "Startup Cost": 0.00, "Total Cost": 1.68, "Plan Rows": 1, "Plan Width": 0, "Actual Startup Time": 49.936, "Actual Total Time": 49.937, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_JOUR\" >= 4774) AND (t_2.\"ID_JOUR\" <= 4779))", "Shared Hit Blocks": 0, "Shared Read Blocks": 4, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 12.084, "Actual Total Time": 12.084, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 585) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 3, "Shared Read Blocks": 286, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 1.850, "Actual Total Time": 1.850, "Actual Rows": 6768, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 10618) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 78, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 48.322, "Actual Total Time": 48.323, "Actual Rows": 11186, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 231) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 1, "Shared Read Blocks": 128, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 21.304, "Actual Total Time": 21.304, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 815) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 1, "Shared Read Blocks": 290, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 7.517, "Actual Total Time": 7.517, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 143) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 289, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 1.838, "Actual Total Time": 1.838, "Actual Rows": 6768, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 10610) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 71, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.027, "Actual Total Time": 0.028, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 12927) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.007, "Actual Total Time": 0.008, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 10546) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 7.183, "Actual Total Time": 7.184, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 213) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 258, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 8.231, "Actual Total Time": 8.231, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 214) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 3, "Shared Read Blocks": 256, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 23.968, "Actual Total Time": 23.968, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 364) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 256, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 2.865, "Actual Total Time": 2.865, "Actual Rows": 11186, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 710) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 114, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.011, "Actual Total Time": 0.012, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 13571) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.002, "Actual Total Time": 0.003, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 13575) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 13578) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_ID_JOUR_idx", "Startup Cost": 0.00, "Total Cost": 1.68, "Plan Rows": 1, "Plan Width": 0, "Actual Startup Time": 0.011, "Actual Total Time": 0.011, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_JOUR\" >= 4774) AND (t_2.\"ID_JOUR\" <= 4779))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.008, "Actual Total Time": 0.008, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 16289) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.005, "Actual Total Time": 0.006, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 16624) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 6.339, "Actual Total Time": 6.339, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 474) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 257, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 0.011, "Actual Total Time": 0.012, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 13582) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4740_pkey", "Startup Cost": 0.00, "Total Cost": 615.53, "Plan Rows": 16661, "Plan Width": 0, "Actual Startup Time": 6.411, "Actual Total Time": 6.411, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_2.\"ID_TRAIN\" = 843) AND (t_2.\"ID_JOUR\" >= 4688) AND (t_2.\"ID_JOUR\" <= 4779) AND (t_2.\"JX\" >= '-92'::integer) AND (t_2.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 257, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Member", "Parallel Aware": true, "Relation Name": "F_TDOJ_HIST_1_OLDP_p4710", "Schema": "partitionschema", "Alias": "t_1", "Startup Cost": 20437.45, "Total Cost": 530125.64, "Plan Rows": 120466, "Plan Width": 20, "Actual Startup Time": 4293.569, "Actual Total Time": 9020.326, "Actual Rows": 288016, "Actual Loops": 1, "Output": ["t_1.\"ID_JOUR\"", "t_1.\"ID_TRAIN\"", "t_1.\"JX\"", "t_1.\"DSP_CC4\"", "t_1.\"DSP_CC12\""], "Recheck Cond": "(((t_1.\"ID_TRAIN\" = 10547) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 12049) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 12401) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 11565) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 444) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 586) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 13576) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 13573) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 16288) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 16623) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_JOUR\" >= 4774) AND (t_1.\"ID_JOUR\" <= 4779)) OR ((t_1.\"ID_TRAIN\" = 585) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 10618) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 231) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 815) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 143) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 10610) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 12927) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 10546) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 213) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 214) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 364) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 710) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 13571) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 13575) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 13578) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_JOUR\" >= 4774) AND (t_1.\"ID_JOUR\" <= 4779)) OR ((t_1.\"ID_TRAIN\" = 16289) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 16624) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 474) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 13582) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)) OR ((t_1.\"ID_TRAIN\" = 843) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1)))", "Rows Removed by Index Recheck": 0, "Filter": "((t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1) AND (((t_1.\"ID_TRAIN\" = 10547) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 12049) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 12401) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 11565) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 444) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 586) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 13576) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 13573) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 16288) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 16623) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 17647) AND (t_1.\"ID_JOUR\" >= 4774)) OR ((t_1.\"ID_TRAIN\" = 585) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 10618) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 231) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 815) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 143) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 10610) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 12927) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 10546) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 213) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 214) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 364) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 710) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 13571) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 13575) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 13578) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 14522) AND (t_1.\"ID_JOUR\" >= 4774)) OR ((t_1.\"ID_TRAIN\" = 16289) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 16624) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 474) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 13582) AND (t_1.\"ID_JOUR\" >= 4688)) OR ((t_1.\"ID_TRAIN\" = 843) AND (t_1.\"ID_JOUR\" >= 4688))))", "Rows Removed by Filter": 0, "Exact Heap Blocks": 68068, "Lossy Heap Blocks": 0, "Shared Hit Blocks": 88, "Shared Read Blocks": 70884, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "BitmapOr", "Parent Relationship": "Outer", "Parallel Aware": false, "Startup Cost": 20437.45, "Total Cost": 20437.45, "Plan Rows": 485033, "Plan Width": 0, "Actual Startup Time": 4248.241, "Actual Total Time": 4248.265, "Actual Rows": 0, "Actual Loops": 1, "Shared Hit Blocks": 88, "Shared Read Blocks": 2816, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 4.082, "Actual Total Time": 4.082, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 10547) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 2.033, "Actual Total Time": 2.034, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 12049) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 2.230, "Actual Total Time": 2.230, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 12401) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 3, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 4.297, "Actual Total Time": 4.298, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 11565) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 251.308, "Actual Total Time": 251.309, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 444) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 3, "Shared Read Blocks": 244, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 243.331, "Actual Total Time": 243.332, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 586) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 246, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 4.620, "Actual Total Time": 4.620, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 13576) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 0.009, "Actual Total Time": 0.010, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 13573) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 1.967, "Actual Total Time": 1.967, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 16288) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 3, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 6.771, "Actual Total Time": 6.771, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 16623) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_ID_JOUR_idx", "Startup Cost": 0.00, "Total Cost": 1.68, "Plan Rows": 1, "Plan Width": 0, "Actual Startup Time": 0.056, "Actual Total Time": 0.056, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_JOUR\" >= 4774) AND (t_1.\"ID_JOUR\" <= 4779))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 252.478, "Actual Total Time": 252.478, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 585) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 245, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 84.045, "Actual Total Time": 84.045, "Actual Rows": 6768, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 10618) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 74, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 121.556, "Actual Total Time": 121.557, "Actual Rows": 10340, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 231) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 101, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 291.208, "Actual Total Time": 291.208, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 815) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 243, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 266.765, "Actual Total Time": 266.765, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 143) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 246, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 86.018, "Actual Total Time": 86.018, "Actual Rows": 6768, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 10610) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 74, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 4.470, "Actual Total Time": 4.470, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 12927) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 0.013, "Actual Total Time": 0.013, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 10546) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 283.445, "Actual Total Time": 283.446, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 213) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 245, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 267.145, "Actual Total Time": 267.145, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 214) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 3, "Shared Read Blocks": 245, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 1012.462, "Actual Total Time": 1012.462, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 364) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 246, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 183.376, "Actual Total Time": 183.376, "Actual Rows": 10340, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 710) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 101, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 0.030, "Actual Total Time": 0.031, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 13571) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 0.003, "Actual Total Time": 0.003, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 13575) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 0.002, "Actual Total Time": 0.003, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 13578) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_ID_JOUR_idx", "Startup Cost": 0.00, "Total Cost": 1.68, "Plan Rows": 1, "Plan Width": 0, "Actual Startup Time": 0.011, "Actual Total Time": 0.012, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_JOUR\" >= 4774) AND (t_1.\"ID_JOUR\" <= 4779))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 0.022, "Actual Total Time": 0.022, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 16289) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 0.006, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 16624) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 378.906, "Actual Total Time": 378.906, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 474) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 246, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 0.016, "Actual Total Time": 0.016, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 13582) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4710_pkey", "Startup Cost": 0.00, "Total Cost": 552.64, "Plan Rows": 16168, "Plan Width": 0, "Actual Startup Time": 495.522, "Actual Total Time": 495.522, "Actual Rows": 25380, "Actual Loops": 1, "Index Cond": "((t_1.\"ID_TRAIN\" = 843) AND (t_1.\"ID_JOUR\" >= 4688) AND (t_1.\"ID_JOUR\" <= 4779) AND (t_1.\"JX\" >= '-92'::integer) AND (t_1.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 246, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Member", "Parallel Aware": true, "Relation Name": "F_TDOJ_HIST_1_OLDP_p4680", "Schema": "partitionschema", "Alias": "t", "Startup Cost": 12968.84, "Total Cost": 435656.38, "Plan Rows": 101754, "Plan Width": 20, "Actual Startup Time": 314.091, "Actual Total Time": 1028.228, "Actual Rows": 216060, "Actual Loops": 1, "Output": ["t.\"ID_JOUR\"", "t.\"ID_TRAIN\"", "t.\"JX\"", "t.\"DSP_CC4\"", "t.\"DSP_CC12\""], "Recheck Cond": "(((t.\"ID_TRAIN\" = 10547) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 12049) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 12401) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 11565) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 444) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 586) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 13576) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 13573) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 16288) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 16623) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_JOUR\" >= 4774) AND (t.\"ID_JOUR\" <= 4779)) OR ((t.\"ID_TRAIN\" = 585) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 10618) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 231) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 815) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 143) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 10610) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 12927) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 10546) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 213) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 214) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 364) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 710) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 13571) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 13575) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 13578) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_JOUR\" >= 4774) AND (t.\"ID_JOUR\" <= 4779)) OR ((t.\"ID_TRAIN\" = 16289) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 16624) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 474) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 13582) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)) OR ((t.\"ID_TRAIN\" = 843) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1)))", "Rows Removed by Index Recheck": 0, "Filter": "((t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1) AND (((t.\"ID_TRAIN\" = 10547) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 12049) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 12401) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 11565) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 444) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 586) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 13576) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 13573) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 16288) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 16623) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 17647) AND (t.\"ID_JOUR\" >= 4774)) OR ((t.\"ID_TRAIN\" = 585) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 10618) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 231) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 815) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 143) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 10610) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 12927) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 10546) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 213) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 214) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 364) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 710) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 13571) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 13575) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 13578) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 14522) AND (t.\"ID_JOUR\" >= 4774)) OR ((t.\"ID_TRAIN\" = 16289) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 16624) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 474) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 13582) AND (t.\"ID_JOUR\" >= 4688)) OR ((t.\"ID_TRAIN\" = 843) AND (t.\"ID_JOUR\" >= 4688))))", "Rows Removed by Filter": 0, "Exact Heap Blocks": 19413, "Lossy Heap Blocks": 0, "Shared Hit Blocks": 83, "Shared Read Blocks": 20385, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "BitmapOr", "Parent Relationship": "Outer", "Parallel Aware": false, "Startup Cost": 12968.84, "Total Cost": 12968.84, "Plan Rows": 409279, "Plan Width": 0, "Actual Startup Time": 303.575, "Actual Total Time": 303.600, "Actual Rows": 0, "Actual Loops": 1, "Shared Hit Blocks": 83, "Shared Read Blocks": 972, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 4.223, "Actual Total Time": 4.224, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 10547) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 4.473, "Actual Total Time": 4.473, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 12049) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 2.339, "Actual Total Time": 2.339, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 12401) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 4.506, "Actual Total Time": 4.507, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 11565) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 33.454, "Actual Total Time": 33.454, "Actual Rows": 18612, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 444) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 82, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 18.792, "Actual Total Time": 18.792, "Actual Rows": 18612, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 586) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 82, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 4.020, "Actual Total Time": 4.020, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 13576) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 0.009, "Actual Total Time": 0.010, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 13573) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 4.891, "Actual Total Time": 4.892, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 16288) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 8.466, "Actual Total Time": 8.466, "Actual Rows": 1998, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 16623) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 9, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_ID_JOUR_idx", "Startup Cost": 0.00, "Total Cost": 1.68, "Plan Rows": 1, "Plan Width": 0, "Actual Startup Time": 0.052, "Actual Total Time": 0.052, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_JOUR\" >= 4774) AND (t.\"ID_JOUR\" <= 4779))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 15.622, "Actual Total Time": 15.623, "Actual Rows": 18612, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 585) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 3, "Shared Read Blocks": 81, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 12.112, "Actual Total Time": 12.112, "Actual Rows": 5922, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 10618) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 28, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 12.238, "Actual Total Time": 12.238, "Actual Rows": 7050, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 231) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 32, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 20.546, "Actual Total Time": 20.546, "Actual Rows": 18612, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 815) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 82, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 17.037, "Actual Total Time": 17.037, "Actual Rows": 18612, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 143) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 82, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 26.077, "Actual Total Time": 26.077, "Actual Rows": 5922, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 10610) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 28, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 5.125, "Actual Total Time": 5.125, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 12927) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 0.012, "Actual Total Time": 0.012, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 10546) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 17.248, "Actual Total Time": 17.249, "Actual Rows": 18612, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 213) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 82, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 10.666, "Actual Total Time": 10.666, "Actual Rows": 18612, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 214) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 82, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 18.476, "Actual Total Time": 18.476, "Actual Rows": 18612, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 364) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 82, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 14.285, "Actual Total Time": 14.285, "Actual Rows": 7050, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 710) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 32, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 0.014, "Actual Total Time": 0.014, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 13571) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 0.003, "Actual Total Time": 0.003, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 13575) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 0.002, "Actual Total Time": 0.003, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 13578) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_ID_JOUR_idx", "Startup Cost": 0.00, "Total Cost": 1.68, "Plan Rows": 1, "Plan Width": 0, "Actual Startup Time": 0.010, "Actual Total Time": 0.010, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_JOUR\" >= 4774) AND (t.\"ID_JOUR\" <= 4779))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 16289) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 0.370, "Actual Total Time": 0.370, "Actual Rows": 1998, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 16624) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 10, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 16.564, "Actual Total Time": 16.565, "Actual Rows": 18612, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 474) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 82, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 0.013, "Actual Total Time": 0.014, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 13582) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4680_pkey", "Startup Cost": 0.00, "Total Cost": 323.65, "Plan Rows": 13643, "Plan Width": 0, "Actual Startup Time": 31.887, "Actual Total Time": 31.887, "Actual Rows": 18612, "Actual Loops": 1, "Index Cond": "((t.\"ID_TRAIN\" = 843) AND (t.\"ID_JOUR\" >= 4688) AND (t.\"ID_JOUR\" <= 4779) AND (t.\"JX\" >= '-92'::integer) AND (t.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 82, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Member", "Parallel Aware": true, "Relation Name": "F_TDOJ_HIST_1_OLDP_p4770", "Schema": "partitionschema", "Alias": "t_3", "Startup Cost": 7670.07, "Total Cost": 218504.83, "Plan Rows": 48037, "Plan Width": 20, "Actual Startup Time": 93.724, "Actual Total Time": 1225.005, "Actual Rows": 102156, "Actual Loops": 1, "Output": ["t_3.\"ID_JOUR\"", "t_3.\"ID_TRAIN\"", "t_3.\"JX\"", "t_3.\"DSP_CC4\"", "t_3.\"DSP_CC12\""], "Recheck Cond": "(((t_3.\"ID_TRAIN\" = 10547) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 12049) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 12401) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 11565) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 444) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 586) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 13576) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 13573) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 16288) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 16623) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 17647) AND (t_3.\"ID_JOUR\" >= 4774) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 585) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 10618) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 231) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 815) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 143) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 10610) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 12927) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 10546) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 213) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 214) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 364) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 710) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 13571) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 13575) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 13578) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 14522) AND (t_3.\"ID_JOUR\" >= 4774) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 16289) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 16624) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 474) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 13582) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)) OR ((t_3.\"ID_TRAIN\" = 843) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1)))", "Rows Removed by Index Recheck": 0, "Exact Heap Blocks": 57006, "Lossy Heap Blocks": 0, "Shared Hit Blocks": 74, "Shared Read Blocks": 57987, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "BitmapOr", "Parent Relationship": "Outer", "Parallel Aware": false, "Startup Cost": 7670.07, "Total Cost": 7670.07, "Plan Rows": 190550, "Plan Width": 0, "Actual Startup Time": 71.568, "Actual Total Time": 71.594, "Actual Rows": 0, "Actual Loops": 1, "Shared Hit Blocks": 74, "Shared Read Blocks": 981, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 6.168, "Actual Total Time": 6.168, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 10547) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 0, "Shared Read Blocks": 4, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 2.234, "Actual Total Time": 2.235, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 12049) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 1, "Shared Read Blocks": 3, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.034, "Actual Total Time": 0.034, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 12401) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.028, "Actual Total Time": 0.028, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 11565) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 5.829, "Actual Total Time": 5.829, "Actual Rows": 8460, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 444) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 1, "Shared Read Blocks": 90, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 3.616, "Actual Total Time": 3.616, "Actual Rows": 8460, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 586) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 1, "Shared Read Blocks": 88, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 4.151, "Actual Total Time": 4.152, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 13576) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.009, "Actual Total Time": 0.010, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 13573) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 2.253, "Actual Total Time": 2.253, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 16288) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 1, "Shared Read Blocks": 3, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.020, "Actual Total Time": 0.021, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 16623) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 3, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 121.57, "Plan Rows": 3756, "Plan Width": 0, "Actual Startup Time": 0.211, "Actual Total Time": 0.211, "Actual Rows": 600, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 17647) AND (t_3.\"ID_JOUR\" >= 4774) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 1, "Shared Read Blocks": 8, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 4.977, "Actual Total Time": 4.978, "Actual Rows": 8460, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 585) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 86, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 2.717, "Actual Total Time": 2.718, "Actual Rows": 7614, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 10618) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 77, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.178, "Actual Total Time": 0.179, "Actual Rows": 564, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 231) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 7, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 2.596, "Actual Total Time": 2.597, "Actual Rows": 8460, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 815) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 87, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 5.709, "Actual Total Time": 5.709, "Actual Rows": 8460, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 143) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 87, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 2.465, "Actual Total Time": 2.465, "Actual Rows": 7614, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 10610) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 65, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.034, "Actual Total Time": 0.035, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 12927) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 2, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.010, "Actual Total Time": 0.010, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 10546) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 2.459, "Actual Total Time": 2.459, "Actual Rows": 8460, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 213) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 72, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 2.395, "Actual Total Time": 2.395, "Actual Rows": 8460, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 214) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 69, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 2.722, "Actual Total Time": 2.722, "Actual Rows": 8460, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 364) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 71, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.343, "Actual Total Time": 0.343, "Actual Rows": 564, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 710) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 7, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.013, "Actual Total Time": 0.014, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 13571) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.003, "Actual Total Time": 0.004, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 13575) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.077, "Actual Total Time": 0.077, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 13578) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 121.57, "Plan Rows": 3756, "Plan Width": 0, "Actual Startup Time": 0.265, "Actual Total Time": 0.265, "Actual Rows": 600, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 14522) AND (t_3.\"ID_JOUR\" >= 4774) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 7, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.010, "Actual Total Time": 0.011, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 16289) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.006, "Actual Total Time": 0.006, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 16624) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 2.734, "Actual Total Time": 2.735, "Actual Rows": 8460, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 474) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 71, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 0.015, "Actual Total Time": 0.015, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 13582) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "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 }, { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Index Name": "F_TDOJ_HIST_1_OLDP_p4770_pkey", "Startup Cost": 0.00, "Total Cost": 196.33, "Plan Rows": 6101, "Plan Width": 0, "Actual Startup Time": 17.263, "Actual Total Time": 17.263, "Actual Rows": 8460, "Actual Loops": 1, "Index Cond": "((t_3.\"ID_TRAIN\" = 843) AND (t_3.\"ID_JOUR\" >= 4688) AND (t_3.\"ID_JOUR\" <= 4779) AND (t_3.\"JX\" >= '-92'::integer) AND (t_3.\"JX\" <= 1))", "Shared Hit Blocks": 2, "Shared Read Blocks": 70, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": true, "Startup Cost": 16631.70, "Total Cost": 16631.70, "Plan Rows": 100964, "Plan Width": 8, "Actual Startup Time": 4074.333, "Actual Total Time": 4074.335, "Actual Rows": 314346, "Actual Loops": 1, "Output": ["dcd.\"ID_JOUR\"", "dcd.\"JX\""], "Hash Buckets": 524288, "Original Hash Buckets": 524288, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 16416, "Shared Hit Blocks": 3086, "Shared Read Blocks": 888, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Outer", "Parallel Aware": true, "Relation Name": "DL_CAPTURE_DATE", "Schema": "public", "Alias": "dcd", "Startup Cost": 4525.24, "Total Cost": 16631.70, "Plan Rows": 100964, "Plan Width": 8, "Actual Startup Time": 3902.033, "Actual Total Time": 3960.254, "Actual Rows": 314346, "Actual Loops": 1, "Output": ["dcd.\"ID_JOUR\"", "dcd.\"JX\""], "Recheck Cond": "((dcd.\"CAPTURE_DATE\" >= '2023-06-01'::date) AND (dcd.\"CAPTURE_DATE\" <= '2024-01-02'::date))", "Rows Removed by Index Recheck": 0, "Exact Heap Blocks": 3085, "Lossy Heap Blocks": 0, "Shared Hit Blocks": 3086, "Shared Read Blocks": 888, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Index Name": "DL_CAPTURE_DATE_ix", "Startup Cost": 0.00, "Total Cost": 4447.00, "Plan Rows": 312987, "Plan Width": 0, "Actual Startup Time": 722.561, "Actual Total Time": 722.562, "Actual Rows": 314346, "Actual Loops": 1, "Index Cond": "((dcd.\"CAPTURE_DATE\" >= '2023-06-01'::date) AND (dcd.\"CAPTURE_DATE\" <= '2024-01-02'::date))", "Shared Hit Blocks": 1, "Shared Read Blocks": 888, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] } ] }, "Planning Time": 1765.183, "Triggers": [ ], "JIT": { "Worker Number": -1, "Functions": 33, "Options": { "Inlining": true, "Optimization": true, "Expressions": true, "Deforming": true }, "Timing": { "Generation": 26.386, "Inlining": 67.508, "Optimization": 1753.424, "Emission": 1356.253, "Total": 3203.571 } }, "Execution Time": 18347.163 } ]