explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D4v0

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.020 ↓ 0.0 0 1

GroupAggregate (cost=58.64..6,765.71 rows=1 width=32) (actual time=0.020..0.020 rows=0 loops=1)

  • Group Key: p.parent_post_id
2. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=58.64..6,765.68 rows=1 width=23) (actual time=0.019..0.019 rows=0 loops=1)

3. 0.018 0.018 ↓ 0.0 0 1

Index Scan using posts_parent_post_id_idx on posts p (cost=0.29..8.31 rows=1 width=16) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (parent_post_id IS NOT NULL)
  • Filter: (is_challenge IS TRUE)
4. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on likes l (cost=58.35..6,734.25 rows=2,313 width=23) (never executed)

  • Recheck Cond: (post_id = p.parent_post_id)
5. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on likes_post_id_idx (cost=0.00..57.77 rows=2,313 width=0) (never executed)

  • Index Cond: (post_id = p.parent_post_id)
Planning time : 0.265 ms
Execution time : 0.085 ms