explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i94O : Optimization for: plan #E2f

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 51.611 1,120.627 ↓ 0.0 0 1

Gather (cost=65,015.39..86,011.81 rows=123 width=28) (actual time=1,087.883..1,120.627 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 131.559 1,069.016 ↓ 0.0 0 3

Parallel Hash Join (cost=64,015.39..84,999.51 rows=51 width=28) (actual time=1,069.015..1,069.016 rows=0 loops=3)

  • Hash Cond: (p.id = pns.id)
  • Join Filter: ((p.updated_date >= '2019-08-01'::date) OR (b.updated_date >= '2019-08-01'::date))
  • Rows Removed by Join Filter: 205231
3. 61.094 61.094 ↑ 1.2 205,425 3

Parallel Seq Scan on so_person p (cost=0.00..18,417.81 rows=256,781 width=28) (actual time=0.016..61.094 rows=205,425 loops=3)

4. 142.346 876.363 ↑ 1.3 205,231 3

Parallel Hash (cost=60,808.64..60,808.64 rows=256,540 width=16) (actual time=876.363..876.363 rows=205,231 loops=3)

  • Buckets: 1048576 Batches: 1 Memory Usage: 37152kB
5. 286.866 734.017 ↑ 1.3 205,231 3

Parallel Hash Join (cost=13,402.98..60,808.64 rows=256,540 width=16) (actual time=352.738..734.017 rows=205,231 loops=3)

  • Hash Cond: (b.id = pns.beard)
6. 174.715 174.715 ↑ 1.3 372,588 3

Parallel Seq Scan on so_beard b (cost=0.00..44,589.72 rows=465,872 width=16) (actual time=0.027..174.715 rows=372,588 loops=3)

7. 152.079 272.436 ↑ 1.3 205,231 3

Parallel Hash (cost=10,196.23..10,196.23 rows=256,540 width=16) (actual time=272.436..272.436 rows=205,231 loops=3)

  • Buckets: 1048576 Batches: 1 Memory Usage: 37152kB
8. 120.357 120.357 ↑ 1.3 205,231 3

Parallel Seq Scan on so_personnonsys pns (cost=0.00..10,196.23 rows=256,540 width=16) (actual time=0.056..120.357 rows=205,231 loops=3)

  • Filter: ((module = 279) AND (module_type = 1015))
  • Rows Removed by Filter: 8
Planning time : 2.109 ms
Execution time : 1,120.773 ms