{"QUERY PLAN"=>"Nested Loop (cost=6757280.63..6757297.74 rows=1 width=261)"}, 
{"QUERY PLAN"=>" -> Nested Loop (cost=6757280.36..6757289.41 rows=1 width=197)"}, 
{"QUERY PLAN"=>"-> Index Scan using notifications_pkey on notifications t1 (cost=0.56..8.58 rows=1 width=201)"}, 
{"QUERY PLAN"=>" Index Cond: (id = 24279446)"},
 {"QUERY PLAN"=>"-> Merge Join (cost=6757279.79..6757280.81 rows=1 width=16)"}, 
{"QUERY PLAN"=>" Merge Cond: (notification_processing_rules.id = \"ANY_subquery\".id)"}, 
{"QUERY PLAN"=>" -> Sort (cost=8.46..8.47 rows=1 width=16)"}, 
{"QUERY PLAN"=>" Sort Key: notification_processing_rules.id"},
{"QUERY PLAN"=>" -> Index Scan using index_notification_processing_rules_on_notification_id on notification_processing_rules (cost=0.44..8.46 rows=1 width=16)"}, 
{"QUERY PLAN"=>" Index Cond: (notification_id = 24279446)"}, 
{"QUERY PLAN"=>" -> Sort (cost=6757271.33..6757271.83 rows=200 width=8)"}, 
{"QUERY PLAN"=>" Sort Key: \"ANY_subquery\".id"}, 
{"QUERY PLAN"=>" -> HashAggregate (cost=6757261.69..6757263.69 rows=200 width=8)"}, 
{"QUERY PLAN"=>" Group Key: \"ANY_subquery\".id"}, 
{"QUERY PLAN"=>" -> Subquery Scan on \"ANY_subquery\" (cost=6084620.71..6706695.72 rows=20226386 width=8)"}, 
{"QUERY PLAN"=>"-> GroupAggregate (cost=6084620.71..6504431.86 rows=20226386 width=12)"}, 
{"QUERY PLAN"=>" Group Key: notification_processing_rules_1.notification_id"}, 
{"QUERY PLAN"=>" -> Sort (cost=6084620.71..6157136.48 rows=29006305 width=12)"}, 
{"QUERY PLAN"=>" Sort Key: notification_processing_rules_1.notification_id"}, 
{"QUERY PLAN"=>" -> Seq Scan on notification_processing_rules notification_processing_rules_1 (cost=0.00..506447.05 rows=29006305 width=12)"}, 
{"QUERY PLAN"=>" -> Index Scan using notifications_rules_pkey on notifications_rules t3 (cost=0.27..8.29 rows=1 width=79)"}, 
{"QUERY PLAN"=>"Index Cond: (id = notification_processing_rules.rule_id)"}