explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z9V1 : Optimization for: plan #9QBg

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.005 103,691.976 ↑ 1.0 1 1

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

2. 0.000 103,691.971 ↑ 33,256.0 1 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 76.278 310,791.102 ↑ 16,628.0 1 3

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

  • Sort Key: (ts_rank_cd(to_tsvector('english'::regconfig, content), '''danger'''::tsquery)) DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Worker 0: Sort Method: top-N heapsort Memory: 25kB
  • Worker 1: Sort Method: top-N heapsort Memory: 25kB
4. 310,693.366 310,714.824 ↑ 1.5 11,116 3

Parallel Bitmap Heap Scan on mail_mail (cost=389.29..148,356.90 rows=16,628 width=1,450) (actual time=45.962..103,571.608 rows=11,116 loops=3)

  • Recheck Cond: (to_tsvector('english'::regconfig, content) @@ '''danger'''::tsquery)
  • Heap Blocks: exact=10899
5. 21.458 21.458 ↑ 1.2 33,347 1

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

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