rendered paste body"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)"