explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WqvQ : No filter

Settings
# exclusive inclusive rows x rows loops node
1. 1.300 419.803 ↑ 5.2 72 1

GroupAggregate (cost=105,397.60..105,433.13 rows=374 width=610) (actual time=418.496..419.803 rows=72 loops=1)

  • Group Key: clip.created_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.recorded_at, clip.updated_at, clip.digitized, clip.hash, clip.synced, 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, clip_bookmark.clip_id
2. 1.101 418.503 ↑ 1.3 293 1

Sort (cost=105,397.60..105,398.53 rows=374 width=585) (actual time=418.469..418.503 rows=293 loops=1)

  • Sort Key: clip.created_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.recorded_at, clip.updated_at, clip.digitized, clip.hash, clip.synced, 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, clip_bookmark.clip_id
  • Sort Method: quicksort Memory: 175kB
3. 0.054 417.402 ↑ 1.3 293 1

Nested Loop Left Join (cost=103,612.00..105,381.62 rows=374 width=585) (actual time=416.161..417.402 rows=293 loops=1)

4. 0.030 414.612 ↑ 1.0 72 1

Hash Left Join (cost=103,611.28..104,221.79 rows=72 width=545) (actual time=414.263..414.612 rows=72 loops=1)

  • Hash Cond: (clip.id = clip_bookmark.clip_id)
5. 0.081 414.358 ↑ 1.0 72 1

Hash Join (cost=103,561.28..104,171.33 rows=72 width=529) (actual time=414.029..414.358 rows=72 loops=1)

  • Hash Cond: (clip.account_id = account.id)
6. 0.040 411.981 ↑ 1.0 72 1

Nested Loop (cost=103,256.14..103,865.20 rows=72 width=516) (actual time=411.683..411.981 rows=72 loops=1)

7. 0.009 409.709 ↑ 1.0 72 1

Limit (cost=103,255.72..103,255.90 rows=72 width=342) (actual time=409.677..409.709 rows=72 loops=1)

8. 120.554 409.700 ↑ 3,590.5 72 1

Sort (cost=103,255.72..103,902.00 rows=258,513 width=342) (actual time=409.675..409.700 rows=72 loops=1)

  • Sort Key: clip.created_at DESC, clip.id DESC
  • Sort Method: top-N heapsort Memory: 44kB
9. 289.146 289.146 ↑ 1.0 255,952 1

Seq Scan on clip (cost=0.00..93,988.12 rows=258,513 width=342) (actual time=0.101..289.146 rows=255,952 loops=1)

  • Filter: (workspace_id = '8271b633-a524-46e8-9620-c2d15c7ce3c6'::uuid)
  • Rows Removed by Filter: 373957
10. 2.232 2.232 ↑ 1.0 1 72

Index Scan using clip_media_pkey on clip_media (cost=0.42..8.44 rows=1 width=206) (actual time=0.031..0.031 rows=1 loops=72)

  • Index Cond: (id = clip.media_id)
11. 1.282 2.296 ↓ 1.0 6,098 1

Hash (cost=228.95..228.95 rows=6,095 width=29) (actual time=2.296..2.296 rows=6,098 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 433kB
12. 1.014 1.014 ↓ 1.0 6,098 1

Seq Scan on account (cost=0.00..228.95 rows=6,095 width=29) (actual time=0.005..1.014 rows=6,098 loops=1)

13. 0.000 0.224 ↓ 0.0 0 1

Hash (cost=49.96..49.96 rows=3 width=16) (actual time=0.224..0.224 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
14. 0.224 0.224 ↓ 0.0 0 1

Seq Scan on clip_bookmark (cost=0.00..49.96 rows=3 width=16) (actual time=0.224..0.224 rows=0 loops=1)

  • Filter: (account_id = '505e48ea-de53-46a3-9d43-b974ecdedafd'::uuid)
  • Rows Removed by Filter: 2477
15. 0.212 2.736 ↑ 1.2 4 72

Nested Loop Left Join (cost=0.72..16.06 rows=5 width=56) (actual time=0.032..0.038 rows=4 loops=72)

16. 2.232 2.232 ↑ 1.2 4 72

Index Only Scan using clip_tag_clip_id_tag_id_key on clip_tag (cost=0.43..14.46 rows=5 width=32) (actual time=0.030..0.031 rows=4 loops=72)

  • Index Cond: (clip_id = clip.id)
  • Heap Fetches: 292
17. 0.292 0.292 ↑ 1.0 1 292

Index Scan using tag_pkey on tag (cost=0.29..0.31 rows=1 width=40) (actual time=0.001..0.001 rows=1 loops=292)

  • Index Cond: (id = clip_tag.tag_id)
Planning time : 1.213 ms