explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x3ni

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,224.521 2,197.843 ↓ 1.2 79,355 1

Hash Join (cost=36,982.24..353,895.85 rows=68,160 width=16) (actual time=115.882..2,197.843 rows=79,355 loops=1)

  • Hash Cond: (clip_smart_tag.smart_tag_id = smart_tag.id)
2. 858.162 858.162 ↑ 1.0 13,621,163 1

Seq Scan on clip_smart_tag (cost=0.00..265,095.10 rows=13,636,510 width=32) (actual time=0.005..858.162 rows=13,621,163 loops=1)

3. 0.068 115.160 ↑ 3.5 190 1

Hash (cost=36,973.81..36,973.81 rows=674 width=16) (actual time=115.159..115.160 rows=190 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 17kB
4. 115.092 115.092 ↑ 3.5 190 1

Seq Scan on smart_tag (cost=0.00..36,973.81 rows=674 width=16) (actual time=0.608..115.092 rows=190 loops=1)

  • Filter: (to_tsvector('simple'::regconfig, COALESCE(label, ''::text)) @@ '''drink'''::tsquery)
  • Rows Removed by Filter: 106,877