1.15.0
Execution time:
2m 59s
Planning time:
142ms
Triggers: N/A
| #1 | Nested Loop | |
| #2 | ├ Nested Loop | |
| #3 | │├ Index Scan | |
| #4 | │└ Bitmap Heap Scan | |
| #5 | │ └ Bitmap Index Scan | |
| #6 | └ Index Scan |
{
"Plan": {
"Node Type": "Nested Loop",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 2.64,
"Total Cost": 30369.52,
"Plan Rows": 53522,
"Plan Width": 28,
"Actual Startup Time": 48.593,
"Actual Total Time": 179891.402,
"Actual Rows": 309009,
"Actual Loops": 1,
"Output": [
"fth.\"ID_TRAIN\"",
"fth.\"ID_JOUR\"",
"fth.\"JX\"",
"fth.\"ID_LEG\"",
"fth.\"RES\"",
"fth.\"REV\""
],
"Inner Unique": false,
"Shared Hit Blocks": 59451,
"Shared Read Blocks": 69290,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"I/O Read Time": 178649.857,
"I/O Write Time": 0.0,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 2.07,
"Total Cost": 60.13,
"Plan Rows": 35,
"Plan Width": 4,
"Actual Startup Time": 0.153,
"Actual Total Time": 1.94,
"Actual Rows": 272,
"Actual Loops": 1,
"Output": [
"\"D_TRAIN\".\"ID_TRAIN\""
],
"Inner Unique": false,
"Shared Hit Blocks": 71,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"I/O Read Time": 0.0,
"I/O Write Time": 0.0,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "UX_ENTNAT",
"Relation Name": "D_ENTNAT",
"Schema": "public",
"Alias": "D_ENTNAT",
"Startup Cost": 0.27,
"Total Cost": 2.49,
"Plan Rows": 1,
"Plan Width": 4,
"Actual Startup Time": 0.074,
"Actual Total Time": 0.076,
"Actual Rows": 1,
"Actual Loops": 1,
"Output": [
"\"D_ENTNAT\".\"ID_ENTNAT\"",
"\"D_ENTNAT\".\"ENTITY_NATURE_ID\"",
"\"D_ENTNAT\".\"AXE\"",
"\"D_ENTNAT\".\"ENTITY\"",
"\"D_ENTNAT\".\"NATURE\"",
"\"D_ENTNAT\".\"NATURE_TYPE\"",
"\"D_ENTNAT\".\"ROUTE_ID\"",
"\"D_ENTNAT\".\"ROUTE\"",
"\"D_ENTNAT\".\"RELA\"",
"\"D_ENTNAT\".\"RELAssRELA\"",
"\"D_ENTNAT\".\"OFFRE_CO\"",
"\"D_ENTNAT\".\"OFFRE_TYPE\"",
"\"D_ENTNAT\".\"TERRITOIRE\"",
"\"D_ENTNAT\".\"PARITY\"",
"\"D_ENTNAT\".\"FLAG_ACTIF\"",
"\"D_ENTNAT\".\"FLAG_IS\"",
"\"D_ENTNAT\".\"ROUTE_SENS\""
],
"Index Cond": "((\"D_ENTNAT\".\"ENTITY\")::text = 'LOIREPARIS'::text)",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 3,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"I/O Read Time": 0.0,
"I/O Write Time": 0.0
},
{
"Node Type": "Bitmap Heap Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Relation Name": "D_TRAIN",
"Schema": "public",
"Alias": "D_TRAIN",
"Startup Cost": 1.8,
"Total Cost": 57.11,
"Plan Rows": 53,
"Plan Width": 8,
"Actual Startup Time": 0.074,
"Actual Total Time": 1.574,
"Actual Rows": 272,
"Actual Loops": 1,
"Output": [
"\"D_TRAIN\".\"ID_TRAIN\"",
"\"D_TRAIN\".\"ID_ENTNAT\"",
"\"D_TRAIN\".\"ID_OD_TRAIN\"",
"\"D_TRAIN\".\"TRAIN_NO\"",
"\"D_TRAIN\".\"TRAIN_NO_BIS\"",
"\"D_TRAIN\".\"ID_ITINERAIRE\""
],
"Recheck Cond": "(\"D_TRAIN\".\"ID_ENTNAT\" = \"D_ENTNAT\".\"ID_ENTNAT\")",
"Rows Removed by Index Recheck": 0,
"Exact Heap Blocks": 65,
"Lossy Heap Blocks": 0,
"Shared Hit Blocks": 68,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"I/O Read Time": 0.0,
"I/O Write Time": 0.0,
"Plans": [
{
"Node Type": "Bitmap Index Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Index Name": "fki_D_TRAIN_ID_ENTNAT_fkey",
"Startup Cost": 0.0,
"Total Cost": 1.78,
"Plan Rows": 53,
"Plan Width": 0,
"Actual Startup Time": 0.039,
"Actual Total Time": 0.039,
"Actual Rows": 272,
"Actual Loops": 1,
"Index Cond": "(\"D_TRAIN\".\"ID_ENTNAT\" = \"D_ENTNAT\".\"ID_ENTNAT\")",
"Shared Hit Blocks": 3,
"Shared Read Blocks": 0,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"I/O Read Time": 0.0,
"I/O Write Time": 0.0
}
]
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "F_TDLJ_HIST_p4680_pkey",
"Relation Name": "F_TDLJ_HIST_p4680",
"Schema": "partitionschema",
"Alias": "fth",
"Startup Cost": 0.57,
"Total Cost": 740.91,
"Plan Rows": 12507,
"Plan Width": 28,
"Actual Startup Time": 4.831,
"Actual Total Time": 660.942,
"Actual Rows": 1136,
"Actual Loops": 272,
"Output": [
"fth.\"ID_TRAIN\"",
"fth.\"ID_JOUR\"",
"fth.\"JX\"",
"fth.\"ID_LEG\"",
"fth.\"RES\"",
"fth.\"REV\""
],
"Index Cond": "((fth.\"ID_TRAIN\" = \"D_TRAIN\".\"ID_TRAIN\") AND (fth.\"ID_JOUR\" >= 4700) AND (fth.\"ID_JOUR\" <= 4750) AND (fth.\"JX\" >= '-92'::integer) AND (fth.\"JX\" <= 1))",
"Rows Removed by Index Recheck": 0,
"Shared Hit Blocks": 59380,
"Shared Read Blocks": 69290,
"Shared Dirtied Blocks": 0,
"Shared Written Blocks": 0,
"Local Hit Blocks": 0,
"Local Read Blocks": 0,
"Local Dirtied Blocks": 0,
"Local Written Blocks": 0,
"Temp Read Blocks": 0,
"Temp Written Blocks": 0,
"I/O Read Time": 178649.857,
"I/O Write Time": 0.0
}
]
},
"Planning Time": 141.837,
"Triggers": [],
"Execution Time": 179937.444
}