explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bCsR

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

Limit (cost=268,824.23..268,824.25 rows=8 width=770) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=268,824.23..268,837.29 rows=5,224 width=770) (actual rows= loops=)

  • Sort Key: (COALESCE(swp.pinned, false)) DESC, swc.comment_create_date DESC
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=181,945.72..268,719.75 rows=5,224 width=770) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=181,945.29..226,634.05 rows=5,224 width=187) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=181,944.72..181,996.96 rows=5,224 width=8) (actual rows= loops=)

  • Group Key: wp.id
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,628.76..181,931.66 rows=5,224 width=8) (actual rows= loops=)

  • Join Filter: (wc.type_code = wct.code)
7. 0.000 0.000 ↓ 0.0

Gather (cost=1,628.76..180,964.08 rows=13,582 width=17) (actual rows= loops=)

  • Workers Planned: 2
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=628.76..178,605.88 rows=5,659 width=17) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on wall_posts wp (cost=628.33..93,551.40 rows=10,533 width=16) (actual rows= loops=)

  • Recheck Cond: ((group_id = 182) AND (status_code = 'A'::bpchar))
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on wall_posts_group_id_status_code (cost=0.00..622.01 rows=25,279 width=0) (actual rows= loops=)

  • Index Cond: (group_id = 182)
11. 0.000 0.000 ↓ 0.0

Index Scan using wall_comments_thread_wall_comment_id on wall_comments wc (cost=0.43..8.08 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (id = wp.wall_comment_id)
12. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.19 rows=5 width=10) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on wall_comment_types wct (cost=0.00..1.16 rows=5 width=10) (actual rows= loops=)

  • Filter: (type <> 'TODO'::text)
14. 0.000 0.000 ↓ 0.0

Index Scan using wall_posts_pkey on wall_posts swp (cost=0.57..8.54 rows=1 width=187) (actual rows= loops=)

  • Index Cond: (id = wp.id)
15. 0.000 0.000 ↓ 0.0

Index Scan using wall_comments_pkey on wall_comments swc (cost=0.43..8.06 rows=1 width=582) (actual rows= loops=)

  • Index Cond: (id = swp.wall_comment_id)