explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TogZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.989 8.237 ↑ 3.5 73 1

GroupAggregate (cost=1,771.33..3,038.53 rows=256 width=761) (actual time=7.291..8.237 rows=73 loops=1)

  • Group Key: clip.recorded_at, clip.id, clip.account_id, clip.workspace_id, clip.width, clip.height, clip.size, clip.ext, clip.type, clip.duration, clip.rotation, clip.audio, clip.remote, clip.status, clip.created_at, clip.updated_at, clip.digitized, clip.hash, clip.synced, clip.title, clip.description, clip.source, clip.imported_name, clip_media.playback, clip_media.preview, clip_media.seek, clip_media.image, account.first_name, account.last_name, account.avatar, clip_bookmark.clip_id
2. 0.698 6.666 ↑ 1.4 188 1

Sort (cost=1,771.33..1,771.97 rows=256 width=729) (actual time=6.608..6.666 rows=188 loops=1)

  • Sort Key: clip.recorded_at DESC, clip.id DESC, clip.account_id, clip.workspace_id, clip.width, clip.height, clip.size, clip.ext, clip.type, clip.duration, clip.rotation, clip.audio, clip.remote, clip.status, clip.created_at, clip.updated_at, clip.digitized, clip.hash, clip.synced, clip.title, clip.description, clip.source, clip.imported_name, clip_media.playback, clip_media.preview, clip_media.seek, clip_media.image, account.first_name, account.last_name, account.avatar, clip_bookmark.clip_id
  • Sort Method: quicksort Memory: 125kB
3. 0.268 5.968 ↑ 1.4 188 1

Nested Loop Left Join (cost=53.31..1,761.09 rows=256 width=729) (actual time=0.990..5.968 rows=188 loops=1)

4. 0.123 5.512 ↑ 1.4 188 1

Nested Loop Left Join (cost=53.03..1,679.94 rows=256 width=711) (actual time=0.982..5.512 rows=188 loops=1)

5. 0.065 3.710 ↑ 1.0 73 1

Hash Left Join (cost=52.62..1,245.83 rows=73 width=695) (actual time=0.971..3.710 rows=73 loops=1)

  • Hash Cond: (clip.id = clip_bookmark.clip_id)
6. 0.068 3.510 ↑ 1.0 73 1

Hash Join (cost=26.87..1,218.93 rows=73 width=679) (actual time=0.826..3.510 rows=73 loops=1)

  • Hash Cond: (clip.account_id = account.id)
7. 0.101 2.945 ↑ 1.0 73 1

Nested Loop (cost=0.84..1,191.90 rows=73 width=582) (actual time=0.312..2.945 rows=73 loops=1)

8. 0.032 2.552 ↑ 1.0 73 1

Limit (cost=0.42..578.32 rows=73 width=407) (actual time=0.301..2.552 rows=73 loops=1)

9. 2.520 2.520 ↑ 46.2 73 1

Index Scan Backward using clip_list_recorded_at_index on clip (cost=0.42..26,686.82 rows=3,371 width=407) (actual time=0.299..2.520 rows=73 loops=1)

  • Index Cond: (workspace_id = '82e5cd00-6f64-4b2a-92c8-950fca470448'::uuid)
10. 0.292 0.292 ↑ 1.0 1 73

Index Scan using clip_media_pkey on clip_media (cost=0.42..8.39 rows=1 width=207) (actual time=0.004..0.004 rows=1 loops=73)

  • Index Cond: (id = clip.media_id)
11. 0.254 0.497 ↓ 1.0 605 1

Hash (cost=18.79..18.79 rows=579 width=113) (actual time=0.496..0.497 rows=605 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 46kB
12. 0.243 0.243 ↓ 1.0 605 1

Seq Scan on account (cost=0.00..18.79 rows=579 width=113) (actual time=0.008..0.243 rows=605 loops=1)

13. 0.015 0.135 ↑ 1.0 34 1

Hash (cost=25.33..25.33 rows=34 width=16) (actual time=0.135..0.135 rows=34 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
14. 0.120 0.120 ↑ 1.0 34 1

Seq Scan on clip_bookmark (cost=0.00..25.33 rows=34 width=16) (actual time=0.008..0.120 rows=34 loops=1)

  • Filter: (account_id = '82e5cd00-6f64-4b2a-92c8-950fca470448'::uuid)
  • Rows Removed by Filter: 1192
15. 1.679 1.679 ↑ 2.0 2 73

Index Only Scan using clip_tag_clip_id_tag_id_key on clip_tag (cost=0.41..5.91 rows=4 width=32) (actual time=0.022..0.023 rows=2 loops=73)

  • Index Cond: (clip_id = clip.id)
  • Heap Fetches: 8
16. 0.188 0.188 ↑ 1.0 1 188

Index Scan using tag_pkey on tag (cost=0.28..0.31 rows=1 width=34) (actual time=0.001..0.001 rows=1 loops=188)

  • Index Cond: (id = clip_tag.tag_id)
17.          

SubPlan (for GroupAggregate)

18. 0.000 0.000 ↓ 0.0 0

Seq Scan on discussion (cost=0.00..4.85 rows=1 width=0) (never executed)

  • Filter: ((NOT resolved) AND (clip_id = clip.id))
19. 0.582 0.582 ↓ 1.1 106 1

Seq Scan on discussion discussion_1 (cost=0.00..4.48 rows=93 width=16) (actual time=0.006..0.582 rows=106 loops=1)

  • Filter: (NOT resolved)
  • Rows Removed by Filter: 58
Planning time : 2.258 ms