explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 21,169.291 237,962.197 ↓ 200.8 8,096,051 1

Gather (cost=23,137.87..1,262,365.86 rows=40,327 width=1,522) (actual time=66,393.479..237,962.197 rows=8,096,051 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 38,828.640 79,160.039 ↓ 160.6 2,698,684 3 / 3

Parallel Hash Left Join (cost=22,137.87..982,706.29 rows=16,803 width=1,863) (actual time=66,352.695..79,160.039 rows=2,698,684 loops=3)

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

Parallel Seq Scan on epv (cost=0.00..950,434.21 rows=16,803 width=1,684) (actual time=5.620..40,122.604 rows=2,698,684 loops=3)

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

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

  • Buckets: 32768 Batches: 16 Memory Usage: 2336kB
5. 115.798 115.798 ↑ 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.006..115.798 rows=91,463 loops=3)

6.          

SubPlan (for Gather)

7. 0.000 97,152.612 ↓ 0.0 0 8,096,051

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.012..0.012 rows=0 loops=8,096,051)

8. 97,152.612 97,152.612 ↓ 0.0 0 8,096,051

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.012..0.012 rows=0 loops=8,096,051)

9. 0.000 0.000 ↑ 1.0 1 8,096,051

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=8,096,051)

10. 8,096.051 24,288.153 ↓ 0.0 0 8,096,051

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.003..0.003 rows=0 loops=8,096,051)

11. 16,192.102 16,192.102 ↓ 0.0 0 8,096,051

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=8,096,051)

12. 0.000 0.000 ↑ 1.0 1 8,096,051

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=8,096,051)

13. 0.000 16,192.102 ↓ 0.0 0 8,096,051

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=8,096,051)

14. 16,192.102 16,192.102 ↓ 0.0 0 8,096,051

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=8,096,051)

15. 0.000 0.000 ↑ 1.0 1 8,096,051

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=8,096,051)

Planning time : 0.621 ms
Execution time : 238,524.552 ms