explain.depesz.com

PostgreSQL's explain analyze made readable

Result: J6xL

Settings
# exclusive inclusive rows x rows loops node
1. 14.370 119.317 ↓ 12.2 36,519 1

HashAggregate (cost=93,620.61..93,650.54 rows=2,993 width=16) (actual time=114.743..119.317 rows=36,519 loops=1)

  • Group Key: clip.id
2. 2.553 104.947 ↓ 12.2 36,522 1

Append (cost=13,263.19..93,613.13 rows=2,993 width=16) (actual time=64.092..104.947 rows=36,522 loops=1)

3. 9.076 64.931 ↑ 268.7 7 1

Bitmap Heap Scan on clip (cost=13,263.19..20,888.02 rows=1,881 width=16) (actual time=64.092..64.931 rows=7 loops=1)

  • Recheck Cond: ((to_tsvector('english'::regconfig, ((COALESCE(title, ''::text) || ' '::text) || COALESCE(description, ''::text))) @@ '''drink'''::tsquery) AND (workspace_id = '1f32d99e-2062-43cb-b9a8-7ae13ab7c977'::uuid))
  • Rows Removed by Index Recheck: 98
  • Heap Blocks: exact=98
4. 0.608 55.855 ↓ 0.0 0 1

BitmapAnd (cost=13,263.19..13,263.19 rows=1,881 width=0) (actual time=55.855..55.855 rows=0 loops=1)

5. 0.518 0.518 ↑ 7.0 2,374 1

Bitmap Index Scan on clip_title_description_english_idx (cost=0.00..167.80 rows=16,506 width=0) (actual time=0.518..0.518 rows=2,374 loops=1)

  • Index Cond: (to_tsvector('english'::regconfig, ((COALESCE(title, ''::text) || ' '::text) || COALESCE(description, ''::text))) @@ '''drink'''::tsquery)
6. 54.729 54.729 ↓ 1.0 377,031 1

Bitmap Index Scan on clip_workspace_id_index (cost=0.00..13,094.20 rows=376,236 width=0) (actual time=54.729..54.729 rows=377,031 loops=1)

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

Nested Loop (cost=356.20..72,695.18 rows=1,112 width=16) (actual time=12.374..37.463 rows=36,515 loops=1)

8. 2.702 3.077 ↑ 11.0 1 1

Bitmap Heap Scan on smart_tag (cost=309.25..2,561.65 rows=11 width=16) (actual time=3.048..3.077 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: 1765
  • Heap Blocks: exact=449
9. 0.375 0.375 ↑ 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.375..0.375 rows=1,766 loops=1)

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

Bitmap Heap Scan on clip_smart_tag (cost=46.95..6,357.21 rows=1,857 width=32) (actual time=9.321..30.843 rows=36,515 loops=1)

  • Recheck Cond: (smart_tag_id = smart_tag.id)
  • Heap Blocks: exact=19147
11. 6.095 6.095 ↓ 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.095..6.095 rows=36,515 loops=1)

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