explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w6vI : Optimization for: Optimization for: plan #3rrJ; plan #HDW7

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 15,117.214 89,927.356 ↓ 200.8 8,096,051 1

Gather (cost=23,137.87..985,900.99 rows=40,327 width=1,426) (actual time=62,321.236..89,927.356 rows=8,096,051 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 33,133.978 74,810.142 ↓ 160.6 2,698,684 3 / 3

Parallel Hash Left Join (cost=22,137.87..980,868.29 rows=16,803 width=1,426) (actual time=62,316.976..74,810.142 rows=2,698,684 loops=3)

  • Hash Cond: ((epv.peo_id = eper.peo_id) AND (epv.employee_id = eper.employee_id))
3. 41,469.603 41,469.603 ↓ 160.6 2,698,684 3 / 3

Parallel Seq Scan on epv (cost=0.00..950,434.21 rows=16,803 width=1,239) (actual time=4.746..41,469.603 rows=2,698,684 loops=3)

  • Filter: (lower(status) = 'prnt'::text)
  • Rows Removed by Filter: 72
4. 90.686 206.561 ↑ 1.3 91,463 3 / 3

Parallel Hash (cost=17,396.95..17,396.95 rows=114,595 width=192) (actual time=206.561..206.561 rows=91,463 loops=3)

  • Buckets: 32768 Batches: 16 Memory Usage: 2304kB
5. 115.875 115.875 ↑ 1.3 91,463 3 / 3

Parallel Seq Scan on employee_per eper (cost=0.00..17,396.95 rows=114,595 width=192) (actual time=0.007..115.875 rows=91,463 loops=3)

Planning time : 0.642 ms
Execution time : 90,587.142 ms