explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jVjyr

Settings
# exclusive inclusive rows x rows loops node
1. 16.912 785.159 ↓ 11.0 40,910 1

HashAggregate (cost=787,786.06..787,823.16 rows=3,710 width=16) (actual time=779.380..785.159 rows=40,910 loops=1)

  • Group Key: clip.id
2. 2.646 768.247 ↓ 11.0 40,910 1

Append (cost=12,988.61..787,776.78 rows=3,710 width=16) (actual time=738.011..768.247 rows=40,910 loops=1)

3. 671.869 727.560 ↓ 0.0 0 1

Bitmap Heap Scan on clip (cost=12,988.61..780,928.62 rows=3,611 width=16) (actual time=727.560..727.560 rows=0 loops=1)

  • Recheck Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
  • Rows Removed by Index Recheck: 161361
  • Filter: (((to_tsvector('simple'::regconfig, COALESCE(title, ''::text)) || to_tsvector('simple'::regconfig, COALESCE(description, ''::text))) @@ '''burger'''::tsquery) OR ((to_tsvector('english'::regconfig, COALESCE(title, ''::text)) || to_tsvector('english'::regconfig, COALESCE(description, ''::text))) @@ '''burger'''::tsquery))
  • Rows Removed by Filter: 377031
  • Heap Blocks: exact=33897 lossy=53151
4. 55.691 55.691 ↓ 1.0 377,031 1

Bitmap Index Scan on clip_workspace_id_index (cost=0.00..12,987.71 rows=362,037 width=0) (actual time=55.691..55.691 rows=377,031 loops=1)

  • Index Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
5. 3.984 38.041 ↓ 413.2 40,910 1

Nested Loop (cost=47.37..6,811.07 rows=99 width=16) (actual time=10.449..38.041 rows=40,910 loops=1)

6. 0.022 0.022 ↑ 1.0 1 1

Index Scan using smart_tag_workspace_id_label_key on smart_tag (cost=0.42..8.44 rows=1 width=16) (actual time=0.018..0.022 rows=1 loops=1)

  • Index Cond: ((workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid) AND (label = 'burger'::text))
7. 27.057 34.035 ↓ 22.0 40,910 1

Bitmap Heap Scan on clip_smart_tag (cost=46.95..6,784.06 rows=1,857 width=32) (actual time=10.426..34.035 rows=40,910 loops=1)

  • Recheck Cond: (smart_tag_id = smart_tag.id)
  • Heap Blocks: exact=20084
8. 6.978 6.978 ↓ 22.0 40,910 1

Bitmap Index Scan on clip_smart_tag_id_index (cost=0.00..46.49 rows=1,857 width=0) (actual time=6.978..6.978 rows=40,910 loops=1)

  • Index Cond: (smart_tag_id = smart_tag.id)
Planning time : 0.388 ms