{
'type' => 'Index Scan',
'estimated_startup_cost' => 30,
'estimated_total_cost' => 34.33,
'estimated_rows' => 1,
'estimated_row_width' => 40,
'extra_info' => [
'Index Cond: (e.id_contact_event = CASE WHEN (("outer".client_status_cc = 2) AND ("outer".client_status_unit = 2) AND ("outer".id_employee_responsible IS NULL) AND ("outer".id_unit_responsible IS NULL)) THEN (subplan) ELSE "outer".latest_event END)',
],
'actual_time_first' => 0.003,
'actual_time_last' => 0.003,
'actual_rows' => 1,
'actual_loops' => 19499,
'is_analyzed' => 1,
'scan_on' => {
'table_name' => 'of_contact_event',
'index_name' => 'id_contact_event_idx',
'table_alias' => 'e',
},
'subplans' => [
{
'type' => 'Limit',
'estimated_startup_cost' => 29.99,
'estimated_total_cost' => 30,
'estimated_rows' => 1,
'estimated_row_width' => 19,
'actual_time_first' => 0.018,
'actual_time_last' => 0.018,
'actual_rows' => 1,
'actual_loops' => 5570,
'is_analyzed' => 1,
'sub_nodes' => [
{
'type' => 'Sort',
'estimated_startup_cost' => 29.99,
'estimated_total_cost' => 30,
'estimated_rows' => 4,
'estimated_row_width' => 19,
'actual_time_first' => 0.018,
'actual_time_last' => 0.018,
'actual_rows' => 1,
'actual_loops' => 5570,
'is_analyzed' => 1,
'extra_info' => [ 'Sort Key: status, date_registration, visit', ],
'sub_nodes' => [
{
'type' => 'Index Scan',
'estimated_startup_cost' => 0,
'estimated_total_cost' => 29.95,
'estimated_rows' => 4,
'estimated_row_width' => 19,
'extra_info' => [
'Index Cond: (id_contact_client = $0)', 'Filter: (id_contact_event < $1)',
],
'actual_time_first' => 0.006,
'actual_time_last' => 0.012,
'actual_rows' => 6,
'actual_loops' => 5570,
'is_analyzed' => 1,
'scan_on' => {
'table_name' => 'of_contact_event',
'index_name' => 'idx_of_contact_event_id_contact_client',
'table_alias' => 'ev2',
},
},
],
}
],
},
{
'type' => 'Limit',
'estimated_startup_cost' => 29.99,
'estimated_total_cost' => 30,
'estimated_rows' => 1,
'estimated_row_width' => 19,
'actual_loops' => 0,
'is_analyzed' => 1,
'sub_nodes' => [
{
'type' => 'Sort',
'estimated_startup_cost' => 29.99,
'estimated_total_cost' => 30,
'estimated_rows' => 4,
'estimated_row_width' => 19,
'actual_loops' => 0,
'is_analyzed' => 1,
'extra_info' => [ 'Sort Key: status, date_registration, visit', ],
'sub_nodes' => [
{
'type' => 'Index Scan',
'estimated_startup_cost' => 0,
'estimated_total_cost' => 29.95,
'estimated_rows' => 4,
'estimated_row_width' => 19,
'extra_info' => [
'Index Cond: (id_contact_client = $0)', 'Filter: (id_contact_event < $1)',
],
'actual_loops' => 0,
'is_analyzed' => 1,
'scan_on' => {
'table_name' => 'of_contact_event',
'index_name' => 'idx_of_contact_event_id_contact_client',
'table_alias' => 'ev2',
},
},
],
}
],
},
]
}