explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9QBg

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=149,440.06..149,440.18 rows=1 width=1,450) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=149,440.06..153,320.20 rows=33,256 width=1,450) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=148,440.04..148,481.61 rows=16,628 width=1,450) (actual rows= loops=)

  • Sort Key: (ts_rank_cd(to_tsvector('english'::regconfig, content), '''danger'''::tsquery)) DESC
4. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on mail_mail (cost=389.29..148,356.90 rows=16,628 width=1,450) (actual rows= loops=)

  • Recheck Cond: (to_tsvector('english'::regconfig, content) @@ '''danger'''::tsquery)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mail_mail_content_index (cost=0.00..379.31 rows=39,908 width=0) (actual rows= loops=)

  • Index Cond: (to_tsvector('english'::regconfig, content) @@ '''danger'''::tsquery)