explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 706S

Settings
# exclusive inclusive rows x rows loops node
1. 17.220 827.806 ↓ 8.7 40,910 1

HashAggregate (cost=853,692.11..853,739.14 rows=4,703 width=16) (actual time=821.444..827.806 rows=40,910 loops=1)

  • Group Key: clip.id
2. 2.506 810.586 ↓ 8.7 40,910 1

Append (cost=12,988.61..853,680.35 rows=4,703 width=16) (actual time=780.845..810.586 rows=40,910 loops=1)

3. 694.910 767.563 ↓ 0.0 0 1

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

  • Recheck Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
  • Rows Removed by Index Recheck: 161360
  • 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. 72.653 72.653 ↓ 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=72.653..72.653 rows=377,031 loops=1)

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

Nested Loop (cost=356.51..72,704.70 rows=1,092 width=16) (actual time=13.280..40.517 rows=40,910 loops=1)

6. 2.558 2.934 ↑ 11.0 1 1

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

  • Recheck Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
  • Filter: (to_tsvector('simple'::regconfig, COALESCE(label, ''::text)) @@ '''burger'''::tsquery)
  • Rows Removed by Filter: 1765
  • Heap Blocks: exact=449
7. 0.376 0.376 ↑ 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.376..0.376 rows=1,766 loops=1)

  • Index Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
8. 26.670 33.637 ↓ 22.0 40,910 1

Bitmap Heap Scan on clip_smart_tag (cost=46.95..6,357.19 rows=1,857 width=32) (actual time=10.376..33.637 rows=40,910 loops=1)

  • Recheck Cond: (smart_tag_id = smart_tag.id)
  • Heap Blocks: exact=20084
9. 6.967 6.967 ↓ 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.967..6.967 rows=40,910 loops=1)

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