explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tt9Q

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=146.53..146.58 rows=20 width=48) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=146.53..148.52 rows=795 width=48) (actual rows= loops=)

  • Sort Key: content.post_created_at DESC
3. 0.000 0.000 ↓ 0.0

Append (cost=0.00..125.38 rows=795 width=48) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on content (cost=0.00..99.36 rows=754 width=48) (actual rows= loops=)

  • Filter: (post_created_at < now())
5. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=0.00..0.39 rows=1 width=48) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..0.38 rows=1 width=44) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on questions (cost=0.00..2.63 rows=7 width=44) (actual rows= loops=)

  • Filter: ((NOT answered) AND (post_created_at < now()))
8. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 3 (cost=0.00..0.39 rows=1 width=48) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..0.38 rows=1 width=44) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on questions questions_1 (cost=0.00..2.63 rows=7 width=44) (actual rows= loops=)

  • Filter: (answered AND (post_created_at < now()))
11. 0.000 0.000 ↓ 0.0

Seq Scan on external_content (cost=0.00..1.03 rows=1 width=48) (actual rows= loops=)

  • Filter: (post_created_at < now())
12. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 5 (cost=0.00..1.04 rows=1 width=48) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on swaminars (cost=0.00..1.03 rows=1 width=44) (actual rows= loops=)

  • Filter: (post_created_at < now())
14. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 6 (cost=0.00..2.40 rows=7 width=48) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on events (cost=0.00..2.31 rows=7 width=44) (actual rows= loops=)

  • Filter: (post_created_at < now())
16. 0.000 0.000 ↓ 0.0

Seq Scan on users_books (cost=0.00..1.01 rows=1 width=48) (actual rows= loops=)

  • Filter: (post_created_at < now())
17. 0.000 0.000 ↓ 0.0

Seq Scan on rak_stories (cost=0.00..7.71 rows=16 width=48) (actual rows= loops=)

  • Filter: (approved_at < now())
18. 0.000 0.000 ↓ 0.0

Seq Scan on trivia (cost=0.00..1.15 rows=3 width=48) (actual rows= loops=)

  • Filter: (post_created_at < now())
19. 0.000 0.000 ↓ 0.0

Seq Scan on users_badges (cost=0.00..3.05 rows=10 width=48) (actual rows= loops=)

  • Filter: ((to_timestamp((((badges_and_achievements -> 'badges'::text) -> (badges_and_achievements ->> 'currentBadgeId'::text)) ->> 'earnedAt'::text), '[YYYY,MM,DD,HH,MI,SS]'::text))::timestamp without time zone < now())