explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EqV7

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 135.109 ↑ 1.0 1 1

Finalize Aggregate (cost=107,395.40..107,395.41 rows=1 width=8) (actual time=135.108..135.109 rows=1 loops=1)

2. 41.146 171.207 ↓ 1.5 3 1

Gather (cost=107,395.19..107,395.40 rows=2 width=8) (actual time=134.520..171.207 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2.108 130.061 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=106,395.19..106,395.20 rows=1 width=8) (actual time=130.061..130.061 rows=1 loops=3)

4. 118.224 127.953 ↑ 1.3 28,949 3 / 3

Parallel Bitmap Heap Scan on screening_applicant_amit sa (cost=909.55..106,298.24 rows=38,780 width=0) (actual time=39.576..127.953 rows=28,949 loops=3)

  • Recheck Cond: (tsname @@ to_tsquery('Theodore | J | Thomas'::text))
  • Heap Blocks: exact=33,853
5. 9.729 9.729 ↑ 1.1 86,847 1 / 3

Bitmap Index Scan on screenning_applicant_amit_name_idx (cost=0.00..886.29 rows=93,072 width=0) (actual time=29.188..29.188 rows=86,847 loops=1)

  • Index Cond: (tsname @@ to_tsquery('Theodore | J | Thomas'::text))