explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SVl

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

Finalize Aggregate (cost=84,865.44..84,865.45 rows=1 width=8) (actual time=223.583..223.583 rows=1 loops=1)

2. 19.008 239.047 ↓ 1.5 3 1

Gather (cost=84,865.23..84,865.43 rows=2 width=8) (actual time=223.222..239.047 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 20.816 220.039 ↑ 1.0 1 3

Partial Aggregate (cost=83,865.23..83,865.24 rows=1 width=8) (actual time=220.038..220.039 rows=1 loops=3)

4. 145.564 199.223 ↑ 1.2 166,667 3

Parallel Bitmap Heap Scan on randomuserentity (cost=9,325.60..83,346.79 rows=207,375 width=8) (actual time=62.038..199.223 rows=166,667 loops=3)

  • Recheck Cond: ((gender)::text = 'FEMALE'::text)
  • Heap Blocks: exact=11649
5. 53.659 53.659 ↓ 1.0 500,000 1

Bitmap Index Scan on randomuserentity_gender_idx (cost=0.00..9,201.17 rows=497,700 width=0) (actual time=53.659..53.659 rows=500,000 loops=1)

  • Index Cond: ((gender)::text = 'FEMALE'::text)