explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kX4D : V1

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

Unique (cost=43.76..43.79 rows=1 width=108) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=43.76..43.76 rows=1 width=108) (actual rows= loops=)

  • Sort Key: problems.id, problems.created_at, problems.updated_at, problems.deleted_at, problems."position", problems.config, problems.state, problems.owner_type, problems.owner_id
3. 0.000 0.000 ↓ 0.0

Group (cost=26.87..43.75 rows=1 width=108) (actual rows= loops=)

  • Group Key: problems.id
4. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=26.87..43.75 rows=1 width=108) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=26.72..43.35 rows=2 width=116) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=25.19..33.27 rows=1 width=108) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Merge Join (cost=25.04..25.10 rows=1 width=116) (actual rows= loops=)

  • Merge Cond: (problems.id = subject_problems.problem_id)
8. 0.000 0.000 ↓ 0.0

Sort (cost=11.30..11.31 rows=3 width=108) (actual rows= loops=)

  • Sort Key: problems.id
9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on problems (cost=4.17..11.27 rows=3 width=108) (actual rows= loops=)

  • Recheck Cond: (deleted_at IS NULL)
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_problems_on_deleted_at (cost=0.00..4.17 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (deleted_at IS NULL)
11. 0.000 0.000 ↓ 0.0

Sort (cost=13.74..13.76 rows=6 width=16) (actual rows= loops=)

  • Sort Key: subject_problems.problem_id
12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on subject_problems (cost=4.20..13.67 rows=6 width=16) (actual rows= loops=)

  • Recheck Cond: (subject_id = 7,105,430)
13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_subject_problems_on_subject_id (cost=0.00..4.20 rows=6 width=0) (actual rows= loops=)

  • Index Cond: (subject_id = 7,105,430)
14. 0.000 0.000 ↓ 0.0

Index Scan using subjects_pkey on subjects (cost=0.15..8.17 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = 7,105,430)
  • Filter: (deleted_at IS NULL)
15. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on topic_problems (cost=1.53..10.02 rows=6 width=16) (actual rows= loops=)

  • Recheck Cond: (problem_id = problems.id)
16. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_topic_problems_on_problem_id (cost=0.00..1.53 rows=6 width=0) (actual rows= loops=)

  • Index Cond: (problem_id = problems.id)
17. 0.000 0.000 ↓ 0.0

Index Only Scan using topics_pkey on topics (cost=0.15..0.20 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = topic_problems.topic_id)