explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TP5X

Settings
# exclusive inclusive rows x rows loops node
1. 14.200 792.592 ↓ 7.7 36,519 1

HashAggregate (cost=853,682.71..853,729.94 rows=4,723 width=16) (actual time=788.136..792.592 rows=36,519 loops=1)

  • Group Key: clip.id
2. 2.753 778.392 ↓ 7.7 36,522 1

Append (cost=12,988.61..853,670.90 rows=4,723 width=16) (actual time=735.844..778.392 rows=36,522 loops=1)

3. 668.511 738.342 ↑ 515.9 7 1

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

  • Recheck Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
  • Rows Removed by Index Recheck: 161,360
  • Filter: (((to_tsvector('simple'::regconfig, COALESCE(title, ''::text)) || to_tsvector('simple'::regconfig, COALESCE(description, ''::text))) @@ '''drink'''::tsquery) OR ((to_tsvector('english'::regconfig, COALESCE(title, ''::text)) || to_tsvector('english'::regconfig, COALESCE(description, ''::text))) @@ '''drink'''::tsquery))
  • Rows Removed by Filter: 377,024
  • Heap Blocks: exact=33,897 lossy=53,151
4. 69.831 69.831 ↓ 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=69.831..69.831 rows=377,031 loops=1)

  • Index Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
5. 3.832 37.297 ↓ 32.8 36,515 1

Nested Loop (cost=356.20..72,695.05 rows=1,112 width=16) (actual time=12.348..37.297 rows=36,515 loops=1)

6. 2.515 2.883 ↑ 11.0 1 1

Bitmap Heap Scan on smart_tag (cost=309.25..2,561.65 rows=11 width=16) (actual time=2.858..2.883 rows=1 loops=1)

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

Bitmap Index Scan on smart_tag_workspace_id_label_key (cost=0.00..309.24 rows=2,243 width=0) (actual time=0.368..0.368 rows=1,766 loops=1)

  • Index Cond: (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid)
8. 24.325 30.582 ↓ 19.7 36,515 1

Bitmap Heap Scan on clip_smart_tag (cost=46.95..6,357.19 rows=1,857 width=32) (actual time=9.485..30.582 rows=36,515 loops=1)

  • Recheck Cond: (smart_tag_id = smart_tag.id)
  • Heap Blocks: exact=19,147
9. 6.257 6.257 ↓ 19.7 36,515 1

Bitmap Index Scan on clip_smart_tag_id_index (cost=0.00..46.49 rows=1,857 width=0) (actual time=6.257..6.257 rows=36,515 loops=1)

  • Index Cond: (smart_tag_id = smart_tag.id)