explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iD6r

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 841.028 ↓ 0.0 0 1

HashAggregate (cost=787,782.57..787,819.67 rows=3,710 width=16) (actual time=841.028..841.028 rows=0 loops=1)

  • Group Key: clip.id
2. 0.001 841.021 ↓ 0.0 0 1

Append (cost=12,988.61..787,773.29 rows=3,710 width=16) (actual time=841.021..841.021 rows=0 loops=1)

3. 759.175 840.995 ↓ 0.0 0 1

Bitmap Heap Scan on clip (cost=12,988.61..780,928.62 rows=3,611 width=16) (actual time=840.995..840.995 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. 81.820 81.820 ↓ 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=81.820..81.820 rows=377,031 loops=1)

  • Index Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
5. 0.001 0.025 ↓ 0.0 0 1

Nested Loop (cost=47.36..6,807.57 rows=99 width=16) (actual time=0.025..0.025 rows=0 loops=1)

6. 0.024 0.024 ↓ 0.0 0 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.024..0.024 rows=0 loops=1)

  • Index Cond: ((workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid) AND (label = 'Restaurant'::text))
7. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on clip_smart_tag (cost=46.94..6,780.57 rows=1,856 width=32) (never executed)

  • Recheck Cond: (smart_tag_id = smart_tag.id)
8. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on clip_smart_tag_id_index (cost=0.00..46.48 rows=1,856 width=0) (never executed)

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