explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NVWf

Settings
# exclusive inclusive rows x rows loops node
1. 0.060 0.694 ↓ 1.1 28 1

Sort (cost=135.43..135.49 rows=25 width=223) (actual time=0.692..0.694 rows=28 loops=1)

  • Sort Key: wonderful_playback.playback_order DESC
  • Sort Method: quicksort Memory: 38kB
2. 0.012 0.634 ↓ 1.1 28 1

Nested Loop Left Join (cost=0.85..134.85 rows=25 width=223) (actual time=0.103..0.634 rows=28 loops=1)

3. 0.014 0.482 ↓ 1.1 28 1

Nested Loop Left Join (cost=0.56..117.84 rows=25 width=222) (actual time=0.090..0.482 rows=28 loops=1)

4. 0.030 0.300 ↓ 1.1 28 1

Nested Loop Left Join (cost=0.28..109.68 rows=25 width=118) (actual time=0.068..0.300 rows=28 loops=1)

5. 0.046 0.046 ↓ 1.1 28 1

Seq Scan on wonderful_playback (cost=0.00..6.18 rows=25 width=33) (actual time=0.036..0.046 rows=28 loops=1)

  • Filter: (NOT is_deleted)
  • Rows Removed by Filter: 190
6. 0.224 0.224 ↑ 1.0 1 28

Index Scan using lesson_lesson_id_idx on lesson (cost=0.28..4.14 rows=1 width=110) (actual time=0.008..0.008 rows=1 loops=28)

  • Index Cond: ((wonderful_playback.lesson_id)::text = (lesson_id)::text)
7. 0.168 0.168 ↑ 1.0 1 28

Index Scan using curriculum_pkey on curriculum (cost=0.28..0.33 rows=1 width=120) (actual time=0.006..0.006 rows=1 loops=28)

  • Index Cond: (lesson.curriculum_id = id)
8. 0.140 0.140 ↑ 1.0 1 28

Index Scan using user_teacher_pkey on user_teacher (cost=0.29..0.68 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=28)

  • Index Cond: (lesson.live_teacher_id = id)