{
'estimated_row_width' => '81',
'estimated_rows' => '11787',
'estimated_startup_cost' => '11787.13',
'estimated_total_cost' => '12081.81',
'is_analyzed' => 0,
'sub_nodes' => [
{
'estimated_row_width' => '81',
'estimated_rows' => '11787',
'estimated_startup_cost' => '11787.13',
'estimated_total_cost' => '11816.6',
'extra_info' => [
'Sort Key: t.user_id, i.email, t.enabled, t.admin, t.abonnement, t.actu, t.first_sbsc, t.thematique, t.creation_date'
],
'is_analyzed' => 0,
'sub_nodes' => [
{
'estimated_row_width' => '81',
'estimated_rows' => '11787',
'estimated_startup_cost' => '4303.35',
'estimated_total_cost' => '10423.04',
'extra_info' => [
'Hash Cond: ((acl.account_id)::text = (s.account_id)::text)',
'Filter: (s.account_id IS NULL)'
],
'is_analyzed' => 0,
'sub_nodes' => [
{
'estimated_row_width' => '92',
'estimated_rows' => '12330',
'estimated_startup_cost' => '2671.24',
'estimated_total_cost' => '6316.24',
'is_analyzed' => 0,
'sub_nodes' => [
{
'estimated_row_width' => '91',
'estimated_rows' => '5042',
'estimated_startup_cost' => '2671.24',
'estimated_total_cost' => '3742.1',
'extra_info' => [
'Hash Cond: ((u.id)::text = (t.user_id)::text)'
],
'is_analyzed' => 0,
'sub_nodes' => [
{
'estimated_row_width' => '33',
'estimated_rows' => '5042',
'estimated_startup_cost' => '1422.12',
'estimated_total_cost' => '2047.04',
'extra_info' => [
'Hash Cond: ((i.email)::text = (u.email)::text)'
],
'is_analyzed' => 0,
'sub_nodes' => [
{
'estimated_row_width' => '23',
'estimated_rows' => '5042',
'estimated_startup_cost' => '0',
'estimated_total_cost' => '266.42',
'is_analyzed' => 0,
'scan_on' => {
'table_alias' => 'i',
'table_name' => 'inrq_information_request'
},
'type' => 'Seq Scan'
},
{
'estimated_row_width' => '37',
'estimated_rows' => '26361',
'estimated_startup_cost' => '886.61',
'estimated_total_cost' => '886.61',
'is_analyzed' => 0,
'sub_nodes' => [
{
'estimated_row_width' => '37',
'estimated_rows' => '26361',
'estimated_startup_cost' => '0',
'estimated_total_cost' => '886.61',
'is_analyzed' => 0,
'scan_on' => {
'table_alias' => 'u',
'table_name' => 'sbsc_user'
},
'type' => 'Seq Scan'
}
],
'type' => 'Hash'
}
],
'type' => 'Hash Left Join'
},
{
'estimated_row_width' => '58',
'estimated_rows' => '26361',
'estimated_startup_cost' => '635.61',
'estimated_total_cost' => '635.61',
'is_analyzed' => 0,
'sub_nodes' => [
{
'estimated_row_width' => '58',
'estimated_rows' => '26361',
'estimated_startup_cost' => '0',
'estimated_total_cost' => '635.61',
'is_analyzed' => 0,
'scan_on' => {
'table_alias' => 't',
'table_name' => 'talend_users'
},
'type' => 'Seq Scan'
}
],
'type' => 'Hash'
}
],
'type' => 'Hash Left Join'
},
{
'estimated_row_width' => '21',
'estimated_rows' => '3',
'estimated_startup_cost' => '0',
'estimated_total_cost' => '0.47',
'extra_info' => [
'Index Cond: ((u.id)::text = (acl.user_id)::text)'
],
'is_analyzed' => 0,
'scan_on' => {
'index_name' => 'ix_sbscaccntacl_usrid',
'table_alias' => 'acl',
'table_name' => 'sbsc_account_acl'
},
'type' => 'Index Scan'
}
],
'type' => 'Nested Loop Left Join'
},
{
'estimated_row_width' => '11',
'estimated_rows' => '40227',
'estimated_startup_cost' => '932.27',
'estimated_total_cost' => '932.27',
'is_analyzed' => 0,
'sub_nodes' => [
{
'estimated_row_width' => '11',
'estimated_rows' => '40227',
'estimated_startup_cost' => '0',
'estimated_total_cost' => '932.27',
'is_analyzed' => 0,
'scan_on' => {
'table_alias' => 's',
'table_name' => 'sbsc_subscription'
},
'type' => 'Seq Scan'
}
],
'type' => 'Hash'
}
],
'type' => 'Hash Left Join'
}
],
'type' => 'Sort'
}
],
'type' => 'Unique'
}