explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vH7b

Settings
# exclusive inclusive rows x rows loops node
1. 27.384 828.830 ↓ 12.9 60,802 1

HashAggregate (cost=853,653.39..853,700.42 rows=4,703 width=16) (actual time=818.505..828.830 rows=60,802 loops=1)

  • Group Key: clip.id
2. 3.757 801.446 ↓ 12.9 60,802 1

Append (cost=12,988.61..853,641.64 rows=4,703 width=16) (actual time=759.636..801.446 rows=60,802 loops=1)

3. 682.151 743.175 ↓ 0.0 0 1

Bitmap Heap Scan on clip (cost=12,988.61..780,928.62 rows=3,611 width=16) (actual time=743.175..743.175 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))) @@ '''restaurant'''::tsquery) OR ((to_tsvector('english'::regconfig, COALESCE(title, ''::text)) || to_tsvector('english'::regconfig, COALESCE(description, ''::text))) @@ '''restaur'''::tsquery))
  • Rows Removed by Filter: 377031
  • Heap Blocks: exact=33897 lossy=53151
4. 61.024 61.024 ↓ 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=61.024..61.024 rows=377,031 loops=1)

  • Index Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
5. 5.809 54.514 ↓ 55.7 60,802 1

Nested Loop (cost=356.50..72,665.99 rows=1,092 width=16) (actual time=16.460..54.514 rows=60,802 loops=1)

6. 2.574 2.956 ↑ 11.0 1 1

Bitmap Heap Scan on smart_tag (cost=309.56..2,571.37 rows=11 width=16) (actual time=2.929..2.956 rows=1 loops=1)

  • Recheck Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
  • Filter: (to_tsvector('simple'::regconfig, COALESCE(label, ''::text)) @@ '''restaurant'''::tsquery)
  • Rows Removed by Filter: 1765
  • Heap Blocks: exact=449
7. 0.382 0.382 ↑ 1.3 1,766 1

Bitmap Index Scan on smart_tag_workspace_id_label_key (cost=0.00..309.56 rows=2,285 width=0) (actual time=0.382..0.382 rows=1,766 loops=1)

  • Index Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
8. 36.219 45.749 ↓ 32.8 60,802 1

Bitmap Heap Scan on clip_smart_tag (cost=46.94..6,353.68 rows=1,856 width=32) (actual time=13.521..45.749 rows=60,802 loops=1)

  • Recheck Cond: (smart_tag_id = smart_tag.id)
  • Heap Blocks: exact=23146
9. 9.530 9.530 ↓ 32.8 60,802 1

Bitmap Index Scan on clip_smart_tag_id_index (cost=0.00..46.48 rows=1,856 width=0) (actual time=9.530..9.530 rows=60,802 loops=1)

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