rendered paste body"Limit (cost=14.71..14.71 rows=1 width=49) (actual time=10996.508..10996.510 rows=1 loops=1)"
" -> Sort (cost=14.71..14.71 rows=1 width=49) (actual time=10996.503..10996.503 rows=1 loops=1)"
" Sort Key: upper(categories.name), categories.name, teasers0.number"
" -> Nested Loop (cost=0.00..14.70 rows=1 width=49) (actual time=3042.680..10996.480 rows=1 loops=1)"
" -> Nested Loop (cost=0.00..13.98 rows=2 width=53) (actual time=2.202..5901.361 rows=71935 loops=1)"
" -> Nested Loop (cost=0.00..13.38 rows=2 width=49) (actual time=2.156..789.160 rows=71935 loops=1)"
" -> Nested Loop (cost=0.00..6.38 rows=1 width=45) (actual time=2.040..2.057 rows=1 loops=1)"
" -> Index Scan using teasers_pkey on teasers teasers0 (cost=0.00..5.27 rows=1 width=4) (actual time=0.085..0.089 rows=1 loops=1)"
" Index Cond: (number = 700009)"
" -> Seq Scan on categories categories (cost=0.00..1.10 rows=1 width=41) (actual time=1.950..1.960 rows=1 loops=1)"
" Filter: (name = 'kl'::text)"
" -> Index Scan using i2 on relate relate0 (cost=0.00..6.98 rows=2 width=8) (actual time=0.113..622.752 rows=71935 loops=1)"
" Index Cond: (categories.number = relate0.dst)"
" -> Index Scan using images_pkey on images images (cost=0.00..0.29 rows=1 width=4) (actual time=0.064..0.066 rows=1 loops=71935)"
" Index Cond: (images.number = relate0.src)"
" -> Index Scan using i2 on relate relate (cost=0.00..0.34 rows=1 width=8) (actual time=0.069..0.069 rows=0 loops=71935)"
" Index Cond: (images.number = relate.dst)"
" Filter: (src = 700009)"
"Total runtime: 10996.669 ms"