"Limit  (cost=7503.83..7503.83 rows=1 width=59) (actual time=1036.800..1036.895 rows=10 loops=1)"
"  ->  Sort  (cost=7503.83..7503.83 rows=1 width=59) (actual time=1036.793..1036.827 rows=10 loops=1)"
"        Sort Key: max(tag.tag_date)"
"        ->  HashAggregate  (cost=7503.81..7503.82 rows=1 width=59) (actual time=1036.290..1036.521 rows=58 loops=1)"
"              ->  Nested Loop  (cost=0.00..7503.80 rows=1 width=59) (actual time=68.636..1035.916 rows=58 loops=1)"
"                    ->  Nested Loop  (cost=0.00..7500.75 rows=1 width=12) (actual time=68.606..1034.135 rows=58 loops=1)"
"                          ->  Index Scan using uniq_user_app_idx on user_app  (cost=0.00..4.32 rows=1 width=4) (actual time=0.025..0.165 rows=15 loops=1)"
"                                Index Cond: (usr_app_brand = 1)"
"                          ->  Index Scan using tag_idx on tag  (cost=0.00..7496.42 rows=1 width=16) (actual time=55.304..68.886 rows=4 loops=15)"
"                                Index Cond: (tag.tag_user_app_id = "outer".usr_app_id)"
"                                Filter: (tag_idx @@ '''google'''::tsquery)"
"                    ->  Index Scan using pk_tag_id on "object"  (cost=0.00..3.04 rows=1 width=55) (actual time=0.010..0.014 rows=1 loops=58)"
"                          Index Cond: ("outer".tag_obj_id = "object".obj_id)"
"Total runtime: 1037.055 ms"

"Limit  (cost=7996.12..7996.13 rows=1 width=59) (actual time=1060.173..1060.270 rows=10 loops=1)"
"  ->  Sort  (cost=7996.12..7996.13 rows=1 width=59) (actual time=1060.164..1060.198 rows=10 loops=1)"
"        Sort Key: max(tag.tag_date)"
"        ->  HashAggregate  (cost=7996.10..7996.11 rows=1 width=59) (actual time=1059.660..1059.880 rows=58 loops=1)"
"              ->  Nested Loop  (cost=7056.01..7996.09 rows=1 width=59) (actual time=168.419..1059.303 rows=58 loops=1)"
"                    ->  Nested Loop  (cost=7054.01..7990.07 rows=1 width=12) (actual time=168.367..1056.983 rows=58 loops=1)"
"                          ->  Bitmap Heap Scan on user_app  (cost=2.00..6.01 rows=1 width=4) (actual time=0.060..0.147 rows=15 loops=1)"
"                                Recheck Cond: (usr_app_brand = 1)"
"                                ->  Bitmap Index Scan on uniq_user_app_idx  (cost=0.00..2.00 rows=1 width=0) (actual time=0.046..0.046 rows=15 loops=1)"
"                                      Index Cond: (usr_app_brand = 1)"
"                          ->  Bitmap Heap Scan on tag  (cost=7052.01..7980.98 rows=246 width=16) (actual time=70.360..70.410 rows=4 loops=15)"
"                                Recheck Cond: (tag.tag_user_app_id = "outer".usr_app_id)"
"                                Filter: (tag_idx @@ '''google'''::tsquery)"
"                                ->  Bitmap Index Scan on tag_idx  (cost=0.00..7052.01 rows=246 width=0) (actual time=70.105..70.105 rows=292 loops=15)"
"                                      Index Cond: (tag.tag_user_app_id = "outer".usr_app_id)"
"                    ->  Bitmap Heap Scan on "object"  (cost=2.00..6.01 rows=1 width=55) (actual time=0.019..0.023 rows=1 loops=58)"
"                          Recheck Cond: ("outer".tag_obj_id = "object".obj_id)"
"                          ->  Bitmap Index Scan on pk_tag_id  (cost=0.00..2.00 rows=1 width=0) (actual time=0.010..0.010 rows=1 loops=58)"
"                                Index Cond: ("outer".tag_obj_id = "object".obj_id)"
"Total runtime: 1060.488 ms"

"Limit  (cost=84723.38..84723.39 rows=1 width=59)"
"  ->  Sort  (cost=84723.38..84723.39 rows=1 width=59)"
"        Sort Key: max(tag.tag_date)"
"        ->  HashAggregate  (cost=84723.36..84723.38 rows=1 width=59)"
"              ->  Nested Loop  (cost=56373.33..84723.36 rows=1 width=59)"
"                    Join Filter: ("inner".tag_user_app_id = "outer".usr_app_id)"
"                    ->  Seq Scan on user_app  (cost=0.00..952.15 rows=1 width=4)"
"                          Filter: (usr_app_brand = 1)"
"                    ->  Hash Join  (cost=56373.33..83758.24 rows=1037 width=63)"
"                          Hash Cond: ("outer".obj_id = "inner".tag_obj_id)"
"                          ->  Seq Scan on "object"  (cost=0.00..22190.03 rows=1036903 width=55)"
"                          ->  Hash  (cost=56370.74..56370.74 rows=1037 width=16)"
"                                ->  Seq Scan on tag  (cost=0.00..56370.74 rows=1037 width=16)"
"                                      Filter: (tag_idx @@ '''google'''::tsquery)"